I cleared all files from the applications/databases directory to let it start new. That includes all .table files and storage.sqlite.
What I did was: Changed date to datetime Shut down server rm applications/databases/* Start server Load app and leave a comment Reload comments page Somehow the error still persists. I thought for sure it had to be something in my code but I've checked and triple checked it. On Monday, January 7, 2013 3:14:30 AM UTC-8, Massimo Di Pierro wrote: > > 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. >>> >> --