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.

Reply via email to