Re: [web2py] Changed date to datetime. Now I get: invalid literal for int() with base 10:
I understand all the steps involved and usually the operations you carried on lead to a database recreationbut there's a problem somewhere. If you deleted the sqlite database it *can't* complain about any data in it (leaving aside for one moment the "format" the data is in the field)... This error invalid literal for int() with base 10: '06 21:12:04' if returned by a select means that: - there is a database - there is a table - there is a column - there is a row filled with some value So either you have deleted correctly the database and your app commits something or you didn't delete the database at all On Monday, January 7, 2013 6:16:48 PM UTC+1, HittingSmoke wrote: > > 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 web2py/applications/application/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. >>> --
Re: [web2py] Changed date to datetime. Now I get: invalid literal for int() with base 10:
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. >>> >> --
Re: [web2py] Changed date to datetime. Now I get: invalid literal for int() with base 10:
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. >> > --
Re: [web2py] Changed date to datetime. Now I get: invalid literal for int() with base 10:
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. > --
Re: [web2py] Changed date to datetime. Now I get: invalid literal for int() with base 10:
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. --