The pictures in one of the albums on my Gallery 3.0.9 installation are not visible, Gallery shows this error: "The album '<album name>' is not writable".
I tried to run Fix your Gallery but I get the following out of memory error:
Task Fix your Gallery started (task id 39)
exception 'Database_Exception' with message '#5: Out of memory (Needed 260656 bytes) [ SELECT DISTINCT CONCAT(`parent_id`, ':', LOWER(`slug`)) AS `parent_slug`, `id`, COUNT(*) AS `C`
FROM `items`
GROUP BY `parent_slug`
HAVING `C` > 1 ]' in /htdocs/album.sixappealwheel.org/gallery/system/libraries/Database_Mysql_Result.php:27
Stack trace:
#0 /htdocs/album.domain.name/gallery/system/libraries/Database_Mysql.php(124): Database_Mysql_Result_Core->__construct(false, 'SELECT DISTINCT...', Resource id #38, true)
#1 /htdocs/album.domain.name/gallery/system/libraries/Database.php(272): Database_Mysql_Core->query_execute('SELECT DISTINCT...')
#2 /htdocs/album.domain.name/gallery/modules/gallery/libraries/MY_Database.php(48): Database_Core->query('SELECT DISTINCT...')
#3 /htdocs/album.domain.name/gallery/system/libraries/Database_Builder.php(973): Database->query('SELECT DISTINCT...')
#4 /htdocs/album.domain.name/gallery/modules/gallery/helpers/gallery_task.php(773): Database_Builder_Core->execute()
#5 /htdocs/album.domain.name/gallery/modules/gallery/helpers/gallery_task.php(362): gallery_task_Core::find_dupe_slugs()
#6 [internal function]: gallery_task_Core::fix(Object(Task_Model))
#7 /htdocs/album.domain.name/gallery/modules/gallery/helpers/task.php(90): call_user_func_array('gallery_task::f...', Array)
#8 /htdocs/album.domain.name/gallery/modules/gallery/controllers/admin_maintenance.php(195): task_Core::run('39')
#9 [internal function]: Admin_Maintenance_Controller->run('39')
#10 /htdocs/album.domain.name/gallery/modules/gallery/controllers/admin.php(62): call_user_func_array(Array, Array)
#11 [internal function]: Admin_Controller->__call('maintenance', Array)
#12 /htdocs/album.domain.name/gallery/system/core/Kohana.php(331): ReflectionMethod->invokeArgs(Object(Admin_Controller), Array)
#13 [internal function]: Kohana_Core::instance(NULL)
#14 /htdocs/album.domain.name/gallery/system/core/Event.php(208): call_user_func_array(Array, Array)
#15 /htdocs/album.domain.name/gallery/application/Bootstrap.php(67): Event_Core::run('system.execute')
#16 /htdocs/album.domain.name/gallery/index.php(116): require('/htdocs/album.s...')
#17 {main}
Any idea what could be causing this?
Daniel
Posted: Sun, 2013-09-22 17:33
Posts: 8339
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 10
You were quite right! It was indeed out of memory, shouldn't have interpreted this as a possible bug.
I increased the server memory a bit from 512 MB to 768 MB and all is well now.
Thank you for your help!
Daniel