Re: [RCU] Upgrade RCU from 1.4.13 to 1.5.3 and DB schema update error
Hi, thanks for tip - I deleted them, all is fine. I also found another upgrade issues - there were some account (table "users") that were with upper/lower case. Like johndoe/Johndoe ... Error : ERROR: Error in DDL upgrade 2020020101: [1062] Duplicate entry '' for key 'username" -or- ERROR: Error in DDL upgrade 2020020101: [1062] Duplicate entry 'Johndoe-server.example.com' for key 'username' Deleting this records solved the problem and DB schema was succesfully updated. Dne 2023-07-10 14:38, Zhang Huangbin napsal: On Jul 10, 2023, at 5:58 PM, Josef Karliak wrote: ERROR: Error in DDL upgrade 2020020101: [1834] Cannot delete rows from table which is parent in a foreign key constraint 'fk_calendars_user_id' of table 'calendars' Updating database schema (2020020101)... [FAILED] ... But I do not see any SQL query for table "calendars" in "2020020101.sql" file. Seems this foreign key was created by a third-party plugin. Zhang Huangbin, founder of: - iRedMail: Open source email server solution: https://www.iredmail.org/ - Spider: Lightweight, on-premises Email Archiving Software: https://spiderd.io ___ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users___ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
Re: [RCU] Upgrade RCU from 1.4.13 to 1.5.3 and DB schema update error
> On Jul 10, 2023, at 5:58 PM, Josef Karliak wrote: > > ERROR: Error in DDL upgrade 2020020101: [1834] Cannot delete rows from table > which is parent in a foreign key constraint 'fk_calendars_user_id' of table > 'calendars' > Updating database schema (2020020101)... [FAILED] > ... > But I do not see any SQL query for table "calendars" in "2020020101.sql" > file. Seems this foreign key was created by a third-party plugin. Zhang Huangbin, founder of: - iRedMail: Open source email server solution: https://www.iredmail.org/ - Spider: Lightweight, on-premises Email Archiving Software: https://spiderd.io ___ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
Re: [RCU] Upgrade RCU from 1.4.13 to 1.5.3 and DB schema update error
At the bottom of each email there's a link. Use it. If you can't find it, simply use: http://lists.roundcube.net/mailman/listinfo/users On Mon, Jul 10, 2023 at 2:28 PM Roas Solutions wrote: > Can someone please let me know how to unsubscribe from this mailing list? > > On Mon, 10 Jul 2023 at 12:11, Josef Karliak wrote: > >> Good morning, >> >> install script fails when updating DB schema from 1.4.13 to 1.5.3 : >> >> ... >> >> ... >> >> >> Running update script at target... >> Executing database schema update. >> Updating database schema (2020020100)... [OK] >> ERROR: Error in DDL upgrade 2020020101: [1834] Cannot delete rows from >> table which is parent in a foreign key constraint 'fk_calendars_user_id' of >> table 'calendars' >> Updating database schema (2020020101)... [FAILED] >> >> ... >> >> ... >> >> >> But I do not see any SQL query for table "calendars" in "2020020101.sql >> " file. >> >> Any ideas? >> >> Previous upgrading from 1.4.11 to 1.4.13 passed OK. >> >> Thanks and best regards >> >> J.Karliak >> >> >> >> >> >> ___ >> Roundcube Users mailing list >> users@lists.roundcube.net >> http://lists.roundcube.net/mailman/listinfo/users > > ___ > Roundcube Users mailing list > users@lists.roundcube.net > http://lists.roundcube.net/mailman/listinfo/users -- Cu drag, madalin http://madalin.eu ___ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
Re: [RCU] Upgrade RCU from 1.4.13 to 1.5.3 and DB schema update error
Can someone please let me know how to unsubscribe from this mailing list? On Mon, 10 Jul 2023 at 12:11, Josef Karliak wrote: > Good morning, > > install script fails when updating DB schema from 1.4.13 to 1.5.3 : > > ... > > ... > > > Running update script at target... > Executing database schema update. > Updating database schema (2020020100)... [OK] > ERROR: Error in DDL upgrade 2020020101: [1834] Cannot delete rows from > table which is parent in a foreign key constraint 'fk_calendars_user_id' of > table 'calendars' > Updating database schema (2020020101)... [FAILED] > > ... > > ... > > > But I do not see any SQL query for table "calendars" in "2020020101.sql > " file. > > Any ideas? > > Previous upgrading from 1.4.11 to 1.4.13 passed OK. > > Thanks and best regards > > J.Karliak > > > > > > ___ > Roundcube Users mailing list > users@lists.roundcube.net > http://lists.roundcube.net/mailman/listinfo/users ___ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users