Dear ALL , Am trying to connect to a mysql database but am getting this error , how can i solve this problem :
connection string : *URI = 'mysql://root:@localhost/hasaad'* TICKET ID 127.0.0.1.2013-02-20.10-10-32.b8a942ff-fb3a-4ba0-b118-fd1fdac873bf *<class 'gluon.contrib.pymysql.err.InternalError'> (1050, u"Table 'auth_user' already exists")*VERSIONweb2py™(2, 0, 2, datetime.datetime(2012, 8, 30, 4, 8, 18), 'stable')TRACEBACK 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. Traceback (most recent call last): File "C:\web2py\gluon\restricted.py", line 209, in restricted exec ccode in environment File "C:/web2py/applications/7a9ad/models/db.py" <http://127.0.0.1:8000/admin/default/edit/7a9ad/models/db.py>, line 52, in <module> auth.define_tables() File "C:\web2py\gluon\tools.py", line 1464, in define_tables format='%(first_name)s %(last_name)s (%(id)s)')) File "C:\web2py\gluon\dal.py", line 7041, in define_table table = self.lazy_define_table(tablename,*fields,**args) File "C:\web2py\gluon\dal.py", line 7072, in lazy_define_table polymodel=polymodel) File "C:\web2py\gluon\dal.py", line 848, in create_table self.create_sequence_and_triggers(query,table) File "C:\web2py\gluon\dal.py", line 1584, in create_sequence_and_triggers self.execute(query) File "C:\web2py\gluon\dal.py", line 1598, in execute return self.log_execute(*a, **b) File "C:\web2py\gluon\dal.py", line 1592, in log_execute ret = self.cursor.execute(*a, **b) File "C:\web2py\gluon\contrib\pymysql\cursors.py", line 117, in execute self.errorhandler(self, exc, value) File "C:\web2py\gluon\contrib\pymysql\connections.py", line 202, in defaulterrorhandler raise errorclass, errorvalue InternalError: (1050, u"Table 'auth_user' already exists") IN FILE: C:\WEB2PY\APPLI -- --- 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/groups/opt_out.