Hi Antony,
does not seem to work.
I still get an error by setting migrate to true. In which directory are the
*.table file written to?
thx
<class '_mysql_exceptions.OperationalError'> (1050, "Table 'auth_user'
already exists")Version
web2py™ Version 2.8.2-stable+timestamp.2013.11.28.13.54.07Traceback
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 "/home/mhoch4/web2py/gluon/restricted.py", line 217, in restricted
exec ccode in environment
File "/home/mhoch4/web2py/applications/psychogramm/models/db.py"
<https://mhoch4.pythonanywhere.com/admin/default/edit/psychogramm/models/db.py>,
line 53, in <module>
auth.define_tables(username=False, signature=False)
File "/home/mhoch4/web2py/gluon/tools.py", line 1737, in define_tables
format='%(first_name)s %(last_name)s (%(id)s)'))
File "/home/mhoch4/web2py/gluon/dal.py", line 8139, in define_table
table = self.lazy_define_table(tablename,*fields,**args)
File "/home/mhoch4/web2py/gluon/dal.py", line 8176, in lazy_define_table
polymodel=polymodel)
File "/home/mhoch4/web2py/gluon/dal.py", line 1058, in create_table
self.create_sequence_and_triggers(query,table)
File "/home/mhoch4/web2py/gluon/dal.py", line 1899, in
create_sequence_and_triggers
self.execute(query)
File "/home/mhoch4/web2py/gluon/dal.py", line 1916, in execute
return self.log_execute(*a, **b)
File "/home/mhoch4/web2py/gluon/dal.py", line 1910, in log_execute
ret = self.cursor.execute(command, *a[1:], **b)
File "/usr/local/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 205,
in execute
self.errorhandler(self, exc, value)
File "/usr/local/lib/python2.7/dist-packages/MySQLdb/connections.py", line
36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1050, "Table 'auth_user' already exists")
Am Dienstag, 3. April 2018 21:17:52 UTC+2 schrieb Anthony:
>
> Probably you don't have *.table files indicating the current status of the
> database schema. First, without the new column in the code, run a request
> with fake_migrate_all=True, which will create an updated set of *.table
> files. Then add the new column, and the migration should work.
>
> Anthony
>
> On Tuesday, April 3, 2018 at 12:14:30 PM UTC-4, Stephan wrote:
>>
>> I am getting an "tables already exist" error after adding column to an
>> existing table in db.py and setting migrate from false to true. It's
>> connected to a mysql. Application is running in version 2.8.2. Is there
>> some cahce to be cleared? thx
>>
>
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
