Thanks, Massimo! It seems to be working now.
I'll do some more testing to be sure the problem is gone for real. On Sun, Jun 23, 2013 at 12:16 PM, Massimo Di Pierro < [email protected]> wrote: > I think it is now fixed but please check it. > > > On Saturday, 22 June 2013 21:45:44 UTC-5, Alexei Vinidiktov wrote: > >> 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<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 web2py+un...@**googlegroups.com. >>> >>> For more options, visit >>> https://groups.google.com/**groups/opt_out<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. > > > -- 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.
