Google analytics code

Monday, December 7, 2009

MySQL: Error 1305 - Function xxx does not exist

I ran into an odd issue on a project I updated awhile ago. I updated an existing sql statement to include IFNULL for an exclusion check. It worked fine on my dev machine, but caused an issue on the production machine.

The version of MySQL on my dev machine was a little bit newer than production so the issue never came up. Here is the error the sql server returned:
#1305 - FUNCTION [DATABASE_NAME].ifnull does not exist

Here is a little bit of the sql that caused the error:
AND IFNULL ( `tbl_category_admin`.`admin_key_id` =5, true )

The problem was caused by the space between IFNULL and (. Changing it to IFNULL( solved the problem. If you run into an issue where MySQL returns an error saying a given function does not exist look for spaces between the function and the "(".
Posted by at
Labels: , , , , ,

32 comments:

  1. Jan Rusch, GermanyDecember 17, 2009 at 11:45 AM

    That just happened to me. Thanks to you and Google, I was able to fix it in 5 minutes...

    Jan

    ReplyDelete
  2. rickDecember 18, 2009 at 6:28 AM

    Just encountered this exact same issue. Thanks for sharing.

    ReplyDelete
  3. BogdanMarch 1, 2010 at 12:35 AM

    Thank you very much. I have also had this problem with the CONCAT function. Deleting those spaces between 'CONCAT' and '(' worked for me as well.

    ReplyDelete
  4. AnonymousMarch 4, 2010 at 4:04 PM

    Thanks.

    'look for spaces between the function and the "(" ' - this solved the problem for me also.

    ReplyDelete
  5. AnonymousMay 11, 2010 at 10:26 AM

    thanks man !! thats one of these things that you can spend a whole night stucking your head on the table ;-) you just saved my precious time..

    ReplyDelete
  6. AnonymousAugust 3, 2010 at 2:58 AM

    THX mate ! 5 seconds of searching, and i though something is wrong with my pythons library ^^

    ReplyDelete
  7. AnonymousOctober 17, 2010 at 7:42 AM

    Thank you.
    Happend to my with version '5.0.77-log' (production server)
    but not with '5.1.37-1ubuntu5.4' (development server)

    ReplyDelete
  8. AnonymousFebruary 1, 2011 at 6:00 AM

    Thanks buddy, you saved my time.

    ReplyDelete
  9. AnonymousMarch 1, 2011 at 2:44 PM

    Thank you very much!

    ReplyDelete
  10. AnonymousApril 30, 2011 at 9:50 AM

    Train's is not stopping. Same problem.
    I was about to reinstall whole MySQL :D
    Thank you!

    ReplyDelete
  11. AnonymousJuly 26, 2011 at 2:03 PM

    oh wow, you just saved me endless frustration.
    Had it on the dev->production move aswell

    ReplyDelete
  12. AnonymousAugust 25, 2011 at 6:04 AM

    Thank you so much, i was ready to kill myself but then i found your blog.

    ReplyDelete
  13. AnonymousDecember 11, 2011 at 8:06 AM

    select newtime(if(new_event.newtime>160000, 2 , if(new_event.newtime>80000, 1, 0))) from new_event;


    the above code is giving me the 1305 error code. can u help me

    ReplyDelete
  14. metric152December 11, 2011 at 12:03 PM

    @anonymous the probably there is that function doesn't exist at all. Here is the page with all the time functions for mysql
    http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

    ReplyDelete
  15. AnonymousJanuary 26, 2012 at 8:08 AM

    After about 60 minutes of trying to figure out what the hel.. was going on...

    Good lookin out...

    ReplyDelete
  16. AnonymousMay 31, 2012 at 5:58 AM

    Thank you so much!!

    ReplyDelete
  17. GruzJune 27, 2012 at 5:32 AM

    You can't imagine how thankfull I am!

    Hail to you!

    ReplyDelete
  18. AnonymousJuly 13, 2012 at 4:18 AM

    thanks a ton man !! you saved my another day, have no words to thank you more :)

    ReplyDelete
  19. UnknownOctober 22, 2012 at 12:57 PM

    Oooh thank you! You saved me time and hair :)

    ReplyDelete
  20. AnonymousDecember 15, 2012 at 6:06 PM

    Thank you!

    ReplyDelete
  21. AnonymousFebruary 2, 2013 at 6:34 PM

    Thank you

    ReplyDelete
  22. AnonymousMarch 21, 2013 at 8:03 AM

    Same here. Thanks.

    ReplyDelete
  23. AnonymousMay 3, 2013 at 12:25 AM

    Danke! ;-)

    ReplyDelete
  24. aditya menonJuly 17, 2013 at 12:14 AM

    Thanks so much! Without this page I'd never have found it!

    ReplyDelete
  25. UnknownDecember 13, 2013 at 1:27 AM

    awesome man !! you are saviour :)

    ReplyDelete
  26. AnonymousDecember 17, 2014 at 11:56 AM

    You sir are true hero. Thank you.

    ReplyDelete
  27. AnonymousSeptember 23, 2015 at 1:30 PM

    Eres un genio, gracias por la ayuda !!!!

    ReplyDelete
  28. AnonymousOctober 8, 2015 at 3:35 AM

    Muito obrigado, já tinha gasto uma hora a procura da solução!

    Thank you

    ReplyDelete
  29. mzDecember 20, 2018 at 2:19 AM

    finally after a few hours googled..thanks so much..

    ReplyDelete
  30. Tom RauchSeptember 26, 2020 at 5:09 PM

    yes, thank you!

    ReplyDelete
  31. AnonymousDecember 1, 2022 at 3:55 AM

    Also, check on syntax error guys. I was doing a concatenation of multiple substr and reason for error was that one of the substr was written wrongly as "subtr"

    ReplyDelete

If you found this page useful, or you have any feedback, please leave a comment.

Subscribe to: Post Comments (Atom)