usually it's not rocket science.. do you have a
databases/***_restaurants.table in your databases folder ?
if yes, drop it and go to the appadmin controller to recreate it.
>From the error it seems that web2py is trying to migrate a table that is
not on the backend but it's supposed to be there (because of a
corresponding .table file found on the folder)
On Monday, June 29, 2015 at 8:37:41 PM UTC+2, Robert Porter wrote:
>
> I got everything working fine at home on my Ubuntu 14.04 server. Then I
> did a git push to pythonanywhere.com. Web2py created all my new tables
> except for one, and it continues to fail to create this table. Tech
> support at pythonanywhere can't find the problem.
>
> Here's my table that is having problems:
>
> db.define_table('restaurants',
> Field('place_id', 'text', required=True),
> Field('place_name', 'text'),
> Field('rest_lat', 'text'),
> Field('rest_lng', 'text'))
>
> I can take off the "required=True" but that doesn't help. Here's the
> error chain:
>
> <class '_mysql_exceptions.ProgrammingError'> (1146, "Table
> 'trytha$test.restaurants' doesn't exist")
>
> Traceback (most recent call last):
> File "/var/www/sites/trytha/gluon/restricted.py", line 227, in restricted
> exec ccode in environment
> File "/var/www/sites/trytha/applications/trytha/models/db.py", line 112,
> in <module>
> Field('rest_lng', 'text'))
> File "/var/www/sites/trytha/gluon/packages/dal/pydal/base.py", line 817,
> in define_table
> table = self.lazy_define_table(tablename,*fields,**args)
> File "/var/www/sites/trytha/gluon/packages/dal/pydal/base.py", line 856,
> in lazy_define_table
> polymodel=polymodel)
> File "/var/www/sites/trytha/gluon/packages/dal/pydal/adapters/base.py",
> line 491, in create_table
> fake_migrate=fake_migrate
> File "/var/www/sites/trytha/gluon/packages/dal/pydal/adapters/base.py",
> line 604, in migrate_table
> self.execute(sub_query)
> File "/var/www/sites/trytha/gluon/packages/dal/pydal/adapters/base.py",
> line 1326, in execute
> return self.log_execute(*a, **b)
> File "/var/www/sites/trytha/gluon/packages/dal/pydal/adapters/base.py",
> line 1320, in log_execute
> ret = self.cursor.execute(command, *a[1:], **b)
> File "/usr/local/lib/python2.7/dist-packages/MySQLdb/cursors.py", line
> 205, in execute
> self.errorhandler(self, exc, value)
> File "/usr/local/lib/python2.7/dist-packages/MySQLdb/connections.py",
> line 36, in defaulterrorhandler
> raise errorclass, errorvalue
> ProgrammingError: (1146, "Table 'trytha$test.restaurants' doesn't exist")
>
>
> Since this works at home, it's obviously a pythonanywhere problem, but
> they requested I ask you guys for help troubleshooting it.
>
> So here's my question: Anyone know a good web hosting company for Web2py?
> I really just need vanilla Ubuntu on a server. Alternatively, if you can
> figure out the error, that might work too, but given pythonanywhere's weird
> MySQL requirement of having your username as part of your DB name caused an
> hour of annoyance when I set everything up the first time, I'm not keen on
> giving them many more chances.
>
--
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.
