can you show us sql.log? Can you also show us the model? there seem to be a 'SUBSTRING' in CREATE TABLE and I have no clue how it go in there. web2py does not write it.
There are things that work in sqlite even if they should not. On Nov 14, 9:59 am, Benigno <[email protected]> wrote: > Hi, > > I have just installed a working application (working on sqlLite) > and now need to move it to MySQL, I have created a DB, and user with > access rights (on localhost), and changed db.py db definition to > 'mysql://username:passw...@localhost/dbname' > > I am getting the following error when I try to access any page on > the application: > > S'Traceback (most recent call last): > File "/Users/benigno/PyProjects/AlbenDas_web2py/gluon/restricted.py", > line 184, in restricted\n File > "/home/albendas/public_html/www.albendas.com/applications/domotica/models/db.py", > line 52, in > <module> > auth.define_tables() # creates all needed > tables > File "/Users/benigno/PyProjects/AlbenDas_web2py/gluon/tools.py", line > 748, in define_tables > File "/Users/benigno/PyProjects/AlbenDas_web2py/gluon/sql.py", line > 1205, in define_table > File "/Users/benigno/PyProjects/AlbenDas_web2py/gluon/sql.py", line > 1607, in _create > File "/Users/benigno/PyProjects/AlbenDas_web2py/gluon/sql.py", line > 879, in <lambda> > File "/var/lib/python-support/python2.5/MySQLdb/cursors.py", line 166, > in execute > self.errorhandler(self, exc, value) > File "/var/lib/python-support/python2.5/MySQLdb/connections.py", line > 35, in defaulterrorhandler > raise errorclass, errorvalue\nProgrammingError: (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 \'SUBSTRING > (auth_user.registration_key,1,1))\ > ) ENGINE=InnoDB CHARACTER SET utf8\' at line 8")' > > My MySQL Version is: MySQL 5.0.51a-3ubuntu5.4 > > Any help appreciated. > Benigno. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
