Can't import mysql.initial (#1215 error)
Issue #49
resolved
Hello,
I can’t import “mysql.initial.sql”, I have the #1215 error on PhpMyAdmin.
Comments (7)
-
repo owner -
reporter Hello,
It’s version 5.6.
-
reporter Hello,
The problem will come from these two lines :
CONSTRAINT fk_user_id FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT fk_identity_id FOREIGN KEY (iid) REFERENCES identities(identity_id) ON DELETE CASCADE ON UPDATE CASCADE,
Any idea ?
-
repo owner Looks like you are importing SQL file into empty database.
You should import it into existing database of roundcube. There shold be tables referenced in this constraints.
-
reporter Hello,
You are right ! I didn't put the prefix of my tables, it works now.On the other hand, how to make the identity select box menu appear on my theme (I do not use the Larry theme) ?
-
reporter Hello,
I found the solution by modifying the files “ident_switch-switch.js“ and “ident_switch-switch.min.js“
PS: If you want, you can download my french translation for this plugin : http://www.bodet.org/downloads/ident_switch.zip
-
reporter - changed status to resolved
- Log in to comment
Hello.What version of MySQL is it?