jlew/Web2Py-Inventory — Issue #1: Error in creating table 'item'
Author: ww9rivers
Created: 2012-01-07 04:59:28+00:00
State: open

(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 'Condition VARCHAR(255),\n Status VARCHAR(255),\n CreationDate DATETIME,\n ' at line 10")

Traceback (most recent call last):
File "/home/www-data/web2py/gluon/restricted.py", line 204, in restricted
exec ccode in environment
File "/home/www-data/web2py/applications/inventory/models/db.py", line 91, in
format="%(Name)s: %(BarCode)s"
File "/home/www-data/web2py/gluon/dal.py", line 5097, in define_table
polymodel=polymodel)
File "/home/www-data/web2py/gluon/dal.py", line 705, in create_table
self.create_sequence_and_triggers(query,table)
File "/home/www-data/web2py/gluon/dal.py", line 1348, in create_sequence_and_triggers
self.execute(query)
File "/home/www-data/web2py/gluon/dal.py", line 1359, in execute
return self.log_execute(*a, **b)
File "/home/www-data/web2py/gluon/dal.py", line 1353, in log_execute
ret = self.cursor.execute(*a, **b)
File "/home/www-data/web2py/gluon/contrib/pymysql/cursors.py", line 108, in execute
self.errorhandler(self, exc, value)
File "/home/www-data/web2py/gluon/contrib/pymysql/connections.py", line 184, in defaulterrorhandler
raise errorclass, errorvalue
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 'Condition VARCHAR(255),\n Status VARCHAR(255),\n CreationDate DATETIME,\n ' at line 10")