On Saturday, June 18, 2016 at 5:47:42 AM UTC-7, DNeuman wrote:
>
> 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.
>
>
It is very unusual for web2py to eat up all the memory. I think at this
point we need to know more about what your environment is (OS, version
info, what database engine, etc).
/dps
> 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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
