The error you sent seems to point to some statement that has not been properly closed. The commit/rollback happens in the middle of an open statement? That is what mysql seems to say. The problem could be earlier than when the error raises.
Hard to say where. You could try to force db.commit/rollback in different places to see where you start see errors. 2013/11/12 Diogo Munaro <[email protected]> > The error continues, but without index :( > > The indexes are successful created > > > 2013/11/11 Michele Comitini <[email protected]> > >> What happens if you remove the index creation inside the try/except block? >> >> >> 2013/11/11 Diogo Munaro <[email protected]> >> >>> It's not a simple function, but putting the model definition inside the >>> function. >>> >>> Here the code: http://pastebin.com/rN7gvAT8 >>> >>> Attached the error ticket >>> >>> >>> Em segunda-feira, 11 de novembro de 2013 08h34min44s UTC-2, Michele >>> Comitini escreveu: >>> >>>> If you define a function like >>>> def f(): >>>> pass >>>> >>>> in a model, you should have no problems. >>>> Just show us an extract of code that causes the problem, without >>>> violating any reserved information or IP. >>>> That way we can help you... >>>> >>>> mic >>>> >>>> >>>> Il giorno lunedì 11 novembre 2013 10:43:49 UTC+1, Diogo Munaro ha >>>> scritto: >>>>> >>>>> Hi guys, first the problem: >>>>> >>>>> I need some databases with identical structure, but with different >>>>> data. These databases must be stored with the clients because they want >>>>> (different locations), but the auth system is unique. >>>>> >>>>> So, my structure by now is: a centralized auth system and some >>>>> disyributed databases. The centralized system controls access to other >>>>> databases. >>>>> >>>>> Teoricaly web2py works great with it, because I defined a function >>>>> that I pass connection string, access control db and its made a lot of >>>>> databases replicas with foreign keys to access control database. >>>>> >>>>> Without the function it works great, but with, it make a complete >>>>> first client database and then crash all of web2py. It returns a ciclic >>>>> ticket error when I try access any application of that web2py, either >>>>> Welcome application. >>>>> >>>>> Im using web2py 2.7.4 with mysql on ubuntu. So, whats happening? I >>>>> cant define model with function. Oh, my function is in the same model >>>>> file. >>>>> >>>>> BR, Diogo >>>>> >>>> -- >>> Resources: >>> - http://web2py.com >>> - http://web2py.com/book (Documentation) >>> - http://github.com/web2py/web2py (Source code) >>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>> --- >>> 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. >>> >> >> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book (Documentation) >> - http://github.com/web2py/web2py (Source code) >> - https://code.google.com/p/web2py/issues/list (Report Issues) >> --- >> You received this message because you are subscribed to a topic in the >> Google Groups "web2py-users" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/web2py/_OnWZGMqkE0/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> [email protected]. >> >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > 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. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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.
