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) 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.
|
||||||
Posts: 8339
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
Posts: 6
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)?
Posts: 8339
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
Posts: 6
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?
Posts: 8339
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
Posts: 1
'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 @@
Posts: 8339
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