Re: [web2py] Re: MySQL problem

2013-10-23 Thread Alfonso de la Guarda
Hi, Yes, i know howver auth_user has previous dependencies from another tables and those tables also between them, the solution will be simply define extra fields at the final of table definitions inside db.py Saludos, Alfonso de la Guarda Twitter: @alfonsodg

Re: [web2py] Re: MySQL problem

2013-10-23 Thread Cliff Kachinske
You can always define other tables before the call to auth.define_tables(). Unless they have dependencies on other auth_* tables, that is. On Wednesday, October 23, 2013 8:50:39 AM UTC-4, Alfonso de la Guarda Reyes wrote: > > Hi, > > The problem is in the auth custom fields because they are cre

Re: [web2py] Re: MySQL problem

2013-10-23 Thread Alfonso de la Guarda
Hi, The problem is in the auth custom fields because they are created before any other table and the extra fields add some relations. At first time, i need create the basic auth table and after that just add the extra fields, then for the deployment is a 2 step process. Maybe the extra fileds shou

[web2py] Re: MySQL problem

2013-10-22 Thread Cliff Kachinske
Are you using lazy tables? Do your models define the referenced tables before they define the referrer? On Tuesday, October 22, 2013 2:14:22 PM UTC-4, Alfonso de la Guarda Reyes wrote: > > Hi, > > For the first time i have found a problem between web2py and mysql in > two Linux flavors: Ubuntu

[web2py] Re: mysql problem after updating to 2.6.4

2013-09-26 Thread Cliff Kachinske
You can use "print db._lastsql" to see the actual query emitted by dal. If that doesn't give you enough information, you can post the query here for assistance. Alas my MySQL chops are somewhat rusty, but surely somebody will have a suggestion. On Thursday, September 26, 2013 2:57:45 AM UTC-4,