databases/*files are the "memory" of web2py to know which tables have been created in the backend and which have not... If you delete it, web2py think the related table is not defined in the backend and will try to create it, which will lead to the error message you have as the table is already created in your sqlite database...
To fix that you have to migrate=false and fake_migrate=True then set back migrate=True between these change you have to make a page reload (any page) of you app... It will force web2py to reanalyse and sync web2py with the backend. Note: In production, you should set migrate to false.... Richard On Wed, Jan 18, 2017 at 11:22 AM, Andrea Fae' <and...@gmail.com> wrote: > Why if I delete xxxxxxxxxxxx.table files and log file inside database > folder sqlite I have this error? sqlite is or not a only one file? Is it > something regarding migrate=true or false? Can I have a better explanation > than the book? Thank you > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
