I changed date to datetime in my comments database model and now after
submitting a comment I can't load the comment function.
I figured I just broke the database with the switch and tried to wipe it to
start over. That didn't work though. In appadmin if I go to the comments
table I get the sam
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.
--
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
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 comp
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
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)...
Thi
6 matches
Mail list logo