Gallery2 ERROR_STORAGE_FAILURE fix
Posted in: Programming, Web
I do not know why, but I’m getting this error from time to time in my gallery… It seems to behave like a measure of entropy
To fix it when “entropy broke loose” the first time, I did some searching and found the solution in different topics of the official gallery2 forum. The text below was prepared based on forum searches and the official gallery2 FAQ.
If you get ERROR_STORAGE_FAILURE from your Gallery2 installation, when adding new photos or creating albums, then most probably there is a problem in a mysql database with the g2_SequenceId table.
To fix this, find the g2_SequenceId table (using any method you like - mysql command-line interface, phpMyAdmin, SQLyog etc) and list table rows.
- If there are multiple rows - delete all the rows except the one with the largest value.
- If there is a single row:
- run the query: select max(g_id) from g2_Entity;
- edit the one row you have in g2_SequenceId - change the value to be one larger than the maximum id reported in the query above.
Note that the errors received previously may have left directories and files inside your g2data/albums directory that are not displayed by Gallery. To complete the cleanup from this problem the items not shown when browsing the gallery as a site admin should be removed (backup recommended before proceeding).
Return to: Gallery2 ERROR_STORAGE_FAILURE fix
Social Web