I cannot reproduce this. My only guess is that your databases/*.table
files got corrupted. Perhaps you copied you .sqlite file but not
the .table files and they got out of sync. If you do not have data in
there, just delete everything in databases/
Massimo
On Oct 23, 10:04 am, Scott Hunter <shun...@nycap.rr.com> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
