SQL Fehler bei Update 4.0.4 auf 4.1.12

Hast du einen Fehler in der aktuellen Version gefunden ? Diesen kannst du uns hier mitteilen und uns bei der Fehlersuche helfen.
Antworten
Benutzeravatar
jaco
Beiträge: 24
Registriert: 27. Jul 2017, 23:14

SQL Fehler bei Update 4.0.4 auf 4.1.12

Beitrag von jaco »

Hallo,
ich habe wie gewohnt das Update nach Anleitung durchgeführt. Leider stoße ich dabei auf nachfolgende Fehlermerung. Ein Rücksetzten auf die alte Version mit den Dateien aus meine Backup war nicht mehr möglich, es kommt immer die Fehlermeldung das die Datenbank aktueller als die lokalen Dateien sind. Ich dachte mir, okay, dann lade ich halt jede Version dawischen auch runter, aber bis auf ein Link zu github finde ich keine möglichkeit die zwischen Versionen herunter zu laden. Kann mir jemand helfen, welchen SQL Befehle ich laufen lassen muss, um admidio wieder zum laufen zu bekommen?

Danke euch.
Dateianhänge
2022-05-30_22h42_02.png
2022-05-30_22h42_02.png (25.42 KiB) 7314 mal betrachtet
Benutzeravatar
fasse
Administrator
Beiträge: 6041
Registriert: 12. Nov 2005, 16:06

Re: SQL Fehler bei Update 4.0.4 auf 4.1.12

Beitrag von fasse »

Hast du eine Möglichkeit auf ein PHP errorlog zu zugreifen?

Kannst du mal in der Datenbank in der Tabelle adm_components schauen was dort unter com_last_update_step steht?
Benutzeravatar
jaco
Beiträge: 24
Registriert: 27. Jul 2017, 23:14

Re: SQL Fehler bei Update 4.0.4 auf 4.1.12

Beitrag von jaco »

Hallo,
danke für die schnelle Antwort.
In der Datenbank steht bei "Admin Core" unter com_update_step "320" und com_version "4.0.4"

Im Php Log finde ich folgende Fehlermeldung:

Code: Alles auswählen

xx.yyyyyy.de [Mon May 30 22:31:57 2022] [error] [client 91.42.0.0:35776] AH01071: Got error 'PHP message: [2022-05-30 22:31:57.308981] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:31:57.319321] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:31:57.320623] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:31:57.326611] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:31:57.327928] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:31:57.350324] Admidio.CRITICAL: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'usr_uuid' in 'field list'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:31:57.350413] Admidio.CRITICAL: 42S22: 1054 | Unknown column 'usr_uuid' in 'field list'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n', referer https://xx.yyyyyy.de/adm_program/modules/announcements/announcements.php
xx.yyyyyy.de [Mon May 30 22:26:10 2022] [error] [client 91.42.0.0:34282] AH01071: Got error 'PHP message: [2022-05-30 22:26:10.330367] Admidio.CRITICAL: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cre_user.usr_uuid' in 'field list'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:26:10.330428] Admidio.CRITICAL: 42S22: 1054 | Unknown column 'cre_user.usr_uuid' in 'field list'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\nPHP message: [2022-05-30 22:26:10.350128] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:26:10.360556] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:26:10.361920] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:26:10.366219] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:26:10.367551] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\n'
xx.yyyyyy.de [Mon May 30 22:20:07 2022] [error] [client 91.42.0.0:32954] AH01071: Got error 'PHP message: [2022-05-30 22:20:07.244141] Admidio.CRITICAL: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cat_uuid' in 'field list'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:20:07.244203] Admidio.CRITICAL: 42S22: 1054 | Unknown column 'cat_uuid' in 'field list'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\nPHP message: [2022-05-30 22:20:07.262495] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:20:07.272296] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:20:07.273693] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:20:07.277955] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:20:07.279364] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\n'
xx.yyyyyy.de [Mon May 30 22:19:49 2022] [error] [client 91.42.0.0:32890] AH01071: Got error 'PHP message: [2022-05-30 22:19:49.199069] Admidio.CRITICAL: PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'adm_messages_recipients' already exists  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:19:49.199139] Admidio.CRITICAL: 00000:  |   {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n', referer https://xx.yyyyyy.de/adm_program/installation/update.php
xx.yyyyyy.de [Mon May 30 22:19:23 2022] [error] [client 91.42.0.0:32772] AH01071: Got error 'PHP message: [2022-05-30 22:19:23.531812] Admidio.CRITICAL: PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'adm_messages_recipients' already exists  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:19:23.531878] Admidio.CRITICAL: 00000:  |   {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n', referer https://xx.yyyyyy.de/adm_program/installation/update.php
xx.yyyyyy.de [Mon May 30 22:19:09 2022] [error] [client 91.42.0.0:60976] AH01071: Got error 'PHP message: [2022-05-30 22:19:09.566538] Admidio.CRITICAL: PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'adm_messages_recipients' already exists  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:19:09.566607] Admidio.CRITICAL: 00000:  |   {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n', referer https://xx.yyyyyy.de/adm_program/installation/update.php
xx.yyyyyy.de [Mon May 30 22:18:11 2022] [error] [client 91.42.0.0:60792] AH01071: Got error 'PHP message: [2022-05-30 22:18:11.805452] Admidio.CRITICAL: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cat_uuid' in 'field list'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:18:11.805507] Admidio.CRITICAL: 42S22: 1054 | Unknown column 'cat_uuid' in 'field list'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\nPHP message: [2022-05-30 22:18:11.823752] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:11.833818] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:11.835158] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:11.839451] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:11.840819] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\n', referer https://xx.yyyyyy.de/adm_program/overview.php
xx.yyyyyy.de [Mon May 30 22:18:09 2022] [error] [client 91.42.0.0:60784] AH01071: Got error 'PHP message: [2022-05-30 22:18:09.655881] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:09.666263] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:09.667598] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:09.673344] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:09.674728] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:09.697335] Admidio.CRITICAL: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'usr_uuid' in 'field list'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:18:09.697422] Admidio.CRITICAL: 42S22: 1054 | Unknown column 'usr_uuid' in 'field list'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n', referer https://xx.yyyyyy.de/adm_program/modules/documents-files/documents_files.php
xx.yyyyyy.de [Mon May 30 22:18:07 2022] [error] [client 91.42.0.0:60780] AH01071: Got error 'PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: [2022-05-30 22:18:07.755579] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:07.765779] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:07.767124] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:07.771721] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:07.773118] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\n', referer https://xx.yyyyyy.de/adm_program/modules/announcements/announcements.php
xx.yyyyyy.de [Mon May 30 22:18:06 2022] [error] [client 91.42.0.0:60768] AH01071: Got error 'PHP message: [2022-05-30 22:18:06.322471] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:06.337367] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:06.339068] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:06.346017] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:06.347364] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\n', referer https://xx.yyyyyy.de/adm_program/modules/documents-files/documents_files.php
xx.yyyyyy.de [Mon May 30 22:18:04 2022] [error] [client 91.42.0.0:60758] AH01071: Got error 'PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: [2022-05-30 22:18:04.728177] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:04.738106] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:04.739483] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:04.743506] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:04.744875] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\n', referer https://xx.yyyyyy.de/adm_program/modules/announcements/announcements.php
xx.yyyyyy.de [Mon May 30 22:18:02 2022] [error] [client 91.42.0.0:60750] AH01071: Got error 'PHP message: [2022-05-30 22:18:02.625327] Admidio.CRITICAL: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cat_uuid' in 'field list'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:18:02.625382] Admidio.CRITICAL: 42S22: 1054 | Unknown column 'cat_uuid' in 'field list'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\nPHP message: [2022-05-30 22:18:02.642722] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:02.652231] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:02.653590] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:02.658007] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:02.659344] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\n', referer https://xx.yyyyyy.de/adm_program/overview.php
xx.yyyyyy.de [Mon May 30 22:18:00 2022] [error] [client 91.42.0.0:60746] AH01071: Got error 'PHP message: [2022-05-30 22:18:00.828248] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:00.838196] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:00.839547] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:00.845807] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:00.847185] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:18:00.878365] Admidio.CRITICAL: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'usr_uuid' in 'field list'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:18:00.878456] Admidio.CRITICAL: 42S22: 1054 | Unknown column 'usr_uuid' in 'field list'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n', referer https://xx.yyyyyy.de/adm_program/modules/announcements/announcements.php
xx.yyyyyy.de [Mon May 30 22:17:47 2022] [error] [client 91.42.0.0:60708] AH01071: Got error 'PHP message: [2022-05-30 22:17:47.706915] Admidio.CRITICAL: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cat_uuid' in 'field list'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:17:47.706970] Admidio.CRITICAL: 42S22: 1054 | Unknown column 'cat_uuid' in 'field list'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\nPHP message: [2022-05-30 22:17:47.726007] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:17:47.736104] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:17:47.737516] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:17:47.741867] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:17:47.743219] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\n'
xx.yyyyyy.de [Mon May 30 22:17:28 2022] [error] [client 91.42.0.0:60512] AH01071: Got error 'PHP message: [2022-05-30 22:17:28.784915] Admidio.CRITICAL: PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'adm_messages_recipients' already exists  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:17:28.784988] Admidio.CRITICAL: 00000:  |   {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n', referer https://xx.yyyyyy.de/adm_program/installation/update.php
xx.yyyyyy.de [Mon May 30 22:17:21 2022] [error] [client 91.42.0.0:60466] AH01071: Got error 'PHP message: [2022-05-30 22:17:21.256809] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:17:21.266911] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:17:21.268223] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:17:21.274688] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:17:21.276037] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\n'
xx.yyyyyy.de [Mon May 30 22:14:41 2022] [error] [client 91.42.0.0:59692] AH01071: Got error 'PHP message: [2022-05-30 22:14:41.470274] Admidio.CRITICAL: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'w15833-Admidio.adm_messages_recipients' doesn't exist  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:14:41.470345] Admidio.CRITICAL: 42S02: 1146 | Table 'w15833-Admidio.adm_messages_recipients' doesn't exist  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n'
xx.yyyyyy.de [Mon May 30 22:14:27 2022] [error] [client 91.42.0.0:59650] AH01071: Got error 'PHP message: [2022-05-30 22:14:27.618612] Admidio.CRITICAL: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'w15833-Admidio.adm_messages_recipients' doesn't exist  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:14:27.618678] Admidio.CRITICAL: 42S02: 1146 | Table 'w15833-Admidio.adm_messages_recipients' doesn't exist  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n'
xx.yyyyyy.de [Mon May 30 22:14:26 2022] [error] [client 91.42.0.0:59640] AH01071: Got error 'PHP message: [2022-05-30 22:14:26.032711] Admidio.CRITICAL: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'w15833-Admidio.adm_messages_recipients' doesn't exist  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:14:26.032778] Admidio.CRITICAL: 42S02: 1146 | Table 'w15833-Admidio.adm_messages_recipients' doesn't exist  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n'
xx.yyyyyy.de [Mon May 30 22:14:12 2022] [error] [client 91.42.0.0:59556] AH01071: Got error 'PHP message: [2022-05-30 22:14:12.251714] Admidio.CRITICAL: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'w15833-Admidio.adm_messages_recipients' doesn't exist  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:14:12.251786] Admidio.CRITICAL: 42S02: 1146 | Table 'w15833-Admidio.adm_messages_recipients' doesn't exist  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n'
xx.yyyyyy.de [Mon May 30 22:14:08 2022] [error] [client 91.42.0.0:59546] AH01079: failed to make connection to backend: httpd-UDS
xx.yyyyyy.de [Mon May 30 22:14:08 2022] [error] (2)No such file or directory: AH02454: FCGI: attempt to connect to Unix domain socket /var/run/fpm/xx.yyyyyy.de.php74.sock (*) failed
xx.yyyyyy.de [Mon May 30 22:14:04 2022] [error] [client 91.42.0.0:59536] AH01079: failed to make connection to backend: httpd-UDS
xx.yyyyyy.de [Mon May 30 22:14:04 2022] [error] (2)No such file or directory: AH02454: FCGI: attempt to connect to Unix domain socket /var/run/fpm/xx.yyyyyy.de.php74.sock (*) failed
Benutzeravatar
jaco
Beiträge: 24
Registriert: 27. Jul 2017, 23:14

Re: SQL Fehler bei Update 4.0.4 auf 4.1.12

Beitrag von jaco »

ich musste das log aufteilen, da zu viel Zeichen:

Code: Alles auswählen

xx.yyyyyy.de [Mon May 30 23:00:44 2022] [error] [client 205.210.0.0:43748] AH01071: Got error 'PHP message: [2022-05-30 23:00:44.146027] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\n'
xx.yyyyyy.de [Mon May 30 22:55:57 2022] [error] [client 91.42.0.0:42620] AH01071: Got error 'PHP message: [2022-05-30 22:55:57.421433] Admidio.CRITICAL: PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pho_description'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:55:57.421497] Admidio.CRITICAL: 00000:  |   {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n', referer https://xx.yyyyyy.de/adm_program/installation/update.php
xx.yyyyyy.de [Mon May 30 22:55:53 2022] [error] [client 91.42.0.0:42598] AH01071: Got error 'PHP message: [2022-05-30 22:55:53.289044] Admidio.CRITICAL: PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pho_description'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:55:53.289120] Admidio.CRITICAL: 00000:  |   {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n', referer https://xx.yyyyyy.de/adm_program/installation/update.php
xx.yyyyyy.de [Mon May 30 22:54:51 2022] [error] [client 91.42.0.0:42124] AH01071: Got error 'PHP message: [2022-05-30 22:54:51.514194] Admidio.CRITICAL: PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pho_description'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:54:51.514259] Admidio.CRITICAL: 00000:  |   {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n', referer https://xx.yyyyyy.de/adm_program/installation/update.php
xx.yyyyyy.de [Mon May 30 22:54:42 2022] [error] [client 91.42.0.0:42074] AH01071: Got error 'PHP message: [2022-05-30 22:54:42.177432] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:54:42.187084] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:54:42.188445] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:54:42.194304] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:54:42.195671] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\n'
xx.yyyyyy.de [Mon May 30 22:54:18 2022] [error] [client 91.42.0.0:41956] AH01071: Got error 'PHP message: [2022-05-30 22:54:18.939831] Admidio.CRITICAL: PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pho_description'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:54:18.939897] Admidio.CRITICAL: 00000:  |   {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n', referer https://xx.yyyyyy.de/adm_program/installation/update.php?mode=1
xx.yyyyyy.de [Mon May 30 22:54:09 2022] [error] [client 91.42.0.0:41924] AH01071: Got error 'PHP message: [2022-05-30 22:54:09.123259] Admidio.CRITICAL: PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pho_description'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:54:09.123321] Admidio.CRITICAL: 00000:  |   {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n', referer https://xx.yyyyyy.de/adm_program/installation/update.php
xx.yyyyyy.de [Mon May 30 22:54:06 2022] [error] [client 91.42.0.0:41914] AH01071: Got error 'PHP message: [2022-05-30 22:54:06.087807] Admidio.CRITICAL: PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pho_description'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:54:06.087873] Admidio.CRITICAL: 00000:  |   {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n', referer https://xx.yyyyyy.de/adm_program/installation/update.php
xx.yyyyyy.de [Mon May 30 22:53:57 2022] [error] [client 91.42.0.0:41856] AH01071: Got error 'PHP message: [2022-05-30 22:53:57.771943] Admidio.CRITICAL: PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pho_description'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:53:57.772023] Admidio.CRITICAL: 00000:  |   {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n', referer https://xx.yyyyyy.de/adm_program/installation/update.php
xx.yyyyyy.de [Mon May 30 22:41:41 2022] [error] [client 91.42.0.0:38202] AH01071: Got error 'PHP message: [2022-05-30 22:41:41.277982] Admidio.CRITICAL: PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pho_description'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:41:41.278053] Admidio.CRITICAL: 00000:  |   {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n', referer https://xx.yyyyyy.de/adm_program/installation/update.php
xx.yyyyyy.de [Mon May 30 22:41:31 2022] [error] [client 91.42.0.0:38176] AH01071: Got error 'PHP message: [2022-05-30 22:41:31.097680] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:41:31.107461] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:41:31.108782] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:41:31.115759] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:41:31.117123] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\n'
xx.yyyyyy.de [Mon May 30 22:32:35 2022] [error] [client 91.42.0.0:36030] AH01071: Got error 'PHP message: [2022-05-30 22:32:35.919435] Admidio.CRITICAL: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'w15833-Admidio.adm_category_report' doesn't exist  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:32:35.919494] Admidio.CRITICAL: 42S02: 1146 | Table 'w15833-Admidio.adm_category_report' doesn't exist  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\nPHP message: [2022-05-30 22:32:35.937658] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:35.953190] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:35.954549] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:35.960207] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:35.962043] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\n', referer https://xx.yyyyyy.de/adm_program/modules/preferences/preferences.php
xx.yyyyyy.de [Mon May 30 22:32:34 2022] [error] [client 91.42.0.0:36022] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught InvalidArgumentException: Settings value of name "members_list_configuration" is not of type int! in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/SettingsManager.php:180\nStack trace:\n#0 /home/w15833/web/xx.yyyyyy.de/adm_program/modules/members/members.php(40): SettingsManager->getInt('members_list_co...')\n#1 {main}\n  thrown in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/SettingsManager.php on line 180', referer https://xx.yyyyyy.de/adm_program/modules/preferences/preferences.php
xx.yyyyyy.de [Mon May 30 22:32:31 2022] [error] [client 91.42.0.0:36016] AH01071: Got error 'PHP message: [2022-05-30 22:32:31.654730] Admidio.CRITICAL: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'w15833-Admidio.adm_category_report' doesn't exist  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:32:31.654788] Admidio.CRITICAL: 42S02: 1146 | Table 'w15833-Admidio.adm_category_report' doesn't exist  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\nPHP message: [2022-05-30 22:32:31.673066] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:31.682300] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:31.683663] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:31.687870] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:31.689323] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\n', referer https://xx.yyyyyy.de/adm_program/modules/preferences/preferences.php
xx.yyyyyy.de [Mon May 30 22:32:28 2022] [error] [client 91.42.0.0:35988] AH01071: Got error 'PHP message: [2022-05-30 22:32:28.915981] Admidio.CRITICAL: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'w15833-Admidio.adm_category_report' doesn't exist  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:32:28.916046] Admidio.CRITICAL: 42S02: 1146 | Table 'w15833-Admidio.adm_category_report' doesn't exist  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\nPHP message: [2022-05-30 22:32:28.942676] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:28.954068] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:28.955406] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:28.959623] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:28.960992] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\n', referer https://xx.yyyyyy.de/adm_program/modules/messages/messages.php
xx.yyyyyy.de [Mon May 30 22:32:18 2022] [error] [client 91.42.0.0:35930] AH01071: Got error 'PHP message: [2022-05-30 22:32:18.147394] Admidio.CRITICAL: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'w15833-Admidio.adm_messages_attachments' doesn't exist  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:32:18.147449] Admidio.CRITICAL: 42S02: 1146 | Table 'w15833-Admidio.adm_messages_attachments' doesn't exist  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\nPHP message: [2022-05-30 22:32:18.170924] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:18.181062] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:18.182420] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:18.188570] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:18.190010] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\n', referer https://xx.yyyyyy.de/adm_program/modules/messages/messages.php
xx.yyyyyy.de [Mon May 30 22:32:17 2022] [error] [client 91.42.0.0:35922] AH01071: Got error 'PHP message: [2022-05-30 22:32:17.873169] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:17.883416] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:17.884727] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:17.890271] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:17.891593] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\n', referer https://xx.yyyyyy.de/adm_program/modules/documents-files/documents_files.php
xx.yyyyyy.de [Mon May 30 22:32:14 2022] [error] [client 91.42.0.0:35898] AH01071: Got error 'PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: PHP Notice:  Undefined index: fol_uuid in /home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/TableFolder.php on line 634PHP message: [2022-05-30 22:32:14.522118] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:14.532196] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:14.533641] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:14.538396] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:14.539905] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\n', referer https://xx.yyyyyy.de/adm_program/modules/announcements/announcements.php
xx.yyyyyy.de [Mon May 30 22:32:12 2022] [error] [client 91.42.0.0:35884] AH01071: Got error 'PHP message: [2022-05-30 22:32:12.442332] Admidio.CRITICAL: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cre_user.usr_uuid' in 'field list'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:32:12.442394] Admidio.CRITICAL: 42S22: 1054 | Unknown column 'cre_user.usr_uuid' in 'field list'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\nPHP message: [2022-05-30 22:32:12.460918] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:12.471734] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:12.473098] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:12.477748] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:12.479144] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\n', referer https://xx.yyyyyy.de/adm_program/overview.php
xx.yyyyyy.de [Mon May 30 22:32:11 2022] [error] [client 91.42.0.0:35880] AH01071: Got error 'PHP message: [2022-05-30 22:32:11.381325] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:11.391462] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:11.392828] Admidio.ERROR: L10N: Could not found text-id! {"textId":"LNK_WEBLINKS_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:11.398779] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:11.400121] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MEM_USER_MANAGEMENT_DESC"} {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\nPHP message: [2022-05-30 22:32:11.422865] Admidio.CRITICAL: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'usr_uuid' in 'field list'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-05-30 22:32:11.422952] Admidio.CRITICAL: 42S22: 1054 | Unknown column 'usr_uuid' in 'field list'  {"file":"/home/w15833/web/xx.yyyyyy.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n', referer https://xx.yyyyyy.de/adm_program/overview.php
Benutzeravatar
fasse
Administrator
Beiträge: 6041
Registriert: 12. Nov 2005, 16:06

Re: SQL Fehler bei Update 4.0.4 auf 4.1.12

Beitrag von fasse »

Hallo Jaco,

also irgendwas ist bei dir beim Update schief gelaufen. Die Fehler aus dem Log deuten darauf hin, dass nicht alle Update-Schritte erfolgreich durchlaufen wurden.

Hast du ein Backup der Datenbank gemacht?
Wenn ja, dann wäre es gut, alle adm* Tabellen in der Datenbank zu löschen und das Backup wieder einzuspielen. Anschließend dann das Update-Script erneut starten. Sollte es nicht bis zum Ende laufen, wäre dann wieder der Inhalt der adm_components interessant.

Viele Grüße
Fasse
Benutzeravatar
jaco
Beiträge: 24
Registriert: 27. Jul 2017, 23:14

Re: SQL Fehler bei Update 4.0.4 auf 4.1.12

Beitrag von jaco »

Ich habe leider kein BackUp der Datenbank vor dem Update gemacht. Das Filesystem schon. Ich habe schon versucht, in der Component Tabelle die Einträge manuel zurück zu setzten, damit das Update Script nochmal von vorne läuft, aber leider ohne erfolg. Ich würde ja auch die Update SQL scripte manuell laufen lassen, aber ich habe die SQL befehle die durchlaufen werden müssen nicht gefunden.
Benutzeravatar
jaco
Beiträge: 24
Registriert: 27. Jul 2017, 23:14

Re: SQL Fehler bei Update 4.0.4 auf 4.1.12

Beitrag von jaco »

fasse hat geschrieben: 31. Mai 2022, 21:01 Sollte es nicht bis zum Ende laufen, wäre dann wieder der Inhalt der adm_components interessant.
Also, ich habe die DB jetzt so weit es ging wieder zurück gesetzt, aber laufe wieder auf den gleichen Fehler. In der adm_components steht jetzt überall bei com_version 4.0.4 drin und bei com_update_step nur bei Admidio Core 320. Was ist denn Step 320, wo kann ich sehen, was da gemacht werden soll, vielleicht kann ich das manuell durchführen?

Gibt es irgendwo noch die Möglichkeit die zwischen Versionen zwischen 4.0.4 und 4.1.12 zu downloaden, dann würde ich mal versuchen jedes einzelne Update dazwischen durchzuführen.
Benutzeravatar
jaco
Beiträge: 24
Registriert: 27. Jul 2017, 23:14

Re: SQL Fehler bei Update 4.0.4 auf 4.1.12

Beitrag von jaco »

Ich habe jetzt auf den Fileserver noch eine ältere Version 4.0.5 gefunden und die mal auf den Server hochgeladen in der Hoffnung das einzelne Update Schritte das Problem lösen.

Auch beim Update von 4.0.4 auf 4.0.5 stoße ich auf den gleichen Fehler:

Code: Alles auswählen

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: 720
CALL: Database->showError()

FILE: adm_program/system/classes/ComponentUpdate.php
LINE: 141
CALL: Database->queryPrepared()

FILE: adm_program/system/classes/ComponentUpdate.php
LINE: 184
CALL: ComponentUpdate->executeUpdateSql()

FILE: adm_program/system/classes/ComponentUpdate.php
LINE: 258
CALL: ComponentUpdate->executeStep()

FILE: adm_program/installation/update_functions.php
LINE: 129
CALL: ComponentUpdate->update()

FILE: adm_program/installation/update_functions.php
LINE: 156
CALL: doVersion3Update()

FILE: adm_program/installation/update.php
LINE: 294
CALL: doAdmidioUpdate()
Obwohl ich in der com_update_step den Wert zurück gesetzt habe, steht hier wieder bei Admidio Core 320. Was ist 320 für ein Schritt und was könnte hierbei schief laufen?

Im Logfile steht wieder diese Fehlermeldung:

Code: Alles auswählen

my.xxx.de [Wed Jun 01 10:54:31 2022] [error] [client 87.157.0.0:38986] AH01071: Got error 'PHP message: [2022-06-01 10:54:31.406773] Admidio.CRITICAL: PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pho_description'  {"file":"/home/w15833/web/my.nes-ev.de/adm_program/system/classes/Database.php","line":719,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-06-01 10:54:31.406846] Admidio.CRITICAL: 00000:  |   {"file":"/home/w15833/web/my.nes-ev.de/adm_program/system/classes/Database.php","line":881,"class":"Database","function":"showError"}\n', referer https://my.nes-ev.de/adm_program/installation/update.php
my.xxx.de [Wed Jun 01 10:48:25 2022] [error] [client 87.157.0.0:37642] AH01071: Got error 'PHP message: [2022-06-01 10:48:25.119411] Admidio.CRITICAL: PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pho_description'  {"file":"/home/w15833/web/my.nes-ev.de/adm_program/system/classes/Database.php","line":705,"class":"Database","function":"queryPrepared"}\nPHP message: [2022-06-01 10:48:25.119476] Admidio.CRITICAL: 00000:  |   {"file":"/home/w15833/web/my.nes-ev.de/adm_program/system/classes/Database.php","line":855,"class":"Database","function":"showError"}\n', referer https://my.nes-ev.de/adm_program/installation/update.php
my.xxx.de [Wed Jun 01 10:26:21 2022] [error] [client 54.74.0.0:60512] AH01071: Got error 'PHP message: [2022-06-01 10:26:21.261856] Admidio.ERROR: L10N: Could not found text-id! {"textId":"MAI_EMAIL_DESC"} {"file":"/home/w15833/web/my.nes-ev.de/adm_program/system/classes/Language.php","line":115,"class":"Language","function":"get"}\n'
Benutzeravatar
jaco
Beiträge: 24
Registriert: 27. Jul 2017, 23:14

Re: SQL Fehler bei Update 4.0.4 auf 4.1.12

Beitrag von jaco »

So, ich kann Erfolg melden. Nachdem ich mich Schritt für Schritt durch jede einzelne Version gearbeitet habe, einige Tabellen, Spalten oder Indexe gelöscht habe, sind dann auch die Updates wieder durchgelaufen.

Danke nochmal für den Hinweis im php Error Log, der hat mir eigentlich am besten gesagt, wo ich was zu tun habe. Gut, dass ich mich mit SQL auskenne. :-D
Benutzeravatar
fasse
Administrator
Beiträge: 6041
Registriert: 12. Nov 2005, 16:06

Re: SQL Fehler bei Update 4.0.4 auf 4.1.12

Beitrag von fasse »

Hallo Jaco,

schön das es jetzt bei dir geklappt hat. Irgendwas war bei dir sehr sonderbar. Das der update_step auf 320 stand, deutet darauf hin, dass das Update nicht komplett durchgelaufen war, sondern irgendwo zwischen drin abgebrochen ist.

Beim nächsten mal auf jeden Fall ein Datenbank-Update machen. Das ist noch wichtiger als ein File-System-Backup. Mit dem Datenbankupdate kann man dann immer wieder zurück zur letzten Version und das Update erneut durchführen und ggf. so auch den konkreten Fehler noch mal nachstellen und finden. Im Zweifel kann man dann auch erst einmal mit der alten Version weiter arbeiten.

Viele Grüße
Fasse
Antworten