This confirms it is not a web2py issue since the code web2py generates is correct and yet mysql does not take it.
could it be f1,f2,f3, etc are reserved keyworks in mysql? mysql has lots of little undocumented exceptions. That is why I always suggest postgresql. Massimo On Jun 20, 11:50 pm, weheh <richard_gor...@verizon.net> wrote: > I ran it again and got the same error message: > > ERROR 1064 (42000): You have an error in your SQL syntax; check the > manual that corresponds to your MySQL server version fo rht eright > syntax to use near 'x(id INT AUTO_INCREMENT NOT NULL, f1 VARCHAR(25), > f2 DA' at line 1 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
