It's nearly working !
The table was dropped, I renamed the .table file, got
migrate='tabename.table', saved model.py and restarted the server.
I get this error :
<class 'sqlite3.OperationalError'>(near "IGNORE": syntax error)
at the last field of the missing table line :
Field('FIN_CO1', label='Documentations', writable=False),
migrate='ficheIntervention.table')
with this Function argument list :
(self=<gluon.dal.SQLiteAdapter object at 0x019E2EB0>, *a=('CREATE
TABLE ficheIntervention(\n id INTEGER P...,\n FIN_VIS CHAR(512),\n
FIN_CO1 CHAR(512)\n);',), **b={})
It seems web2py is trying to create the table (Yay !), but not
succeeding.
The only "ignore" word I have in the database come from the "
ondelete='ignore' " I have on every reference in my table,
and it didn't prevent web2py from working before (worked for a week
with it, just fine, and with " ondelete='ignore' " active).
Any idea about what is happening ?
On Aug 24, 8:49 am, annet <[email protected]> wrote:
> Hi Tom,
>
> Did you remove the table's .table file from the databases folder?
>
> The way I proceed this problem is:
>
> In the database's management tool delete/drop the table;
> Trash the table's .table file in the databases folder;
> In db.py set migrate to migrate='tablename.table'
> Save db.py
> Return to admin/default/design/appname
> Go to the database administration
> Return to db.py to set migrate to migrate=False
>
> Kind regards,
>
> Annet.
