persistent_login icon indicating copy to clipboard operation
persistent_login copied to clipboard

MySQL throws an error.

Open ghost opened this issue 4 years ago • 1 comments

Error SQL query:

ALTER TABLE auth_tokens ADD CONSTRAINT auth_tokens_ibfk_1 FOREIGN KEY (user_id) REFERENCES users (user_id) ON DELETE CASCADE MySQL said: Documentation

#1215 - Cannot add foreign key constraint

ghost avatar Mar 22 '20 10:03 ghost

I came across the same today. I use a prefix for the database, as I use one DB for 3 roundcubes.

The issue is, that there is no table "users" which the SQL script references, that is the problem causing the error. In my case there are 3 user tables "rc_users", "gmx_users" and "gmail_users".

So the issue is, that this plugin doesn't take the optional database prefix into account.

djraw avatar Dec 02 '21 19:12 djraw