Phoca Forum

Hi everyone

I've always used phocagallery with success (it's a great joomla component!!), but since my photo gallery increased (about 3000-4000 pics) i get the following error each time i try to access "Images Menu" at phoca gallery administration panel:

MySQL server has gone away SQL=SELECT a.lang_code AS value, a.title AS text, a.title_native FROM jos_languages AS a WHERE a.published >= 0 ORDER BY a.title
Error loading module MySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2011-05-27 02:46:21') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2011-05-27 02:46:21') AND m.access IN (1,1,2,3) AND m.client_id = 1 AND (mm.menuid = 0 OR mm.menuid <= 0) ORDER BY position, ordering


I'm using Joomla 1.6.1 and phoca gallery component 3.0.0 RC4

This error doesn't allow me to enter the images menu and upload any image anymore

Please, help me!

Hi, not sure where this sql query is comming from, but seems like your mysql does not have enough memory to run it

As Phoca Galler uses pagination (it means, e.g. only 20 to e.g. 100 items are loaded from database) there should not be problem with memory for the database

Jan

Jan, thank you for your time...

This SQL Query lists all the images in the menu IMAGES of phoca gallery control panel.

Each time i try to access it, the error occurs...

Does it mean that i have to increase SQL memory?!?! How do i do that??

Thanks again!

Solved

Just went to Options at phoca gallery control panel, Main separator, and enable Pagination Thumbnail Generation

Ok