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 -~----------~----~----~----~------~----~------~--~---
