I had gallery unpossible 2.01 installed and then I upgraded to the lastest. Everything was working fine untill I upgraded.
Here is the error report while trying to update the files
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)
in modules/core/classes/GalleryStorage.class at line 431 (MySqlStorage::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 206 (GalleryCoreApi::getPluginParameter)
in upgrade/steps/UpgradeCoreModuleStep.class at line 75
in upgrade/index.php at line 185 (UpgradeCoreModuleStep::processRequest)
Debug Output:
file_exists(/home/clock/public_html/cgi-bin/gallery2/modules/core/classes/helpers/../../../../config.php)
file_exists(/home/clock/public_html/cgi-bin/gallery2/modules/core/classes/helpers/../../../../plugins/index.modules)
[1140763875] can't guarantee 300 -- extending!
--------------------------------------------------------------------------------
(mysql): SET NAMES "utf8"
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysql): SHOW TABLES
--------------------------------------------------------------------------------
file_exists(/home/clock/public_html/cgi-bin/gallery2/g2data/versions.dat)
file(/home/clock/public_html/cgi-bin/gallery2/g2data/versions.dat, )
is_writeable(/home/clock/public_html/cgi-bin/gallery2/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 424, 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(/home/clock/public_html/cgi-bin/gallery2/modules/core/classes/../../../)
Posted: Fri, 2006-02-24 06:58
Posts: 32356
> mysql error: [1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT)
> and (utf8_general_ci,COERCIBLE) for operation '=']
you're not the first to have that problem. probably it's because we change to utf8 db connections before the data is transformed.
i suggest you revert to your backup then add a small line to upgrade/steps/UpgradeCoreModuleStep.class and to modules/core/CoreModuleExtras.inc and try again.
we haven't yet a fix four you, but it will be along the lines of:
http://gallery.pastebin.com/569892
Posts: 8598
FAQ: I get the error 'Illegal mix of collations', what should I do?