web2py remembers if it created the tables but does not discover them if preexisting. Fake migrate may help you, if you know the structure of those tables.
http://web2py.com/books/default/chapter/29/6#Fixing-broken-migrations On Jan 11, 11:29 pm, Likit <lewis_le...@hotmail.com> wrote: > web2py has failed when the authuser table already exists. Well, > ideally the auth tables are meant to persist. I thought the DAL > created tables if they DON'T exist. > > I guess I am getting really tired of the unbearable fragility of > web2py. Just pretty bush league, I guess. > > Here is the traceback: > > Traceback (most recent call last): > File "C:\web2py\gluon\restricted.py", line 204, in restricted > exec ccode in environment > File "C:/web2py/applications/pyjokes/models/db.py", line 9, in > <module> > auth.define_tables() > File "C:\web2py\gluon\tools.py", line 1285, in define_tables > format='%(first_name)s %(last_name)s (%(id)s)')) > File "C:\web2py\gluon\dal.py", line 5097, in define_table > polymodel=polymodel) > File "C:\web2py\gluon\dal.py", line 705, in create_table > self.create_sequence_and_triggers(query,table) > File "C:\web2py\gluon\dal.py", line 1348, in > create_sequence_and_triggers > self.execute(query) > File "C:\web2py\gluon\dal.py", line 1359, in execute > return self.log_execute(*a, **b) > File "C:\web2py\gluon\dal.py", line 1353, in log_execute > ret = self.cursor.execute(*a, **b) > File "C:\web2py\gluon\contrib\pymysql\cursors.py", line 108, in > execute > self.errorhandler(self, exc, value) > File "C:\web2py\gluon\contrib\pymysql\connections.py", line 184, in > defaulterrorhandler > raise errorclass, errorvalue > InternalError: (1050, u"Table 'auth_user' already exists")
