On Feb 2, 2010, at 3:09 PM, Richard wrote:
> hmm, can't find "make_migrate" anywhere, even in trunk...although I
> saw it discussed in another thread.
It's fake_migrate.
>
>
> On Feb 3, 1:42 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
>> Do you have a custom auth_table?
>>
>> If so you can do:
>>
>> db.define_table('auth_table',....,migarte=False,make_migrate=True)
>>
>> Then you have to check in SQL that all columns you expect are there.
>>
>> massimo
>>
>> On Feb 2, 2:56 am, Richard <richar...@gmail.com> wrote:
>>
>>> Some of my .table files have become corrupted, so that I get this
>>> error:
>>
>>> Traceback (most recent call last):
>>> File "web2py/gluon/restricted.py", line 178, in restricted
>>> exec ccode in environment
>>> File "web2py/applications/studio09/models/db.py", line 165, in
>>> <module>
>>> Field('video', db.media),
>>> File "web2py/gluon/sql.py", line 1033, in define_table
>>> query = t._create(migrate=migrate)
>>> File "web2py/gluon/sql.py", line 1393, in _create
>>> sql_fields_old = cPickle.load(tfile)
>>> EOFError
>>
>>> However if I remove the .table files then I get this error:
>>
>>> Traceback (most recent call last):
>>> File "web2py/gluon/restricted.py", line 178, in restricted
>>> exec ccode in environment
>>> File "web2py/applications/studio09/models/db.py", line 28, in
>>> <module>
>>> Field('registration_key', length=128, readable=False,
>>> writable=False, default=''),
>>> File "web2py/gluon/sql.py", line 1033, in define_table
>>> query = t._create(migrate=migrate)
>>> File "web2py/gluon/sql.py", line 1368, in _create
>>> self._db._execute(query)
>>> File "web2py/gluon/sql.py", line 704, in <lambda>
>>> self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
>>> OperationalError: table auth_user already exists
>>
>>> Is there a way to restore my .table files without having to export my
>>> data, drop the tables, and then reimport later?
>>
>>> thanks,
>>> Richard
>>
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To post to this group, send email to web...@googlegroups.com.
> To unsubscribe from this group, send email to
> web2py+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/web2py?hl=en.
>
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
