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.
