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 <[email protected]> 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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
