When you delete a sqlite database, make sure you delete all the associated .table files too.
On Sunday, 6 January 2013 20:45:34 UTC-6, HittingSmoke wrote: > > Yep, SQLITE. But I completely wiped the database from the disk in > web2py/applications/application/databases and let web2py write a completely > new one. Wouldn't I not need to alter anything if web2py has created a > fresh database with the proper field types? > > On Sunday, January 6, 2013 6:37:48 PM UTC-8, rochacbruno wrote: >> >> Are you using SQLITE? >> >> SQLITE does not support "alter table" for changing column types. SO you >> have to use "sqliteman" program to alter directly on sqlite. >> > --