problems upgrading to 2.1

ziddey

Joined: 2004-11-01
Posts: 52
Posted: Wed, 2006-01-18 00:46

The following information is required to get an answer:
Get this information from the PHP diagnostic (in the configuration wizard).
Gallery URL (optional but very useful):
Gallery version: just did cvs update -Pd and upgrade died
Apache version: 2
PHP version (don't just say PHP 4, please): 4.3.11
Graphics Toolkit: irrelavant
Operating system: 2.6
Web browser/version (if applicable):

here it is!

Stack Trace:
Error (ERROR_STORAGE_FAILURE) : Error trying to run query: ALTER TABLE g2_AccessMap DROP COLUMN g_userId, DROP COLUMN g_groupId, ADD PRIMARY KEY(g_accessListId, g_userOrGroupId), ADD INDEX g2_AccessMap_48775(g_userOrGroupId)

* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1449 (gallerycoreapi::error)
* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1225 (gallerystorageextras::_executesql)
* in modules/core/classes/GalleryStorage.class at line 559 (gallerystorageextras::configurestore)
* in modules/core/CoreModuleExtras.inc at line 1300 (mysqlstorage::configurestore)
* in modules/core/module.inc at line 492 (coremoduleextras::upgrade)
* in modules/core/classes/GalleryModule.class at line 157 (coremodule::upgrade)
* in upgrade/steps/UpgradeCoreModuleStep.class at line 81 (coremodule::installorupgrade)
* in upgrade/index.php at line 185 (upgradecoremodulestep::processrequest)

Debug Output:

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

(mysql): SHOW TABLES

file_exists(/var/www/g2data/versions.dat)
file(/var/www/g2data/versions.dat, )
is_writeable(/var/www/html/gallery2/config.php)
getParameter id.adminGroup for core plugin

(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

(mysql):
SELECT
g2_UserGroupMap.g_userId,
g2_User.g_userName
FROM
g2_UserGroupMap, g2_User
WHERE
g2_UserGroupMap.g_groupId = 2
AND
g2_UserGroupMap.g_userId = g2_User.g_id

ORDER BY
g2_User.g_userName
LIMIT 1

(mysql): SELECT g_id, g_entityType FROM g2_Entity WHERE g_id IN (5)

(mysql):
SELECT
g2_PluginMap.g_pluginId,
g2_PluginMap.g_active
FROM
g2_PluginMap
WHERE
g2_PluginMap.g_pluginType = 'module'

opendir(/var/www/html/gallery2/modules/)
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/thumbnail)
file_exists(/var/www/html/gallery2/modules/thumbnail/module.inc)
getParameter _version for thumbnail plugin

(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 = 'thumbnail'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for thumbnail plugin
getParameter _requiredCoreApi for thumbnail plugin
getParameter _requiredModuleApi for thumbnail plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/picasa)
file_exists(/var/www/html/gallery2/modules/picasa/module.inc)
getParameter _version for picasa plugin

(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 = 'picasa'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for picasa plugin
getParameter _requiredCoreApi for picasa plugin
getParameter _requiredModuleApi for picasa plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/randomhighlight)
file_exists(/var/www/html/gallery2/modules/randomhighlight/module.inc)
getParameter _version for randomhighlight plugin

(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 = 'randomhighlight'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for randomhighlight plugin
getParameter _requiredCoreApi for randomhighlight plugin
getParameter _requiredModuleApi for randomhighlight plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/webcam)
file_exists(/var/www/html/gallery2/modules/webcam/module.inc)
getParameter _version for webcam plugin

(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 = 'webcam'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for webcam plugin
getParameter _requiredCoreApi for webcam plugin
getParameter _requiredModuleApi for webcam plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/exif)
file_exists(/var/www/html/gallery2/modules/exif/module.inc)
getParameter _version for exif plugin

(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 = 'exif'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for exif plugin
getParameter _requiredCoreApi for exif plugin
getParameter _requiredModuleApi for exif plugin
readdir(Resource id #41)
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/linkitem)
file_exists(/var/www/html/gallery2/modules/linkitem/module.inc)
getParameter _version for linkitem plugin

(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 = 'linkitem'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for linkitem plugin
getParameter _requiredCoreApi for linkitem plugin
getParameter _requiredModuleApi for linkitem plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/icons)
file_exists(/var/www/html/gallery2/modules/icons/module.inc)
getParameter _version for icons plugin

(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 = 'icons'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for icons plugin
getParameter _requiredCoreApi for icons plugin
getParameter _requiredModuleApi for icons plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/photoaccess)
file_exists(/var/www/html/gallery2/modules/photoaccess/module.inc)
getParameter _version for photoaccess plugin

(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 = 'photoaccess'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for photoaccess plugin
getParameter _requiredCoreApi for photoaccess plugin
getParameter _requiredModuleApi for photoaccess plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/panorama)
file_exists(/var/www/html/gallery2/modules/panorama/module.inc)
getParameter _version for panorama plugin

(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 = 'panorama'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for panorama plugin
getParameter _requiredCoreApi for panorama plugin
getParameter _requiredModuleApi for panorama plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/customfield)
file_exists(/var/www/html/gallery2/modules/customfield/module.inc)
getParameter _version for customfield plugin

(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 = 'customfield'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for customfield plugin
getParameter _requiredCoreApi for customfield plugin
getParameter _requiredModuleApi for customfield plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/imageblock)
file_exists(/var/www/html/gallery2/modules/imageblock/module.inc)
getParameter _version for imageblock plugin

(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 = 'imageblock'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for imageblock plugin
getParameter _requiredCoreApi for imageblock plugin
getParameter _requiredModuleApi for imageblock plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/hidden)
file_exists(/var/www/html/gallery2/modules/hidden/module.inc)
getParameter _version for hidden plugin

(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 = 'hidden'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for hidden plugin
getParameter _requiredCoreApi for hidden plugin
getParameter _requiredModuleApi for hidden plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/sizelimit)
file_exists(/var/www/html/gallery2/modules/sizelimit/module.inc)
getParameter _version for sizelimit plugin

(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 = 'sizelimit'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for sizelimit plugin
getParameter _requiredCoreApi for sizelimit plugin
getParameter _requiredModuleApi for sizelimit plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/core)
file_exists(/var/www/html/gallery2/modules/core/module.inc)
getParameter _version for core plugin
getParameter _callbacks for core plugin
getParameter _requiredCoreApi for core plugin
getParameter _requiredModuleApi for core plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/captcha)
file_exists(/var/www/html/gallery2/modules/captcha/module.inc)
getParameter _version for captcha plugin

(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 = 'captcha'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for captcha plugin
getParameter _requiredCoreApi for captcha plugin
getParameter _requiredModuleApi for captcha plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/watermark)
file_exists(/var/www/html/gallery2/modules/watermark/module.inc)
getParameter _version for watermark plugin

(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 = 'watermark'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for watermark plugin
getParameter _requiredCoreApi for watermark plugin
getParameter _requiredModuleApi for watermark plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/squarethumb)
file_exists(/var/www/html/gallery2/modules/squarethumb/module.inc)
getParameter _version for squarethumb plugin

(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 = 'squarethumb'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for squarethumb plugin
getParameter _requiredCoreApi for squarethumb plugin
getParameter _requiredModuleApi for squarethumb plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/ffmpeg)
file_exists(/var/www/html/gallery2/modules/ffmpeg/module.inc)
getParameter _version for ffmpeg plugin

(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 = 'ffmpeg'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for ffmpeg plugin
getParameter _requiredCoreApi for ffmpeg plugin
getParameter _requiredModuleApi for ffmpeg plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/rating)
file_exists(/var/www/html/gallery2/modules/rating/module.inc)
getParameter _version for rating plugin

(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 = 'rating'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for rating plugin
getParameter _requiredCoreApi for rating plugin
getParameter _requiredModuleApi for rating plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/archiveupload)
file_exists(/var/www/html/gallery2/modules/archiveupload/module.inc)
getParameter _version for archiveupload plugin

(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 = 'archiveupload'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for archiveupload plugin
getParameter _requiredCoreApi for archiveupload plugin
getParameter _requiredModuleApi for archiveupload plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/colorpack)
file_exists(/var/www/html/gallery2/modules/colorpack/module.inc)
getParameter _version for colorpack plugin

(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 = 'colorpack'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for colorpack plugin
getParameter _requiredCoreApi for colorpack plugin
getParameter _requiredModuleApi for colorpack plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/quotas)
file_exists(/var/www/html/gallery2/modules/quotas/module.inc)
getParameter _version for quotas plugin

(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 = 'quotas'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for quotas plugin
getParameter _requiredCoreApi for quotas plugin
getParameter _requiredModuleApi for quotas plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/newitems)
file_exists(/var/www/html/gallery2/modules/newitems/module.inc)
getParameter _version for newitems plugin

(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 = 'newitems'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for newitems plugin
getParameter _requiredCoreApi for newitems plugin
getParameter _requiredModuleApi for newitems plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/cart)
file_exists(/var/www/html/gallery2/modules/cart/module.inc)
getParameter _version for cart plugin

(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 = 'cart'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for cart plugin
getParameter _requiredCoreApi for cart plugin
getParameter _requiredModuleApi for cart plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/slideshowapplet)
file_exists(/var/www/html/gallery2/modules/slideshowapplet/module.inc)
getParameter _version for slideshowapplet plugin

(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 = 'slideshowapplet'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for slideshowapplet plugin
getParameter _requiredCoreApi for slideshowapplet plugin
getParameter _requiredModuleApi for slideshowapplet plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/members)
file_exists(/var/www/html/gallery2/modules/members/module.inc)
getParameter _version for members plugin

(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 = 'members'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for members plugin
getParameter _requiredCoreApi for members plugin
getParameter _requiredModuleApi for members plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/slideshow)
file_exists(/var/www/html/gallery2/modules/slideshow/module.inc)
getParameter _version for slideshow plugin

(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 = 'slideshow'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for slideshow plugin
getParameter _requiredCoreApi for slideshow plugin
getParameter _requiredModuleApi for slideshow plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/CVS)
file_exists(/var/www/html/gallery2/modules/CVS/module.inc)
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/netpbm)
file_exists(/var/www/html/gallery2/modules/netpbm/module.inc)
getParameter _version for netpbm plugin

(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 = 'netpbm'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for netpbm plugin
getParameter _requiredCoreApi for netpbm plugin
getParameter _requiredModuleApi for netpbm plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/zipcart)
file_exists(/var/www/html/gallery2/modules/zipcart/module.inc)
getParameter _version for zipcart plugin

(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 = 'zipcart'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for zipcart plugin
getParameter _requiredCoreApi for zipcart plugin
getParameter _requiredModuleApi for zipcart plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/dcraw)
file_exists(/var/www/html/gallery2/modules/dcraw/module.inc)
getParameter _version for dcraw plugin

(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 = 'dcraw'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for dcraw plugin
getParameter _requiredCoreApi for dcraw plugin
getParameter _requiredModuleApi for dcraw plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/register)
file_exists(/var/www/html/gallery2/modules/register/module.inc)
getParameter _version for register plugin

(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 = 'register'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for register plugin
getParameter _requiredCoreApi for register plugin
getParameter _requiredModuleApi for register plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/uploadapplet)
file_exists(/var/www/html/gallery2/modules/uploadapplet/module.inc)
getParameter _version for uploadapplet plugin

(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 = 'uploadapplet'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for uploadapplet plugin
getParameter _requiredCoreApi for uploadapplet plugin
getParameter _requiredModuleApi for uploadapplet plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/gd)
file_exists(/var/www/html/gallery2/modules/gd/module.inc)
getParameter _version for gd plugin

(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 = 'gd'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for gd plugin
getParameter _requiredCoreApi for gd plugin
getParameter _requiredModuleApi for gd plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/multilang)
file_exists(/var/www/html/gallery2/modules/multilang/module.inc)
getParameter _version for multilang plugin

(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 = 'multilang'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for multilang plugin
getParameter _requiredCoreApi for multilang plugin
getParameter _requiredModuleApi for multilang plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/remote)
file_exists(/var/www/html/gallery2/modules/remote/module.inc)
getParameter _version for remote plugin

(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 = 'remote'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for remote plugin
getParameter _requiredCoreApi for remote plugin
getParameter _requiredModuleApi for remote plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/sitemap)
file_exists(/var/www/html/gallery2/modules/sitemap/module.inc)
getParameter _version for sitemap plugin

(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 = 'sitemap'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for sitemap plugin
getParameter _requiredCoreApi for sitemap plugin
getParameter _requiredModuleApi for sitemap plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/imagemagick)
file_exists(/var/www/html/gallery2/modules/imagemagick/module.inc)
getParameter _version for imagemagick plugin

(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 = 'imagemagick'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for imagemagick plugin
getParameter _requiredCoreApi for imagemagick plugin
getParameter _requiredModuleApi for imagemagick plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/nokiaupload)
file_exists(/var/www/html/gallery2/modules/nokiaupload/module.inc)
getParameter _version for nokiaupload plugin

(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 = 'nokiaupload'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for nokiaupload plugin
getParameter _requiredCoreApi for nokiaupload plugin
getParameter _requiredModuleApi for nokiaupload plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/comment)
file_exists(/var/www/html/gallery2/modules/comment/module.inc)
getParameter _version for comment plugin

(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 = 'comment'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for comment plugin
getParameter _requiredCoreApi for comment plugin
getParameter _requiredModuleApi for comment plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/shutterfly)
file_exists(/var/www/html/gallery2/modules/shutterfly/module.inc)
getParameter _version for shutterfly plugin

(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 = 'shutterfly'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for shutterfly plugin
getParameter _requiredCoreApi for shutterfly plugin
getParameter _requiredModuleApi for shutterfly plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/search)
file_exists(/var/www/html/gallery2/modules/search/module.inc)
getParameter _version for search plugin

(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 = 'search'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for search plugin
getParameter _requiredCoreApi for search plugin
getParameter _requiredModuleApi for search plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/useralbum)
file_exists(/var/www/html/gallery2/modules/useralbum/module.inc)
getParameter _version for useralbum plugin

(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 = 'useralbum'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for useralbum plugin
getParameter _requiredCoreApi for useralbum plugin
getParameter _requiredModuleApi for useralbum plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/mime)
file_exists(/var/www/html/gallery2/modules/mime/module.inc)
getParameter _version for mime plugin

(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 = 'mime'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for mime plugin
getParameter _requiredCoreApi for mime plugin
getParameter _requiredModuleApi for mime plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/rearrange)
file_exists(/var/www/html/gallery2/modules/rearrange/module.inc)
getParameter _version for rearrange plugin

(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 = 'rearrange'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for rearrange plugin
getParameter _requiredCoreApi for rearrange plugin
getParameter _requiredModuleApi for rearrange plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/fotokasten)
file_exists(/var/www/html/gallery2/modules/fotokasten/module.inc)
getParameter _version for fotokasten plugin

(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 = 'fotokasten'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for fotokasten plugin
getParameter _requiredCoreApi for fotokasten plugin
getParameter _requiredModuleApi for fotokasten plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/migrate)
file_exists(/var/www/html/gallery2/modules/migrate/module.inc)
getParameter _version for migrate plugin

(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 = 'migrate'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for migrate plugin
getParameter _requiredCoreApi for migrate plugin
getParameter _requiredModuleApi for migrate plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/publishxp)
file_exists(/var/www/html/gallery2/modules/publishxp/module.inc)
getParameter _version for publishxp plugin

(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 = 'publishxp'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for publishxp plugin
getParameter _requiredCoreApi for publishxp plugin
getParameter _requiredModuleApi for publishxp plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/permalinks)
file_exists(/var/www/html/gallery2/modules/permalinks/module.inc)
getParameter _version for permalinks plugin

(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 = 'permalinks'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for permalinks plugin
getParameter _requiredCoreApi for permalinks plugin
getParameter _requiredModuleApi for permalinks plugin
readdir(Resource id #41)
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/imageframe)
file_exists(/var/www/html/gallery2/modules/imageframe/module.inc)
getParameter _version for imageframe plugin

(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 = 'imageframe'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for imageframe plugin
getParameter _requiredCoreApi for imageframe plugin
getParameter _requiredModuleApi for imageframe plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/thumbpage)
file_exists(/var/www/html/gallery2/modules/thumbpage/module.inc)
getParameter _version for thumbpage plugin

(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 = 'thumbpage'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for thumbpage plugin
getParameter _requiredCoreApi for thumbpage plugin
getParameter _requiredModuleApi for thumbpage plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/albumselect)
file_exists(/var/www/html/gallery2/modules/albumselect/module.inc)
getParameter _version for albumselect plugin

(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 = 'albumselect'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for albumselect plugin
getParameter _requiredCoreApi for albumselect plugin
getParameter _requiredModuleApi for albumselect plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/debug)
file_exists(/var/www/html/gallery2/modules/debug/module.inc)
getParameter _version for debug plugin

(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 = 'debug'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for debug plugin
getParameter _requiredCoreApi for debug plugin
getParameter _requiredModuleApi for debug plugin
readdir(Resource id #41)
is_dir(/var/www/html/gallery2/modules/rewrite)
file_exists(/var/www/html/gallery2/modules/rewrite/module.inc)
getParameter _version for rewrite plugin

(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 = 'rewrite'
AND
g2_PluginParameterMap.g_itemId = 0

getParameter _callbacks for rewrite plugin
getParameter _requiredCoreApi for rewrite plugin
getParameter _requiredModuleApi for rewrite plugin
readdir(Resource id #41)
closedir(Resource id #41)

(mysql): SELECT g2_User.g_userName, g2_User.g_fullName,
g2_User.g_hashedPassword, g2_User.g_email, g2_User.g_language,
g2_Entity.g_id, g2_Entity.g_creationTimestamp, g2_Entity.g_isLinkable,
g2_Entity.g_linkId, g2_Entity.g_modificationTimestamp,
g2_Entity.g_serialNumber, g2_Entity.g_entityType,
g2_Entity.g_onLoadHandlers FROM g2_User, g2_Entity WHERE g2_User.g_id IN
(5) AND g2_Entity.g_id=g2_User.g_id

GalleryModule::installOrUpgrade core module
In bootstrap mode (core module)
Configure store for core module
file_exists(/var/www/html/gallery2/modules/core/classes/helpers/../../../../modules/core/classes/GalleryStorage/schema.tpl)
file(/var/www/html/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.10
file_exists(/var/www/html/gallery2/modules/core/classes/helpers/../../../../modules/core/classes/GalleryStorage/schema.tpl)
file(/var/www/html/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_AccessMap
DROP KEY g_accessListId,
ADD COLUMN g_userOrGroupId int(11) NOT NULL DEFAULT '0'

(mysql): UPDATE g2_Schema
SET g_major=1, g_minor=1
WHERE g_name='AccessMap' AND g_major=1 AND g_minor=0;

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

(mysql): ALTER TABLE g2_User
MODIFY COLUMN g_email varchar(255)

(mysql): UPDATE g2_Schema
SET g_major=1, g_minor=1
WHERE g_name='User' AND g_major=1 AND g_minor=0;

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

(mysql):
UPDATE
g2_AccessMap
SET
g_userOrGroupId = g_userId + g_groupId

file_exists(/var/www/html/gallery2/modules/core/classes/helpers/../../../../modules/core/classes/GalleryStorage/schema.tpl)
file(/var/www/html/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 error: [1068: Multiple primary key defined] in EXECUTE("ALTER TABLE
g2_AccessMap
DROP COLUMN g_userId,
DROP COLUMN g_groupId,
ADD PRIMARY KEY(g_accessListId, g_userOrGroupId),
ADD INDEX g2_AccessMap_48775(g_userOrGroupId)")

(mysql): ALTER TABLE g2_AccessMap
DROP COLUMN g_userId,
DROP COLUMN g_groupId,
ADD PRIMARY KEY(g_accessListId, g_userOrGroupId),
ADD INDEX g2_AccessMap_48775(g_userOrGroupId)

1068: Multiple primary key defined

adodb_mysql._execute(ALTER TABLE
g2_AccessMap
DROP COLUMN g_userId,
DROP COLUMN g_groupId,
ADD PRIMARY KEY(g_accessListId, g_userOrGroupId),
..., false) % line 855, file: adodb.inc.php
adodb_mysql.execute(ALTER TABLE g2_AccessMap
DROP COLUMN g_userId,
DROP COLUMN g_groupId,
ADD PRIMARY KEY(g_accessListId, g_userOrGroupId),
...) % line 1445, file: GalleryStorageExtras.class
gallerystorageextras._executesql(ALTER TABLE
DB_TABLE_PREFIXAccessMap
DROP COLUMN DB_COLUMN_PREFIXuserId,
DROP COLUMN DB_COLUMN_PREFIXgroupId,
ADD PRIMARY ...) % line 1225, file:
GalleryStorageExtras.class
gallerystorageextras.configurestore(core,
Array[1]) % line 559, file: GalleryStorage.class
mysqlstorage.configurestore(core, Array[1]) % line 1300, file: CoreModuleExtras.inc

realpath(/var/www/html/gallery2/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: ALTER TABLE
g2_AccessMap
DROP COLUMN g_userId,
DROP COLUMN g_groupId,
ADD PRIMARY KEY(g_accessListId, g_userOrGroupId),
ADD INDEX g2_AccessMap_48775(g_userOrGroupId)in
modules/core/classes/GalleryStorage/GalleryStorageExtras.class at
line 1449 (gallerycoreapi::error)
in modules/core/classes/GalleryStorage/GalleryStorageExtras.class
at line 1225 (gallerystorageextras::_executesql)
in modules/core/classes/GalleryStorage.class at line 559
(gallerystorageextras::configurestore)
in modules/core/CoreModuleExtras.inc at line 1300
(mysqlstorage::configurestore)
in modules/core/module.inc at line 492
(coremoduleextras::upgrade)
in modules/core/classes/GalleryModule.class at line 157
(coremodule::upgrade)
in upgrade/steps/UpgradeCoreModuleStep.class at line 81
(coremodule::installorupgrade)
in upgrade/index.php at line 185
(upgradecoremodulestep::processrequest)

realpath(/var/www/html/gallery2/modules/core/classes/../../../)