Any chance of anybody looking into it? On 20.06.2013, at 7:28, Alexei Vinidiktov <[email protected]> wrote:
> Done: http://code.google.com/p/web2py/issues/detail?id=1548 > > > On Thu, Jun 20, 2013 at 4:24 AM, Niphlod <[email protected]> wrote: >> open an issue so it doesn't get lost....sounds definitevely like a bug >> >> >> On Wednesday, June 19, 2013 6:28:48 PM UTC+2, Alexei Vinidiktov wrote: >>> >>> Hello, >>> >>> I'm using Firebird with my web2py powered app. >>> >>> I've come across what I think to be a bug in migrations, namely dropping >>> columns migrations. >>> >>> If I create a table definition, for example, like this: >>> >>> db.define_table('card', >>> Field('question', 'text', notnull=True), >>> Field('answer','text', notnull=True) >>> ) >>> >>> The table gets created, everything works fine. >>> >>> But if I remove a Field definition (drop a column), like so: >>> >>> db.define_table('card', >>> Field('answer','text', notnull=True) >>> ) >>> >>> The column gets dropped from the database, but I keep getting this error >>> message: >>> >>> <class 'fdb.fbcore.DatabaseError'> ('Error while executing SQL >>> statement:\n- SQLCODE: -607\n- unsuccessful metadata update\n- column >>> QUESTION does not exist in table/view CARD', -607, 335544351) >>> >>> >>> And the sql.log shows that every time I load a page web2py tries to drop >>> the column that has been deleted thus causing this error. >>> >>> timestamp: 2013-06-19T23:11:40.214366 >>> ALTER TABLE card DROP question; >>> timestamp: 2013-06-19T23:11:58.635448 >>> ALTER TABLE card DROP question; >>> >>> My setup is like this: Mac OS X 10.8.4, Python 2.7.4, web2py 2.5.1, >>> Firebird 2.5 with the latest fdb driver. But I've come across the same bug >>> on Windows too. >>> >>> To reproduce the bug define any table with a couple of columns, get web2py >>> to create it. Then remove a column definition from from the table >>> definition. >>> >>> I've tried fake_migrate but it doesn't solve the problem. Once I remove >>> fake_migrate the error is back. >>> >>> -- >>> Alexei Vinidiktov >> -- >> >> --- >> 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/groups/opt_out. >> >> > > > > -- > Alexei Vinidiktov -- --- 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/groups/opt_out.
