Is there a *.table file in your /databases folder corresponding to the
table in question? If so, you probably created that table on another system
or with a previous version of the database and copied/retained the *.table
file. This leads web2py to think the table already exists, so web2py will
not attempt to create it. You can simply delete the *.table file, and the
DAL's migration system will then create the table.
Anthony
On Sunday, January 8, 2017 at 10:36:54 PM UTC-5, Joe wrote:
>
> I have a table already defined in my app and it's connected to mysql on
> Pythonanywhere.
> I wanted to define an other table in the same app but I am unable to
> connect this new table to db.
>
> In my db.py file I have this:
>
> *if not request.env.web2py_runtime_gae:*
> * ## if NOT running on Google App Engine use SQLite or other DB*
> * db =
> DAL('mysql:myaccount.mysql.pythonanywhere-services.com/myaccount$dbname
> <http://myaccount.mysql.pythonanywhere-services.com/myaccount$dbname>')*
>
> This works as expected for the table already defined, but when I try to
> define an other table it crashes.
> I get this error:
>
> ProgrammingError: ( "Table 'myaccount$dbname.tablename' doesn't exist")
>
>
> I am probably missing something obvious.
>
> Can anyone advise me on this please?
>
> Thanks.
>
> Cheers,
>
> Joe
>
>
>
--
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].
For more options, visit https://groups.google.com/d/optout.
