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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.