gelöst Hilfe: SQL Error nach Update auf 2.3.1.7

Anonymous · 15. Juli 2015

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

Anonymous · 15. Juli 2015

Hast Du den Update-Assistenten benutzt?
Wie genau hast Du das Update gemacht?

Anonymous · 15. Juli 2015

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

Anonymous · 15. Juli 2015

Update: Danke an den tollen Gambio-Support. Der Shop läuft wieder.
Der Thread hier kann also geschlossen werden.

Beste Grüße
Michael Hewuszt

Anonymous · 15. Juli 2015

Freut mich

Anonymous · 20. August 2015

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

Foren

gelöst Hilfe: SQL Error nach Update auf 2.3.1.7

SGV Verlag Mitglied

barbara G-WARD 2014-2020

SGV Verlag Mitglied

SGV Verlag Mitglied

barbara G-WARD 2014-2020

Vera Foti Neues Mitglied