I thought I had the same problem, so followed the advice - I have done
this, and now get the error:
OperationalError: table auth_user already exists
This came about after Web2py ate all my memory and crashed overnight...so I am
not really sure what is happening here. Any further suggestions? Also, I
looked, and found that the file
c8b66..._auth_user.table does not exist. So I don't really thing the user table
already exists. Any thoughts what remains broken? What to try next? Thanks.
On Thursday, July 2, 2015 at 12:09:12 PM UTC-7, Niphlod wrote:
>
> 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
