Problems during upgrade from 2.0.3 to 2.1-rc2

kyrie
kyrie's picture

Joined: 2006-03-10
Posts: 1
Posted: Fri, 2006-03-10 16:13

Core update (Step 3) fails and gives me the following traces.
In addiction, Step 2 tells me "Unable to verify plugins".

Quote:
Stack Trace:
Error (ERROR_STORAGE_FAILURE)

* in modules/core/classes/GalleryStorage.class at line 476 (gallerycoreapi::error)
* in modules/core/classes/Gallery.class at line 223 (mysqlstorage::search)
* in modules/core/classes/helpers/GalleryPluginHelper_simple.class at line 346 (gallery::search)
* in modules/core/classes/helpers/GalleryPluginHelper_simple.class at line 246 (gallerypluginhelper_simple::_fetchallparameters)
* in modules/core/classes/GalleryCoreApi.class at line 229 (gallerypluginhelper_simple::getparameter)
* in upgrade/index.php at line 237 (gallerycoreapi::getpluginparameter)
* in upgrade/steps/UpgradeCoreModuleStep.class at line 74
* in upgrade/index.php at line 216 (upgradecoremodulestep::processrequest)

Output Debug:

file_exists(/var/www/virtualwww/winged.it/gallery/modules/core/classes/helpers/../../../../config.php)
file_exists(/var/www/virtualwww/winged.it/gallery/modules/core/classes/helpers/../../../../plugins/index.modules)
[1142006616] can't guarantee 300 -- extending!

(mysqlt): SET NAMES "utf8"

(mysqlt): SHOW TABLES

file_exists(/var/www/virtualwww/winged.it/g2data/versions.dat)
file(/var/www/virtualwww/winged.it/g2data/versions.dat, )
is_writeable(/var/www/virtualwww/winged.it/gallery/config.php)
getParameter id.adminGroup for core plugin
mysqlt error: [1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT)
and (utf8_general_ci,COERCIBLE) for operation '='] in EXECUTE("
SELECT
g2_PluginParameterMap.g_itemId,
g2_PluginParameterMap.g_parameterName,
g2_PluginParameterMap.g_parameterValue
FROM
g2_PluginParameterMap
WHERE
g2_PluginParameterMap.g_pluginType = 'module'
AND
g2_PluginParameterMap.g_pluginId = 'core'
AND
g2_PluginParameterMap.g_itemId = 0")

(mysqlt):
SELECT
g2_PluginParameterMap.g_itemId,
g2_PluginParameterMap.g_parameterName,
g2_PluginParameterMap.g_parameterValue
FROM
g2_PluginParameterMap
WHERE
g2_PluginParameterMap.g_pluginType = 'module'
AND
g2_PluginParameterMap.g_pluginId = 'core'
AND
g2_PluginParameterMap.g_itemId = 0

1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '='

adodb_mysqlt._execute(
SELECT
g2_PluginParameterMap.g_itemId,
g2_PluginParameterMap.g_parameterName,
g2_PluginParameterMap.g_paramet...) % line 836, file: adodb.inc.php
adodb_mysqlt.execute(
SELECT
g2_PluginParameterMap.g_itemId,
g2_PluginParameterMap.g_parameterName,
g2_PluginParameterMap.g_paramet..., Array[3]) % line 469, file: GalleryStorage.class
mysqlstorage.search(
SELECT
[GalleryPluginParameterMap::itemId],
[GalleryPluginParameterMap::parameterName],
[GalleryPluginParamet..., Array[3], Array[0]) % line 223, file: Gallery.class
gallery.search(
SELECT
[GalleryPluginParameterMap::itemId],
[GalleryPluginParameterMap::parameterName],
[GalleryPluginParamet..., Array[3]) % line 346, file: GalleryPluginHelper_simple.class
gallerypluginhelper_simple._fetchallparameters(module, core,
0) % line 246, file: GalleryPluginHelper_simple.class

realpath(/var/www/virtualwww/winged.it/gallery/modules/core/classes/../../../)


Gallery version (2.0.3):
PHP version (4.3.11):
PHPInfo Link (http://www.winged.it/info/):
Webserver (e.g. Apache 2.0.51):
Database (e.g. MySql 4.1.3):
Activated toolkits (gd):
Operating system (Linux (FedoraCore4)):
Browser (tried with Firefox 1.5 and Mozilla 1.7.12):

<strong><em>So long, and thanks for all the fish.</em></strong>
 
ehubers

Joined: 2006-03-10
Posts: 2
Posted: Fri, 2006-03-10 16:37

i have the same problem! i also wanted to upgrade from 2.03 to 2.1 and get the same output debug
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Fri, 2006-03-10 18:10

FAQ: I get the error 'Illegal mix of collations', what should I do?

 
ehubers

Joined: 2006-03-10
Posts: 2
Posted: Sat, 2006-03-11 13:17

i use MySQL 4.1.7, so that would be my problem, i will try an update, tnx for the help!