Failed to add the foreign key constaint.

mfreiholz / persistent_login

Provides a "Keep me logged in" aka "Remember Me" functionality for Roundcube.

78 stars 49 forks source link

Failed to add the foreign key constaint. #40

Closed vecjh closed 7 years ago

vecjh commented 7 years ago

Hi, trying to activate UserData cookie method. While doing sql import via phpmyadmin I get the following error:

"Cannot add foreign key constrain"

if I add "set foreign_key_checks=0;" then the output is:

"Failed to add the foreign key constaint. Missing index for constraint 'auth_tokens_ibfk_1' in the referenced table 'users'"

mfreiholz commented 7 years ago

Works with

Apache/2.4.27
Roundcube 1.3.0
PHP 7.1 + libmysql - mysqlnd 5.0.12-dev
Mysql (10.1.8-MariaDB)

Anisotropic commented 6 years ago

@lustyffh good question, you have to add your specific db prefix (like "db_" or something) to this sql file. This prefix is defined in the roundcube config file. @mfreiholz you need to add this warning about db prefixes in your readme file. "works with" - is a dumb answer for any question.

mfreiholz commented 6 years ago

@lustyffh Whats your environment?