Hello gurus,
I have got a real problem with the upgrade of the Version 2.0 to 2.1. It gives me many errors like
Error (ERROR_STORAGE_FAILURE, ERROR_UNKNOWN) : 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/gallery2/modules/core/classes/helpers/../../../../config.php)
file_exists(/var/gallery2/modules/core/classes/helpers/../../../../plugins/index.modules)
[1148465748] can't guarantee 300 -- extending!
--------------------------------------------------------------------------------
(mysql): SET NAMES "utf8"
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysql): SHOW TABLES
--------------------------------------------------------------------------------
file_exists(/var/gallery2/g2data/versions.dat)
file(/var/gallery2/g2data/versions.dat, )
is_writeable(/var/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 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/gallery2/modules/core/classes/../../../)
Unable to selectAdminUser for core upgrade: Error (ERROR_STORAGE_FAILURE,
ERROR_UNKNOWN)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/gallery2/modules/core/classes/helpers/../../../../modules/core/classes/GalleryStorage/schema.tpl)
file(/var/gallery2/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.x
file_exists(/var/gallery2/modules/core/classes/helpers/../../../../modules/core/classes/GalleryStorage/schema.tpl)
file(/var/gallery2/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/gallery2/modules/core/classes/../../../)
Error: Failed to upgrade the core module, this is the error stack trace:
Error (ERROR_STORAGE_FAILURE, ERROR_UNKNOWN) : 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/gallery2/modules/core/classes/../../../)
Have you got an idea, what could be wrong with my gallery?
What can be done?
Thank you very much in advance!
Posted: Tue, 2006-05-23 13:06
