Hallo liebes Gambio-Forum, ich habe gerade unseren Shop von 2.0.14 auf 2.3.1.7 upgedatet. Jetzt habe ich folgenden Fehler: USER ERROR(256): "SQL Error" Woran kann das liegen? Ich habe im Forum gesucht und Antworten gefunden, die allerdings nicht allgemein klangen sondern Shop-Speziell. Bin dankbar für Eure Hilfe! Beste Grüße Michael Hewuszt Hier ist noch das Logfile: Code: ================================================================================ 2015-07-15 10:31:24 (fc89d838df3063fd8b3ce18ed3dcc49e) USER ERROR(256): "SQL Error" in /html/typo3/sgvshop/inc/xtc_db_error.inc.php:24 #7 File: /html/typo3/sgvshop/inc/xtc_db_error.inc.php:24 Function: trigger_error('SQL Error', 256) - $message: ### indeterminate value ### - $error_type: ### indeterminate value ### 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: /html/typo3/sgvshop/inc/xtc_db_query.inc.php:68 Function: xtc_db_error(' SELECT `language_id`, `phrase_name`, `phrase_text` FROM language_phrases_cache WHERE `section_name` = \'language_settings\' AND `language_id` = \'2\';', 1146, 'Table \'usr_p195082_4.language_phrases_cache\' doesn\'t exist') - $p_query: ### indeterminate value ### - $p_errno: ### indeterminate value ### - $p_error: ### indeterminate value ### 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: /html/typo3/sgvshop/system/classes/languages/LanguageTextManager.inc.php:585 Function: xtc_db_query(' SELECT `language_id`, `phrase_name`, `phrase_text` FROM language_phrases_cache WHERE `section_name` = \'language_settings\' AND `language_id` = \'2\';') - $p_query: ### indeterminate value ### - $link: ### indeterminate value, default value: 'db_link' ### - $p_enable_data_cache: ### indeterminate value, default value: true ### - $p_enable_logging: ### indeterminate value, default value: true ### Code: │ line 583: $query = sprintf($query, self::$languagePhrasesCacheTable, xtc_db_input($p_section), (int)$p_languageId); │ line 584: ├─ line 585: $result = xtc_db_query($query); │ line 586: while(($row = xtc_db_fetch_array($result))) │ line 587: { #4 File: /html/typo3/sgvshop/system/classes/languages/LanguageTextManager.inc.php:243 Class: LanguageTextManager - $languagePhrasesCacheTable: ### Cannot access protected static property LanguageTextManager::$languagePhrasesCacheTable ### - $defaultLanguageId: ### Cannot access protected property LanguageTextManager::$defaultLanguageId ### - $defaultSection: ### Cannot access protected property LanguageTextManager::$defaultSection ### - $languages: ### Cannot access protected property LanguageTextManager::$languages ### - $sectionMappings: ### Cannot access protected property LanguageTextManager::$sectionMappings ### - $sectionsContent: ### Cannot access protected property LanguageTextManager::$sectionsContent ### - $useFallback: ### Cannot access protected property LanguageTextManager::$useFallback ### Method: _readSectionFromDB('language_settings', 2) - $p_section: 'language_settings' - $p_languageId: 2 Code: │ line 241: } │ line 242: ├─ line 243: $this->_readSectionFromDB($section, $p_languageId); │ line 244: │ line 245: $stopWatch->stop('init_section'); #3 File: /html/typo3/sgvshop/system/classes/languages/LanguageTextManager.inc.php:178 Class: LanguageTextManager - $languagePhrasesCacheTable: ### Cannot access protected static property LanguageTextManager::$languagePhrasesCacheTable ### - $defaultLanguageId: ### Cannot access protected property LanguageTextManager::$defaultLanguageId ### - $defaultSection: ### Cannot access protected property LanguageTextManager::$defaultSection ### - $languages: ### Cannot access protected property LanguageTextManager::$languages ### - $sectionMappings: ### Cannot access protected property LanguageTextManager::$sectionMappings ### - $sectionsContent: ### Cannot access protected property LanguageTextManager::$sectionsContent ### - $useFallback: ### Cannot access protected property LanguageTextManager::$useFallback ### Method: _initSection('language_settings', 2) - $p_section: 'language_settings' - $p_languageId: 2 Code: │ line 176: $sectionName = $this->_getSectionName($p_filePath); │ line 177: ├─ line 178: $this->_initSection($sectionName, $c_languageId); │ line 179: $this->_initConstants($sectionName); │ line 180: $this->_initConstantsFromDeprecatedLangFile($p_filePath); #2 File: /html/typo3/sgvshop/lang/german/init.inc.php:23 Class: LanguageTextManager - $languagePhrasesCacheTable: ### Cannot access protected static property LanguageTextManager::$languagePhrasesCacheTable ### - $defaultLanguageId: ### Cannot access protected property LanguageTextManager::$defaultLanguageId ### - $defaultSection: ### Cannot access protected property LanguageTextManager::$defaultSection ### - $languages: ### Cannot access protected property LanguageTextManager::$languages ### - $sectionMappings: ### Cannot access protected property LanguageTextManager::$sectionMappings ### - $sectionsContent: ### Cannot access protected property LanguageTextManager::$sectionsContent ### - $useFallback: ### Cannot access protected property LanguageTextManager::$useFallback ### Method: init_from_lang_file('language_settings') - $p_filePath: 'language_settings' - $p_languageId: ### default value: 0 ### Code: │ line 21: @setlocale(LC_TIME, 'de_DE.utf8', 'de_DE.UTF-8', 'de_DE@euro', 'de_DE', 'de-DE', 'de', 'ge', 'German'); │ line 22: ├─ line 23: $coo_lang_file_master->init_from_lang_file('language_settings'); │ line 24: $coo_lang_file_master->init_from_lang_file('general'); │ line 25: $coo_lang_file_master->init_from_lang_file('gm_logger'); #1 File: /html/typo3/sgvshop/includes/application_top.php:575 Function: require('/html/typo3/sgvshop/lang/german/init.inc.php') Code: │ line 573: │ line 574: // include the language translations ├─ line 575: require(DIR_WS_LANGUAGES . $_SESSION['language'] . '/init.inc.php'); │ line 576: │ line 577: // currency #0 File: /html/typo3/sgvshop/index.php:27 Function: include('/html/typo3/sgvshop/includes/application_top.php') 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 /sgvshop/?refID=1 - duration: ~0ms - server: Apache - server address: 172.16.48.237 - user agent: Mozilla/5.0 (compatible; AhrefsBot/5.0; +http://ahrefs.com/robot/) - remote address: fc89d838df3063fd8b3ce18ed3dcc49e 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: - refID: 1
Hallo Barbara, ich habe den Update-Assistenten benutzt und bin den Schritten gefolgt. Habe auch schon ein Ticket aufgemacht. Nach erneutem Assistenten-Aufruf und Versuch die einzelnen Schritte durchzuführen, kommt jetzt diese Meldung: Das Update wurde nicht vollständig ausgeführt. Bitte spielen Sie Ihre Datenbanksicherung wieder ein. Folgende SQL-Fehler sind aufgetreten: Code: Query: DELETE lsp.* FROM `language_section_phrases` AS `lsp`, `language_sections` AS `ls`, `language_phrases_cache` AS `lpc` WHERE lsp.language_section_id = ls.language_section_id AND ls.language_id = lpc.language_id AND ls.section_name = lpc.section_name AND lsp.phrase_name = lpc.phrase_name AND lsp.phrase_value = lpc.phrase_text Error message: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' Beste Grüße Michael Hewuszt
Update: Danke an den tollen Gambio-Support. Der Shop läuft wieder. Der Thread hier kann also geschlossen werden. Beste Grüße Michael Hewuszt
Hallo, nach der Ausführung von Update-Assistent, kommt die gleiche Fehlermeldung wie oben geschrieben: Query: DELETE lsp.* FROM `language_section_phrases` AS `lsp`, `language_sections` AS `ls`, `language_phrases_cache` AS `lpc` WHERE lsp.language_section_id = ls.language_section_id AND ls.language_id = lpc.language_id AND ls.section_name = lpc.section_name AND lsp.phrase_name = lpc.phrase_name AND lsp.phrase_value = lpc.phrase_text Error message: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' Wie habt Ihr das gelost? Grüße Eugen