I'm migrating an existing web2py app from sqlite to mysql. The sqlite
version runs fine. The mysql version chokes on the date and datetime
fields:
Here's the table:
db.define_table('x',
db.Field('name','string',length=25,requires=[IS_NOT_EMPTY
(),IS_NOT_IN_DB(db,'x.name')]),
db.Field('f1','datetime',requires=IS_DATETIME()),
db.Field('f2','datetime',requires=IS_DATETIME()),
db.Field('f3','string',requires=IS_IN_SET(range(1,10))),
db.Field('f4','date',requires=IS_NULL_OR(IS_DATE())),
)
Here's the traceback message:
Traceback (most recent call last):
File "gluon/restricted.py", line 107, in restricted
File "C:/web2py/applications/SPiNup/models/1_tables.py", line 57, in
<module>
File "gluon/sql.py", line 993, in define_table
File "gluon/sql.py", line 1314, in _create
File "gluon/sql.py", line 731, in <lambda>
File "MySQLdb\cursors.pyc", line 166, in execute
File "MySQLdb\connections.pyc", line 35, in defaulterrorhandler
ProgrammingError: (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 'repeat VARCHAR(32),\n\trstop DATE,\n\tPRIMARY KEY
(id)\n) ENGINE=InnoDB CHARACTER SET ' at line 6")
Line 57 in 1_tables.py is the db.Field('f4','date'... ) field. If I
comment out the f4 date field, I get the same problem on the f2 field,
which is a datetime.
Anybody have an idea what the problem is? Could my installation be bad?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" 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
-~----------~----~----~----~------~----~------~--~---
