the best way for migrate is:
db = DAL('*mysql://root:@localhost/hasaad', migrate=True*)
for migrate all table...
2013/2/20 samuel bonilla <pythonn...@gmail.com>
> 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(tablena**me,*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.
>
>
>
--
---
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.
