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.
