Had this problem deploying MySQL and the W2P recipe in the book: "Migration problems can also be fixed for all tables at once: db = DAL(...,fake_migrate_all=True) "
Solved it immediately ! On Thursday, January 12, 2012 12:29:29 AM UTC-5, Lewis 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") > -- 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/groups/opt_out.
