Menu ▾ ▴

#2844 (ok 3.1.4) UUID() function error

3.1.3
fixed
Herman van Rink
Data insertion/extraction/manipulation (334)
1
2013-06-11
2009-03-11
Fabio Natalucci
No

When leave the field ID empty the UUID must set automatically the value..but return me an error..this error return from the form insert of phpmyadmin.
Maybe the WHERE is too much..and can be disable.

UPDATE `eventi`.`utenti` SET `id_utenti` = UUID( '' ) WHERE `utenti`.`id_utenti` = 'UUID()' LIMIT 1

Messaggio di MySQL: Documentazione
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''') WHERE `utenti`.`id_utenti` = 'UUID()' LIMIT 1' at line 1

Discussion

  • Fabio Natalucci

    Fabio Natalucci - 2009-03-11
    • priority: 5 --> 8
    • assigned_to: nobody --> cybot_tm
    • summary: UUID function error --> UUID() function error
     

  • Fabio Natalucci

    Fabio Natalucci - 2009-03-11
    • assigned_to: cybot_tm --> nobody
     

  • Fabio Natalucci

    Fabio Natalucci - 2009-03-12
    • assigned_to: nobody --> helmo
     

  • Herman van Rink

    Herman van Rink - 2009-03-12
    • priority: 8 --> 1
    • summary: UUID() function error --> (ok 3.1.4) UUID() function error
    • status: open --> open-fixed
     

  • Herman van Rink

    Herman van Rink - 2009-03-12

    Fixed in subversion, thanks for reporting.

     

  • Marc Delisle

    Marc Delisle - 2009-04-25
    • status: open-fixed --> closed-fixed
     

  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed
     
MongoDB Logo MongoDB