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.

Reply via email to