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 should be created after the other tables. Saludos,
-------------------------------- Alfonso de la Guarda Twitter: @alfonsodg Redes sociales: alfonsodg Telef. 991935157 1024D/B23B24A4 5469 ED92 75A3 BBDB FD6B 58A5 54A1 851D B23B 24A4 On Tue, Oct 22, 2013 at 3:45 PM, Cliff Kachinske <cjk...@gmail.com> wrote: > 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 and Arch. >> >> When i try to simply change the database from sqlite to mysql (and >> after delete all inside databases) the mysql shows me an error: >> >> <class '_mysql_exceptions.OperationalError'> (1005, "Can't create >> table 'bassistant.auth_user' (errno: 150)") >> >> Obviosuly my ba-users has the right permissions, but when i check for >> the log in databases i notice this: >> >> >> CREATE TABLE auth_user( >> id INT AUTO_INCREMENT NOT NULL, >> first_name VARCHAR(128), >> last_name VARCHAR(128), >> email VARCHAR(512), >> password VARCHAR(512), >> registration_key VARCHAR(512), >> reset_password_key VARCHAR(512), >> registration_id VARCHAR(512), >> phone VARCHAR(512), >> company INT, INDEX company__idx (company), FOREIGN KEY (company) >> REFERENCES companies (id) ON DELETE CASCADE, >> place INT, INDEX place__idx (place), FOREIGN KEY (place) >> REFERENCES places (id) ON DELETE CASCADE, >> PRIMARY KEY(id) >> ) ENGINE=InnoDB CHARACTER SET utf8; >> >> Which references to foreign keys which obviously aren't created yet, >> also in Arch i am using MariaDB (which doesn't uses InnoDB) with the >> same driver. >> >> Any consideration for this? If not i will try to fix in the dal source >> and put the changes. >> >> >> Saludos, >> >> -------------------------------- >> Alfonso de la Guarda >> Twitter: @alfonsodg >> Redes sociales: alfonsodg >> Telef. 991935157 >> 1024D/B23B24A4 >> 5469 ED92 75A3 BBDB FD6B 58A5 54A1 851D B23B 24A4 > > -- > 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 web2py+unsubscr...@googlegroups.com. > 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
