look:
db = DAL('*mysql://root:@localhost/hasaad', migrate=False*)
ready....
El miércoles, 20 de febrero de 2013 02:24:41 UTC-5, Hassan Alnatour
escribió:
>
> 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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
