An error occurred while upgrading Gallery Core Module

Please fill out the following form and take a look at the linked pages. The more information you supply, the better we can help you. Please post issues about errors using Gallery 2 in the Troubleshooting Forum.
FAQ:
- How can I find a solution for my problem?
Visit http://codex.gallery2.org/index.php/Gallery2:How_Tos and take a look at the FAQ and other documentation pages
Also try your luck with the advanced search function of this website
- What information is required when asking for help in the forums?
http://codex.gallery2.org/index.php/Gallery2:faq#What_information_is_required_when_I_ask_for_help_in_the_forums.3F
- You can copy and paste a lot of the required information from "Site Admin" -> "Maintenance" -> "System Information" if your G2 is up and running.

Last Run Details:

Gallery version = 2.0 core 1.0.0
PHP version = 4.3.2 apache2filter
Webserver = Apache/2.0.46 (Red Hat)
Database = mysql 4.1.7-standard
Toolkits = ArchiveUpload, Exif, Gd, ImageMagick, NetPBM
Operating system = Linux ns 2.4.21-4.EL #1 Fri Oct 3 18:13:58 EDT 2003 i686
Browser = Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7

An error occurred while upgrading Gallery Core Module

Something went wrong when we tried to upgrade the core module. In the boxes below you can find some debug information. Report this in the Gallery Forums and we'll help you diagnose the problem.
Stack Trace:
Error (ERROR_STORAGE_FAILURE) : Error trying to run query: UPDATE g2_Schema SET g_major=1, g_minor=3 WHERE g_name='PluginParameterMap' AND g_major=1 AND g_minor=2;

* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1528 (gallerycoreapi::error)
* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1304 (gallerystorageextras::_executesql)
* in modules/core/classes/GalleryStorage.class at line 625 (gallerystorageextras::configurestore)
* in modules/core/CoreModuleExtras.inc at line 1295 (mysqlstorage::configurestore)
* in modules/core/module.inc at line 487 (coremoduleextras::upgrade)
* in modules/core/classes/GalleryModule.class at line 157 (coremodule::upgrade)
* in upgrade/steps/UpgradeCoreModuleStep.class at line 83 (coremodule::installorupgrade)
* in upgrade/index.php at line 221 (upgradecoremodulestep::processrequest)

Debug Output:

file_exists(/var/www/cosmicpond.com/modules/core/classes/helpers/../../../../config.php)
file_exists(/var/www/cosmicpond.com/modules/core/classes/helpers/../../../../plugins/index.modules)
[1158812300] can't guarantee 300 -- extending!

(mysql): SET NAMES "utf8"

(mysql): SHOW TABLES

file_exists(/home/gallery2/g2data/versions.dat)
file(/home/gallery2/g2data/versions.dat, )
is_writeable(/var/www/cosmicpond.com/config.php)
getParameter id.adminGroup for core plugin
mysql 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")

(mysql):
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_mysql._execute(
SELECT
g2_PluginParameterMap.g_itemId,
g2_PluginParameterMap.g_parameterName,
g2_PluginParameterMap.g_paramet...) % line 836, file: adodb.inc.php
adodb_mysql.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/cosmicpond.com/modules/core/classes/../../../)
Unable to selectAdminUser for core upgrade: 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 231
(gallerypluginhelper_simple::getparameter)
in upgrade/index.php at line 242
(gallerycoreapi::getpluginparameter)
in upgrade/steps/UpgradeCoreModuleStep.class at line 74
in upgrade/index.php at line 221
(upgradecoremodulestep::processrequest)

GalleryModule::installOrUpgrade core module
In bootstrap mode (core module)
Configure store for core module
file_exists(/var/www/cosmicpond.com/modules/core/classes/helpers/../../../../modules/core/classes/GalleryStorage/schema.tpl)
file(/var/www/cosmicpond.com/modules/core/classes/helpers/../../../../modules/core/classes/GalleryStorage/schema.tpl,
)

(mysql): SHOW TABLES

(mysql): SELECT g_name, g_major, g_minor FROM g2_Schema

Upgrade (or install) core module
Entering CoreModuleExtras::upgrade
The current version is 1.0.0
file_exists(/var/www/cosmicpond.com/modules/core/classes/helpers/../../../../modules/core/classes/GalleryStorage/schema.tpl)
file(/var/www/cosmicpond.com/modules/core/classes/helpers/../../../../modules/core/classes/GalleryStorage/schema.tpl,
)

(mysql): SHOW TABLES

(mysql): SELECT g_name, g_major, g_minor FROM g2_Schema

(mysql): ALTER TABLE g2_PluginParameterMap
MODIFY COLUMN g_parameterValue text NOT NULL

mysql error: [1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT)
and (utf8_general_ci,COERCIBLE) for operation '='] in EXECUTE("UPDATE
g2_Schema
SET g_major=1, g_minor=3
WHERE g_name='PluginParameterMap' AND g_major=1 AND g_minor=2;")

(mysql): UPDATE g2_Schema
SET g_major=1, g_minor=3
WHERE g_name='PluginParameterMap' AND g_major=1 AND g_minor=2;

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

adodb_mysql._execute(UPDATE g2_Schema
SET g_major=1, g_minor=3
WHERE g_name='PluginParameterMap' AND g_major=1 AND g_minor=2;,
false) % line 855, file: adodb.inc.php
adodb_mysql.execute(UPDATE g2_Schema
SET g_major=1, g_minor=3
WHERE g_name='PluginParameterMap' AND g_major=1 AND
g_minor=2;) % line 1524, file: GalleryStorageExtras.class
gallerystorageextras._executesql(ALTER TABLE
DB_TABLE_PREFIXPluginParameterMap
MODIFY COLUMN DB_COLUMN_PREFIXparameterValue text NOT NULL;

UPDATE DB_TABLE_PRE...) % line 1304,
file: GalleryStorageExtras.class
gallerystorageextras.configurestore(core,
Array[1]) % line 625, file: GalleryStorage.class
mysqlstorage.configurestore(core, Array[1]) % line 1295, file: CoreModuleExtras.inc

realpath(/var/www/cosmicpond.com/modules/core/classes/../../../)
Error: Failed to upgrade the core module, this is the error stack trace:
Error (ERROR_STORAGE_FAILURE) : Error trying to run query: UPDATE
g2_Schema
SET g_major=1, g_minor=3
WHERE g_name='PluginParameterMap' AND g_major=1 AND g_minor=2;in
modules/core/classes/GalleryStorage/GalleryStorageExtras.class at
line 1528 (gallerycoreapi::error)
in modules/core/classes/GalleryStorage/GalleryStorageExtras.class
at line 1304 (gallerystorageextras::_executesql)
in modules/core/classes/GalleryStorage.class at line 625
(gallerystorageextras::configurestore)
in modules/core/CoreModuleExtras.inc at line 1295
(mysqlstorage::configurestore)
in modules/core/module.inc at line 487
(coremoduleextras::upgrade)
in modules/core/classes/GalleryModule.class at line 157
(coremodule::upgrade)
in upgrade/steps/UpgradeCoreModuleStep.class at line 83
(coremodule::installorupgrade)
in upgrade/index.php at line 221
(upgradecoremodulestep::processrequest)

realpath(/var/www/cosmicpond.com/modules/core/classes/../../../)

Thanks for the link Bharat.

WetWilly,

No need to go through the whole thread, just read the last 3 messages:
http://gallery.menalto.com/node/39444#comment-157891

As far as I can remember, the problem is that you need to set the charset for the connection before the upgrade starts, then you do the upgrade and finally you can remove your modification of the code again.