there are three types of migrations: 1) adding a column 2) dropping a column 3) modifying a column
web2py in case 3 trying to move your data from the old table to the new table. This seems to fail in MySQL. I do not why in this particular case. Some times this fails for logical reasons (the field contains text and you are changing it to date). 1) and 2) have no problems. If you really need to do 3) and mysql refuses to do it automatically then you may want add a new dummy column, copy the data there, drop the old column, add the column again (altered), move the data back, drop the dummy column. I hope this makes sense. If any MySQL expert has any more insight into this problem let me know. Massimo On Mar 5, 9:19 pm, Yannick <[email protected]> wrote: > Thanks Massimo for your suggestion... NoThe data is not crytical now > since I still in the development-testing phase. I follow your advise > and it work fine now. > however I wonder how to deal with this kind of situation when I'll go > live with critical data... > > Do you please have any suggestion how to avoid this situation in the > future. > > Thanks again a lot for your help and advises > > Cheers, > Yannick P. > > On Mar 5, 9:39 pm, mdipierro <[email protected]> wrote: > > > I do not know why mysql refuses to complete this particular migration > > that increases the default length of fields (required to avoid further > > problems later). > > > If your data is not crytical, I suggest recreate the database (from > > outside web2py) and erase the .table files in your app/databases > > folder. > > > Massimo > > > On Mar 5, 8:03 pm, Yannick <[email protected]> wrote: > > > > Hello Massimo, > > > I installed the latest trunk Version 1.57 from here (http:// > > > code.google.com/p/web2py/source/checkout ) and I'm having the same > > > problem as before same error message on the same application when > > > trying to access the login page... > > > Here is the error: > > > Error traceback > > > Traceback (most recent call last): > > > File "/opt/web2py/gluon/main.py", line 365, in wsgibase > > > SQLDB.close_all_instances(SQLDB.rollback) > > > File "/opt/web2py/gluon/sql.py", line 504, in close_all_instances > > > action(instance) > > > File "/opt/web2py/gluon/sql.py", line 871, in rollback > > > self._connection.rollback() > > > ProgrammingError: (2014, "Commands out of sync; you can't run this > > > command now") > > > > Do you please have any hint ? > > > > Thanks a lot, > > > Yannick P. > > > > On Feb 28, 11:38 pm, mdipierro <[email protected]> wrote: > > > > > Please email me your app and I'll take a look > > > > > On Feb 28, 5:22 pm, Yannick <[email protected]> wrote: > > > > > > Hello Massimo, > > > > > Basically I'm just trying to access the login page through a link like > > > > > this: > > > > > >http://127.0.0.1:8000/AppName/default/login > > > > > > Cheers, > > > > > > On Feb 28, 3:23 pm, mdipierro <[email protected]> wrote: > > > > > > > Which action cases this? > > > > > > > On Feb 28, 10:37 am, Yannick <[email protected]> wrote: > > > > > > > > Hello mate, > > > > > > > Did someone already had this error message below before ? I'm > > > > > > > using > > > > > > > MySQL server but with Sqlite I don't have this error everything > > > > > > > seems > > > > > > > to be alright... > > > > > > > > Error traceback > > > > > > > > Traceback (most recent call last): > > > > > > > File "/opt/web2py/gluon/main.py", line 365, in wsgibase > > > > > > > SQLDB.close_all_instances(SQLDB.rollback) > > > > > > > File "/opt/web2py/gluon/sql.py", line 474, in > > > > > > > close_all_instances > > > > > > > action(instance) > > > > > > > File "/opt/web2py/gluon/sql.py", line 833, in rollback > > > > > > > self._connection.rollback() > > > > > > > ProgrammingError: (2014, "Commands out of sync; you can't run this > > > > > > > command now") > > > > > > > > Please let me know.. Help needed ! > > > > > > > Thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
