You can use "print db._lastsql" to see the actual query emitted by dal.
If that doesn't give you enough information, you can post the query here for assistance. Alas my MySQL chops are somewhat rusty, but surely somebody will have a suggestion. On Thursday, September 26, 2013 2:57:45 AM UTC-4, Wouter Pronk wrote: > > Hello, > > I've updated web2py to version 2.6.4 and now I get a Mysql-error which I > didn't have before: > >> <class 'gluon.contrib.pymysql.err.ProgrammingError'> (1064, u"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 'LONGTEXT))) AND >> (relatie_datatypes.message_type = message_type.id)) ORDER BY rel' at >> line 1") >> >> It complains about LONGTEXT, but I don't use LONGTEXT. Anybody an idea? > > Thanks, Wouter > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
