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 <jo...@karliak.cz> 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