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
-~----------~----~----~----~------~----~------~--~---
