MySQL – 1305 or 1630 Error – Function does not exist

Problem: Receive either “1630: FUNCTION MAX does not exist. Check the ‘Function Name Parsing and Resolution’ section in the Reference Manual” or “1305: FUNCTION MAX does not exist”.
Solution: Remove all spaces between the function and the parenthesis or set sql_mode=’IGNORE_SPACE’;

This is causing the error:

SELECT MAX (id) as something FROM Example

This will work correctly:

SELECT MAX(id) as something FROM Example
This entry was posted in Solutions and tagged , , , , . Bookmark the permalink.

17 Responses to MySQL – 1305 or 1630 Error – Function does not exist

  1. Frank says:

    Thank you for this article. I found help on this after a google search. Thanks.

  2. pablo says:

    It didn’t work for me, there are no spaces between my function and the parenthesis. What else could be causing the error message?

    Here’s my Script:
    SELECT e.id as id, e.full_name as name,
    ufn_property(e.id, 85) as rol,
    ETC…

  3. Anonymous says:

    ”””lll

  4. Anonymous says:

    it works tnks

  5. alex says:

    No dejes espacio entre MAX y (id), se soluciona asi MAX(id)

  6. eko says:

    Thanks..

  7. Daniela says:

    Here works \o/

  8. Çok faydalı yazılar paylaşıyorsun teşekkür

  9. Ransi says:

    It’s Works. Thanks

  10. doğru web says:

    Paylaşımlarınızı ilgiyle takip ediyorum

  11. 95Flossie says:

    Hello blogger, i must say you have high quality content here.

    Your page should go viral. You need initial traffic only.
    How to get it? Search for; Mertiso’s tips go viral

  12. FirstEverett says:

    I have noticed you don’t monetize your website, don’t
    waste your traffic, you can earn additional cash every month because you’ve
    got hi quality content. If you want to know how to make extra bucks, search
    for: Mrdalekjd methods for $$$

  13. Anonymous says:

    nice

  14. Fairooz says:

    Hi, found this link on google. this works. thanks!

  15. Deepa says:

    Thanks, This solution works totally:)

  16. Anonymous says:

    Thanks it help me

  17. Hexabit says:

    Are you sure that it’s working? For me is the same with and without spaces (not working)

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>