Can't import mysql.initial (#1215 error)

[Alban]

Hello,

I can’t import “mysql.initial.sql”, I have the #1215 error on PhpMyAdmin.

[Boris Gulay]

Hello.What version of MySQL is it?

[Alban]

Hello,

It’s version 5.6.

[Alban]

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 ?

[Boris Gulay]

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.

[Alban]

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) ?

[Alban]

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