If you don't need any data in the db, delete everything in databases and
check that in models\db.py the DAL creation has migrate=True.
Then restart your app.
All tables should be recreated.
quarta-feira, 29 de Maio de 2019 às 20:13:07 UTC+1, karthikeyan p escreveu:
>
> i am running my web2py app in pythonanywhere.com ( cloud machine )
> i have configured git in my *welcome* folder . i have not initalised
> .ignore file to avoid anything like database , errors , sessions ,uploads .
> so when i like to backup my app in pythonanywhere , i just used -> git add
> . -> git commit -> git push to my cloud repo (github).
> so finally i got all my data ( including db , uploads , sessions ,errors
> etc ) in to my cloud repo .
>
> i use git pull in local machine to pull all contents took from
> pythonanywhere.
>
> if i changed something in my local repo ( laptop) , i will send it to
> cloud repo (github) .
>
> this is my technique .
>
>
> i have created a database called *contact *in my local machine .
> i pushed it to github .
> i pulled it to pythonanywhere.com
>
>
>
> finally i found this error ,
> <class 'sqlite3.OperationalError'> no such table: contacts
>
> but it is found in db.py (model)
>
>
> db.define_table('contacts',
> Field('usr_n','string'),
> Field('email_id',requires=IS_EMPTY_OR(IS_EMAIL()))
> )
>
>
> i did this technique :
> i deleted all *.database ( except sql.log and storage.sqlite)
> i used "fake_migrate_all=True"
>
>
> any other best practise to work for updating the things include db in
> cloud machine ??
>
> i mostly worried about the db problems.
>
>
>
>
>
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/f5a7957a-ab68-436f-8602-8fcdec86a10c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
