Page 1 of 1

[Solved] Images menu get "MySQL server has gone away"

Posted: 27 May 2011, 04:54
by simaocorreia
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!

Re: Images menu get "MySQL server has gone away"

Posted: 27 May 2011, 17:51
by Jan
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 :idea:

Jan

Re: Images menu get "MySQL server has gone away"

Posted: 27 May 2011, 18:03
by simaocorreia
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!

Re: Images menu get "MySQL server has gone away"

Posted: 28 May 2011, 15:27
by simaocorreia
Solved :D

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

Re: [Solved] Images menu get "MySQL server has gone away"

Posted: 01 Jun 2011, 13:47
by Jan
Ok