Hallo Leute, ich wollte heute Nacht das Update auf die Neue GX 3.1.1.1.0 Version ausführen. Jedoch habe ich dann vergessen das StyleEdit zu ersetzten und habe daraufhin via FTP alles gelöscht und das Gespeichter vom FTP wieder hochgeladen. Dachte das müsste ja funktionieren. Nur Dummerweise bekomme ich jetzt wenn ich meine Seite aufrufe eine Fehlermeldung. USER ERROR(256): "SQL Error" URL zum Shop: www.reinigungsexpress24.de Das Passende Logfile Dazu lade ich hier mit Hoch. Code: 2016-07-15 05:00:07 (1abfe7c7aa43f22897571b1775e89ec9) USER ERROR(256): "SQL Error" in /customers/9/8/a/reinigungsexpress24.de/httpd.www/inc/xtc_db_error.inc.php:24 #7 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/inc/xtc_db_error.inc.php:24 Code: │ line 22: $coo_logger = LogControl::get_instance(); │ line 23: $coo_logger->notice($p_error, 'error_handler', 'errors', 'notice', 'SQL ERROR', $p_errno, 'Query:' . "\r\n" . trim($p_query)); ├─ line 24: trigger_error('SQL Error', E_USER_ERROR); │ line 25: } #6 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/inc/xtc_db_query.inc.php:68 Code: │ line 66: { │ line 67: # execute query ├─ line 68: $result = mysql_query($p_query, $$link) or xtc_db_error($p_query, mysql_errno(), mysql_error()); │ line 69: │ line 70: # save result to cache #5 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/system/classes/languages/LanguageTextManager.inc.php:220 Code: │ line 218: } │ line 219: ├─ line 220: $t_result = xtc_db_query($t_sql); │ line 221: while(($t_row = xtc_db_fetch_array($t_result))) │ line 222: { #4 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/system/classes/languages/LanguageTextManager.inc.php:274 Code: │ line 272: $this->init_constants($c_section); │ line 273: $this->include_lang_file($c_section); ├─ line 274: $this->init_from_database($c_section, $c_language_id); │ line 275: $this->init_constants($c_section); │ line 276: } #3 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/system/classes/languages/LanguageTextManager.inc.php:246 Code: │ line 244: $c_language_id = $this->v_default_language_id; │ line 245: } ├─ line 246: $this->init_section($p_file_path, $c_language_id); │ line 247: } │ line 248: #2 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/lang/german/german.php:64 Code: │ line 62: } │ line 63: ├─ line 64: $coo_lang_file_master->init_from_lang_file('lang/german/german.php'); │ line 65: $coo_lang_file_master->init_from_lang_file('lang/german/gm_logger.php'); │ line 66: $coo_lang_file_master->init_from_lang_file('lang/german/gm_shopping_cart.php'); #1 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/includes/application_top.php:563 Code: │ line 561: │ line 562: // include the language translations ├─ line 563: require(DIR_WS_LANGUAGES . $_SESSION['language'] . '/' . $_SESSION['language'] . '.php'); │ line 564: │ line 565: // currency #0 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/index.php:27 Code: │ line 25: --------------------------------------------------------------------------------------- */ │ line 26: ├─ line 27: include ('includes/application_top.php'); │ line 28: │ line 29: $coo_listing_control = MainFactory::create_object('ProductListingContentControl'); Request: GET / - duration: ~110ms - server: Apache - server address: 10.27.13.6 - user agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0 - remote address: 1abfe7c7aa43f22897571b1775e89ec9 Session: - tpl: EyeCandy - MOBILE_ACTIVE: false - language: german - languages_id: 2 - language_charset: utf-8 - language_code: de - currency: ### Session entry not present ### - customers_status: ### Session entry not present ### - cart: ### Session entry not present ### - wishList: ### Session entry not present ### - customer_id: ### Session entry not present ### - payment: ### Session entry not present ### - shipping: ### Session entry not present ### - cartID: ### Session entry not present ### - sendto: ### Session entry not present ### - billto: ### Session entry not present ### ================================================================================ 2016-07-15 05:00:07 (1abfe7c7aa43f22897571b1775e89ec9) SQL ERROR(1146): "Table 'reinigungsexpre.language_sections' doesn't exist" in /customers/9/8/a/reinigungsexpress24.de/httpd.www/inc/xtc_db_error.inc.php:23 #7 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/inc/xtc_db_error.inc.php:23 #6 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/inc/xtc_db_query.inc.php:68 #5 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/system/classes/languages/LanguageTextManager.inc.php:220 #4 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/system/classes/languages/LanguageTextManager.inc.php:274 #3 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/system/classes/languages/LanguageTextManager.inc.php:246 #2 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/lang/german/german.php:64 #1 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/includes/application_top.php:563 #0 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/index.php:27 Request: GET /favicon.ico - duration: ~117ms - server: Apache - server address: 10.27.13.6 - user agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0 - remote address: 1abfe7c7aa43f22897571b1775e89ec9 Get: - gm_boosted_category: favicon - cat: c0 Information: Query: SELECT lf.language_id, lfc.phrase_name, lfc.phrase_value FROM language_sections AS lf, language_section_phrases AS lfc WHERE lf.language_section_id = lfc.language_section_id AND (lf.section_name = "lang/german/german.php" OR lf.section_name = "lang/german/german.php") AND lf.language_id IN (2, 2) ================================================================================ 2016-07-15 05:00:07 (1abfe7c7aa43f22897571b1775e89ec9) USER ERROR(256): "SQL Error" in /customers/9/8/a/reinigungsexpress24.de/httpd.www/inc/xtc_db_error.inc.php:24 #7 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/inc/xtc_db_error.inc.php:24 Code: │ line 22: $coo_logger = LogControl::get_instance(); │ line 23: $coo_logger->notice($p_error, 'error_handler', 'errors', 'notice', 'SQL ERROR', $p_errno, 'Query:' . "\r\n" . trim($p_query)); ├─ line 24: trigger_error('SQL Error', E_USER_ERROR); │ line 25: } #6 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/inc/xtc_db_query.inc.php:68 Code: │ line 66: { │ line 67: # execute query ├─ line 68: $result = mysql_query($p_query, $$link) or xtc_db_error($p_query, mysql_errno(), mysql_error()); │ line 69: │ line 70: # save result to cache #5 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/system/classes/languages/LanguageTextManager.inc.php:220 Code: │ line 218: } │ line 219: ├─ line 220: $t_result = xtc_db_query($t_sql); │ line 221: while(($t_row = xtc_db_fetch_array($t_result))) │ line 222: { #4 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/system/classes/languages/LanguageTextManager.inc.php:274 Code: │ line 272: $this->init_constants($c_section); │ line 273: $this->include_lang_file($c_section); ├─ line 274: $this->init_from_database($c_section, $c_language_id); │ line 275: $this->init_constants($c_section); │ line 276: } #3 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/system/classes/languages/LanguageTextManager.inc.php:246 Code: │ line 244: $c_language_id = $this->v_default_language_id; │ line 245: } ├─ line 246: $this->init_section($p_file_path, $c_language_id); │ line 247: } │ line 248: #2 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/lang/german/german.php:64 Code: │ line 62: } │ line 63: ├─ line 64: $coo_lang_file_master->init_from_lang_file('lang/german/german.php'); │ line 65: $coo_lang_file_master->init_from_lang_file('lang/german/gm_logger.php'); │ line 66: $coo_lang_file_master->init_from_lang_file('lang/german/gm_shopping_cart.php'); #1 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/includes/application_top.php:563 Code: │ line 561: │ line 562: // include the language translations ├─ line 563: require(DIR_WS_LANGUAGES . $_SESSION['language'] . '/' . $_SESSION['language'] . '.php'); │ line 564: │ line 565: // currency #0 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/index.php:27 Code: │ line 25: --------------------------------------------------------------------------------------- */ │ line 26: ├─ line 27: include ('includes/application_top.php'); │ line 28: │ line 29: $coo_listing_control = MainFactory::create_object('ProductListingContentControl'); Request: GET /favicon.ico - duration: ~121ms - server: Apache - server address: 10.27.13.6 - user agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0 - remote address: 1abfe7c7aa43f22897571b1775e89ec9 Session: - tpl: EyeCandy - MOBILE_ACTIVE: false - language: german - languages_id: 2 - language_charset: utf-8 - language_code: de - currency: ### Session entry not present ### - customers_status: ### Session entry not present ### - cart: ### Session entry not present ### - wishList: ### Session entry not present ### - customer_id: ### Session entry not present ### - payment: ### Session entry not present ### - shipping: ### Session entry not present ### - cartID: ### Session entry not present ### - sendto: ### Session entry not present ### - billto: ### Session entry not present ### Get: - gm_boosted_category: favicon - cat: c0 ================================================================================ 2016-07-15 05:00:08 (1abfe7c7aa43f22897571b1775e89ec9) SQL ERROR(1146): "Table 'reinigungsexpre.language_sections' doesn't exist" in /customers/9/8/a/reinigungsexpress24.de/httpd.www/inc/xtc_db_error.inc.php:23 #7 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/inc/xtc_db_error.inc.php:23 #6 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/inc/xtc_db_query.inc.php:68 #5 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/system/classes/languages/LanguageTextManager.inc.php:220 #4 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/system/classes/languages/LanguageTextManager.inc.php:274 #3 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/system/classes/languages/LanguageTextManager.inc.php:246 #2 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/lang/german/german.php:64 #1 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/includes/application_top.php:563 #0 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/index.php:27 Request: GET /favicon.ico - duration: ~87ms - server: Apache - server address: 10.27.13.6 - user agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0 - remote address: 1abfe7c7aa43f22897571b1775e89ec9 Get: - gm_boosted_category: favicon - cat: c0 Information: Query: SELECT lf.language_id, lfc.phrase_name, lfc.phrase_value FROM language_sections AS lf, language_section_phrases AS lfc WHERE lf.language_section_id = lfc.language_section_id AND (lf.section_name = "lang/german/german.php" OR lf.section_name = "lang/german/german.php") AND lf.language_id IN (2, 2) ================================================================================ 2016-07-15 05:00:08 (1abfe7c7aa43f22897571b1775e89ec9) USER ERROR(256): "SQL Error" in /customers/9/8/a/reinigungsexpress24.de/httpd.www/inc/xtc_db_error.inc.php:24 #7 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/inc/xtc_db_error.inc.php:24 Code: │ line 22: $coo_logger = LogControl::get_instance(); │ line 23: $coo_logger->notice($p_error, 'error_handler', 'errors', 'notice', 'SQL ERROR', $p_errno, 'Query:' . "\r\n" . trim($p_query)); ├─ line 24: trigger_error('SQL Error', E_USER_ERROR); │ line 25: } #6 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/inc/xtc_db_query.inc.php:68 Code: │ line 66: { │ line 67: # execute query ├─ line 68: $result = mysql_query($p_query, $$link) or xtc_db_error($p_query, mysql_errno(), mysql_error()); │ line 69: │ line 70: # save result to cache #5 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/system/classes/languages/LanguageTextManager.inc.php:220 Code: │ line 218: } │ line 219: ├─ line 220: $t_result = xtc_db_query($t_sql); │ line 221: while(($t_row = xtc_db_fetch_array($t_result))) │ line 222: { #4 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/system/classes/languages/LanguageTextManager.inc.php:274 Code: │ line 272: $this->init_constants($c_section); │ line 273: $this->include_lang_file($c_section); ├─ line 274: $this->init_from_database($c_section, $c_language_id); │ line 275: $this->init_constants($c_section); │ line 276: } #3 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/system/classes/languages/LanguageTextManager.inc.php:246 Code: │ line 244: $c_language_id = $this->v_default_language_id; │ line 245: } ├─ line 246: $this->init_section($p_file_path, $c_language_id); │ line 247: } │ line 248: #2 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/lang/german/german.php:64 Code: │ line 62: } │ line 63: ├─ line 64: $coo_lang_file_master->init_from_lang_file('lang/german/german.php'); │ line 65: $coo_lang_file_master->init_from_lang_file('lang/german/gm_logger.php'); │ line 66: $coo_lang_file_master->init_from_lang_file('lang/german/gm_shopping_cart.php'); #1 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/includes/application_top.php:563 Code: │ line 561: │ line 562: // include the language translations ├─ line 563: require(DIR_WS_LANGUAGES . $_SESSION['language'] . '/' . $_SESSION['language'] . '.php'); │ line 564: │ line 565: // currency #0 File: /customers/9/8/a/reinigungsexpress24.de/httpd.www/index.php:27 Code: │ line 25: --------------------------------------------------------------------------------------- */ │ line 26: ├─ line 27: include ('includes/application_top.php'); │ line 28: │ line 29: $coo_listing_control = MainFactory::create_object('ProductListingContentControl'); Request: GET /favicon.ico - duration: ~93ms - server: Apache - server address: 10.27.13.6 - user agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0 - remote address: 1abfe7c7aa43f22897571b1775e89ec9 Session: - tpl: EyeCandy - MOBILE_ACTIVE: false - language: german - languages_id: 2 - language_charset: utf-8 - language_code: de - currency: ### Session entry not present ### - customers_status: ### Session entry not present ### - cart: ### Session entry not present ### - wishList: ### Session entry not present ### - customer_id: ### Session entry not present ### - payment: ### Session entry not present ### - shipping: ### Session entry not present ### - cartID: ### Session entry not present ### - sendto: ### Session entry not present ### - billto: ### Session entry not present ### Get: - gm_boosted_category: favicon - cat: c0
Habe das Problem behoben, habe mit der Sicherung die ich via FTP geladen habe das Update nochmals ausgeführt und diesmal den Ordner StyleEdit ersetzt und das Update ausführen lassen. Alles hat geklappt und der Shop war wieder erreichbar.