ERROR_STORAGE_FAILURE when upgrading from Gallery core from 2.3.1 to 2.3.2

kellsiek

Joined: 2007-12-16
Posts: 6
Posted: Mon, 2012-08-06 14:16

Trying to upgrade Gallery 2.3.1 to 2.3.2 and received the following error when it is "Converting MySQL data to UTF8"

Error (ERROR_STORAGE_FAILURE)
in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 959 (GalleryCoreApi::error)
in modules/core/classes/GalleryStorage.class at line 508 (GalleryStorageExtras::execute)
in modules/core/CoreModuleExtras.inc at line 3486 (GalleryStorage::execute)
in modules/core/CoreModuleExtras.inc at line 81 (CoreModuleExtras::convertCharacterSetToUtf8)
in modules/core/module.inc at line 486 (CoreModuleExtras::upgrade)
in modules/core/classes/GalleryModule.class at line 175 (CoreModule::upgrade)
in upgrade/steps/UpgradeCoreModuleStep.class at line 85 (GalleryModule::installOrUpgrade)
in upgrade/index.php at line 186 (UpgradeCoreModuleStep::processRequest)

I've attached two files. GalleryUpdateCoreFail.txt is the error that was displayed on the screen during the update process. upgrade_b30eb3570e.txt is the log file that was in the g2data directory.

Anyone know if my db is all screwed up or if there is anyway to fix it?

I've tried several things. I've made the g2data directory have 777 permissions. I've also tried to use a new gallery directory for the gallery files (g2data directory was unchanged) and then performed the upgrade and had the same results.

Any help would be appreciated as I'm currently thinking I'll just need to start all over with a new db and reupload all my files.


Gallery version: 2.3.1
File integrity: Ok
SVN install: No
PHP version: 5.2.17 cgi-fcgi
PHP memory limit: 90M
PHP zend.ze1_compatibility_mode: 0
Webserver: Apache
Database: mysqli 5.0.91-log
Operating system: Linux infong 2.4 #1 SMP Tue Jan 17 02:58:41 UTC 2012 i686 GNU/Linux
Browser: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1 (KHTML,like Gecko) Chrome/21.0.1180.60 Safari/537.1

AttachmentSize
GalleryUpdateCoreFail.txt26.1 KB
upgrade_b30eb3570e.txt117.76 KB
 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Mon, 2012-08-06 21:15

can you run this query in phpMyAdmin or similar DB tool
ALTER TABLE `g2_CacheMap` DEFAULT CHARACTER SET utf8
or
ALTER TABLE `g2_CacheMap` CHARACTER SET utf8

-s

 
kellsiek

Joined: 2007-12-16
Posts: 6
Posted: Mon, 2012-08-06 21:52

Thanks for your response suprsidr. The first command wouldn't run due to a syntax error (I assume this is a db version/command set thing). The second version "ALTER TABLE `g2_CacheMap` CHARACTER SET utf8" says "#1044 - Access denied for user: 'dbo222292159@%' to database 'db222292159'". I can edit other tables within the db (for example I can edit my gallery user email under g2_User). I haven't tried to edit the g2_CacheMap as I'm not sure of it's usage. Is there a way for me to change the permissions for g2_CacheMap? What would you suggest as the next step(s)?

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Mon, 2012-08-06 22:02

User dbo222292159 may not have alter rights.
Ask your host, or you may be able to change them in your server's control panel

-s
All New jQuery Minislideshow for G2/G3

 
kellsiek

Joined: 2007-12-16
Posts: 6
Posted: Mon, 2012-08-06 23:03

After backing up the entire db and also just the table (two different files), I emptied the g2_CacheMap and then ran the ALTER TABLE `g2_CacheMap` CHARACTER SET utf8 command. It looks like this command ran. However when I go back to try and upgrade gallery2, I get the exact same failure (I did a file compare on the screen dump to check). If I've already converted this table, then this table couldn't be causing problem, right?

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Tue, 2012-08-07 01:00

that is not the only table the upgrader is trying to alter.
If user dbo222292159 does not have alter permissions the same error will occur.

-s
All New jQuery Minislideshow for G2/G3

 
jhon marvi

Joined: 2012-12-03
Posts: 1
Posted: Wed, 2013-02-06 06:07

've tried several things. I've made the g2data directory have 777 permissions. I've also tried to use a new gallery directory for the gallery files (g2data directory was unchanged) and then performed the upgrade and had the same results.

Any help would be appreciated as I'm currently thinking I'll just need to start all over with a new db and reupload all my files.these error comes
=== modified file 'MANIFEST' --- debian/MANIFEST 2012-04-25 17:52:32 +0000 +++ ubuntu/MANIFEST 2008-10-19 05:01:26 +0000 @@ -1,8 +1,8 @@ -# $Revision: 20997 $ +# $Revision: 18190 $ # File crc32 crc32(crlf) size size(crlf) or R File -MANIFEST 2996750644 3839163282 72369 73919 -README.html 3422021695 1972986931 85381 87899 -bootstrap.inc 270495883 4258233691 1987 2044 +MANIFEST 2887133402 2454357613 72303 73852 +README.html 2791892076 4072720727 85092 87600 +bootstrap.inc 1292755660 3449290461 2118 2176 embed.php 1017113822 3867634306 1520 1557 images/g2Logo.gif 1196739865 1196739865 6395 6395 images/gallery.gif 2220981207 2220981207 1180 1180 @@ -12,7 +12,7 @@

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Fri, 2012-12-21 04:57
jhon marvi wrote:
=== modified file 'MANIFEST' --- debian/MANIFEST 2012-04-25 17:52:32 +0000 +++ ubuntu/MANIFEST 2008-10-19 05:01:26 +0000 @@ -1,8 +1,8 @@ -# $Revision: 20997 $ +# $Revision: 18190 $ # File crc32 crc32(crlf) size size(crlf) or R File -MANIFEST 2996750644 3839163282 72369 73919 -README.html 3422021695 1972986931 85381 87899 -bootstrap.inc 270495883 4258233691 1987 2044 +MANIFEST 2887133402 2454357613 72303 73852 +README.html 2791892076 4072720727 85092 87600 +bootstrap.inc 1292755660 3449290461 2118 2176 embed.php 1017113822 3867634306 1520 1557 images/g2Logo.gif 1196739865 1196739865 6395 6395 images/gallery.gif 2220981207 2220981207 1180 1180 @@ -12,7 +12,7 @@

this mean nothing to me.

Upload/overwrite all gallery2 codebase w/ the new version
head to yoursite.com/gallery2/upgrade
and run the upgrader

there have been very few time that a scrap/reinstall was necessary

-s
________________________________
All New jQuery Minislideshow for G2/G3