stop web2py, drop the databases/*_auth_user.table file, set fake_migrate_all=True on the DAL connection, start web2py, hit the appadmin page (which should trigger recreation of all *.table files), remove fake_migrate_all statement from the DAL connection.
On Wednesday, July 1, 2015 at 4:01:20 PM UTC+2, reddyreddy wrote: > > Can anyone help me? > > Iam getting runtime error auth_user.table appears corrupted. > Iam not sure why it is appearing. Here are my not tables. > > > db = DAL("sqlite://storage.sqlite") > from gluon.tools import Auth > auth = Auth(db) > auth.define_tables(username=True) > db.define_table('problem', > Field('title', unique=True), > Field('body', 'text'), > Field('file','upload'), > Field('ori_file',readable=False, writable=False), > Field('outputfile','upload'), > Field('created_on', 'date', default=request.now, readable=False, > writable=False), > Field('Due date','date'), > Field('status', readable=False, writable=False)) > > > db.define_table('submission', > Field('name', requires=[IS_NOT_EMPTY(), IS_ALPHANUMERIC()]), > Field('email', requires=[IS_NOT_EMPTY(), IS_EMAIL()]), > Field('file','upload', requires=IS_NOT_EMPTY()), > Field('status', readable=False,writable=False), > Field('posted_on', 'date', default=request.now, readable=False, > writable=False), > Field('problem_id','reference problem',readable=False, writable=False)) > > -- 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.