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")