Ich habe das Update von 3.1.9 nach 4.1.2 gemäss Anleitung über mehrere Zwischenschritte durchgeführt: 3.1.9 => 3.3.18 => 4.0.13 => 4.1.2. Nun funktioniert alles, bis auf das Kopieren von Terminen. Ich habe in der config.php den debug-Mode eingeschaltet. Nun erhalte ich folgendes auf der dates_function.php Seite:
Code: Alles auswählen
Datenbankfehler
Zurück
S Q L - E R R O R
CODE: 00000
B A C K T R A C E
FILE: adm_program/system/classes/Database.php
LINE: 689
CALL: Database->showError()
FILE: adm_program/system/classes/TableAccess.php
LINE: 531
CALL: Database->queryPrepared()
FILE: adm_program/system/classes/TableRoles.php
LINE: 412
CALL: TableAccess->save()
FILE: adm_program/modules/dates/dates_function.php
LINE: 429
CALL: TableRoles->save()
© 2004 - 2022 Admidio - Impressum - Datenschutz
Code: Alles auswählen
[2022-01-18 22:44:56.020014] Admidio.INFO: SQL: INSERT INTO adm_roles (rol_cat_id,rol_lst_id,rol_name,rol_description,rol_mail_this_role,rol_this_list_view,rol_leader_rights,rol_weekday,rol_max_members,rol_cost_period,rol_usr_id_create,rol_timestamp_create,rol_usr_id_change,rol_valid,rol_uuid) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [3,0,"21.01.2022 20:00 Test3","<p>TEST3</p>\r\n",0,0,1,0,5,0,170,"2022-01-18 22:44:55",0,true,"0c489f27-0fa7-433c-a3ba-23ce01a08207"] {"file":"/www/htdocs/w012b4c9/meldebogen.hfbhk.de/adm_program/system/classes/Database.php","line":666,"class":"Database","function":"queryPrepared"}
[2022-01-18 22:44:56.020279] Admidio.DEBUG: SQL: Execution time 0.240088 ms {"file":"/www/htdocs/w012b4c9/meldebogen.hfbhk.de/adm_program/system/classes/Database.php","line":685,"class":"Database","function":"queryPrepared"}
[2022-01-18 22:44:56.020299] Admidio.CRITICAL: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails ("d020871c"."adm_roles", CONSTRAINT "adm_FK_ROL_LST_ID" FOREIGN KEY ("rol_lst_id") REFERENCES "adm_lists" ("lst_id") ON DELETE SET NULL ON UPDATE SET NULL) {"file":"/www/htdocs/w012b4c9/meldebogen.hfbhk.de/adm_program/system/classes/Database.php","line":688,"class":"Database","function":"queryPrepared"}
[2022-01-18 22:44:56.020513] Admidio.CRITICAL: 00000: | {"file":"/www/htdocs/w012b4c9/meldebogen.hfbhk.de/adm_program/system/classes/Database.php","line":838,"class":"Database","function":"showError"}
- PHP Version (v7.4.26)
- Datenbank Typ + Version (MySQL v5.7.36)
Lars
