Hello,
I am working locally on GAE (with Cloud SQL) and I can't seem to be able to
add a new field to a table. I keep having 'xxx.table appears corrupted'
messages.
This is what I do before getting the error.
1. To begin with I have:
DAL('google:sql:xxx:xxx/xxx’, migrate_enabled = False, migrate=False)
db.define_table('test', Field('name'))
---> everything all right
2. Then I change DAL connexion:
DAL('google:sql:xxx:xxx/xxx’, migrate_enabled = True, migrate=False)
3, And update define_table with a new field + a migrate name
db.define_table('test', Field('name'), Field('another'),
migrate='test.table')
---> I get the following error:
[…]/gluon/packages/dal/pydal/adapters/base.py:1370: Warning: Can't create
database 'silentdrop'; database exists
ret = self.cursor.execute(command, *a[1:], **b)
[…]/gluon/packages/dal/pydal/adapters/base.py:1370: Warning: Table
'web2py_filesystem' already exists
ret = self.cursor.execute(command, *a[1:], **b)
ERROR 2015-10-17 11:06:35,531 restricted.py:174] Traceback (most recent
call last):
File "[…]/gluon/restricted.py", line 227, in restricted
exec ccode in environment
File "[…]/applications/xxx/models/xxx.py”, line 35, in <module>
migrate= ‘test.table')
File "[…]/gluon/packages/dal/pydal/base.py", line 834, in define_table
table = self.lazy_define_table(tablename,*fields,**args)
File "[…]/gluon/packages/dal/pydal/base.py", line 873, in
lazy_define_table
polymodel=polymodel)
File "[…]/gluon/packages/dal/pydal/adapters/base.py", line 494, in
create_table
raise RuntimeError('File %s appears corrupted' % table._dbt)
RuntimeError: File $HOME/socialTV/databases/test.table appears corrupted
I would really appreciate if someone could help me with this as I can't
seem to find a solution.
Thank you!
--
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.