I've added the following field to the table worksheet:
SQLField('mysortkey', length = 40, default = 'something' )
I get a ticket reporting:
Traceback (most recent call last):
File "/home/scott/web2py_1_68_2/gluon/restricted.py", line 184, in
restricted
exec ccode in environment
File "/home/scott/web2py_1_68_2/applications/Rover/models/db.py",
line 165, in <module>
db.define_table(*([\'worksheet\'] + ws_fields) )
File "/home/scott/web2py_1_68_2/gluon/sql.py", line 1130, in
define_table
query = t._create(migrate=migrate)
File "/home/scott/web2py_1_68_2/gluon/sql.py", line 1506, in _create
sql_fields_aux, logfile)
File "/home/scott/web2py_1_68_2/gluon/sql.py", line 1558, in
_migrate
self._db._execute(sub_query)
File "/home/scott/web2py_1_68_2/gluon/sql.py", line 772, in <lambda>
self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
OperationalError: near "ADD": syntax error
And the sql.log reports:
timestamp: 2009-10-23T10:27:01.673960
ALTER TABLE worksheet ADD mysortkey CHAR(40);
timestamp: 2009-10-23T10:30:40.842311
It doesn't seem to matter how I change the name, the type of the
field, or use a different table; other examples from the sql.log, all
of which had a similar ticket to the above:
ALTER TABLE worksheet ADD silly CHAR(1);
ALTER TABLE worksheet ADD when_rec CHAR(40);
ALTER TABLE person ADD stupid INTEGER;
This is running v 1.68.2 from source w/ an SQLlite DB
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" 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
-~----------~----~----~----~------~----~------~--~---
