![]() Īt this point, I'm able to redeploy from scratch in about 5 minutes (using cPanel). I confirmed the initial.sql file does have the apostrophes included which was the cited fix, and I'm not getting the "label" error that was referenced in that thread. I found this exact issue referenced in the developer's bitbucket but it was addressed. ![]() I tried to import the file using command line as well instead of phpMyAdmin: $ mysql -u SQL_USER -p MY_DATABASE < /home/LINUX_USER/DOMAIN/plugins/ident_switch/SQL/ĮRROR 1005 (HY000) at line 1: Can't create table `MY_DATABASE`.`ident_switch` (errno: 150 "Foreign key constraint is incorrectly formed") Do I need to modify this file to prepend the "rcub_" anywhere? To me the error reads like that association ("foreign key" I guess) is where it's failing but I have no idea how to confirm that or fix it. There is one row in that table with the IMAP username I signed in to Roundcube with. In the database, I have a 'rcub_users' table with a 'user_id' column. I looked over the initial.sql file I imported and see: CONSTRAINT `fk_user_id` FOREIGN KEY (`user_id`) REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE, When I did the initial import, I used phpMyAdmin and it doesn't throw any errors so long as I uncheck 'Enable foreign key checks' My database skills are novice which is where I need help. So I'm 99% sure I've got it installed and configured correctly up to the point of DB interaction. Using phpMyAdmin I confirm there are no new rows in the ident_switch table which I'd expect to see on a successful addition of an account using ident_switch. Logs indicate it's failing to write to the database: : DB Error: Cannot add or update a child row: a foreign key constraint fails (`MY_DATABASE`.`rcub_ident_switch`, CONSTRAINT `fk_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE) (SQL Query: INSERT INTO rcub_ident_switch(flags, label, imap_host, imap_port, imap_delimiter, username, password, smtp_host, smtp_port, smtp_auth, user_id, iid) VALUES ('5', '', '666', NULL, '', '', '6666', '1', '1', '2')) in /home/LINUX_USER/DOMAIN/program/lib/Roundcube/rcube_db.php on line 543 (POST /?_task=settings&_action=save-identity) However, when I enter any info in them and save, it doesn't actually save. I can log into Roundcube and I have the ident_switch fields. Renamed the table to prepend the "rcub_" suffix.Imported the file into the Roundcube database.Edited to reflect $config = array('ident_switch').Downloaded and extracted the ident_switch plugin from BoresExpress on bitbucket.99% sure it boils down to how I'm importing the file into mySQL but my experience is significantly lacking there. ![]() Roundcube works fine and I see the options/fields in the Roundcube web interface to utilize the ident_switch but no data is retained in those field when I enter and save. I'm hitting a roadblock just before the finish line - getting a "a foreign key constraint fails" error. I'm trying to install ident_switch in Roundcube. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |