Page 1 of 1

BIG PROBLEM ON SQL PHOCA GALLERY V3.1.x

Posted: 10 Nov 2011, 22:04
by jeannoel
Hi,

I have this problem

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-11-10 19:41:17') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2011-11-10 19:41:17') AND m.access IN (1,1,2,3,4,13,12,11,15) AND m.client_id = 1 AND (mm.menuid = 0 OR mm.menuid <= 0) ORDER BY position, ordering

I try the new version 3.1.1 on joomla 1.6 but i have an error jhtml ?

Is the seveur, the programme or ....

I have many many pictures.

Some people are idea..

I can see on front end but can't manage,add picture on back end

Regards

jn

Re: BIG PROBLEM ON SQL PHOCA GALLERY V3.1.1

Posted: 11 Nov 2011, 08:33
by jeannoel
hi,

I migrat my site on Joomla 1.7.2 and Phoca gallery 3.1.1 but the same.

You don't some tools for reginize the database ?

I have this information to.

MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text FROM jos_viewlevels AS a GROUP BY a.id ORDER BY a.ordering ASC

I have only 8160 records/images in Gallery and 330 categories and the sql works good in php admin
Regards.

JN

PS: Is not possible to begin with some criteria like catégories ?

Re: BIG PROBLEM ON SQL PHOCA GALLERY V3.1.x

Posted: 16 Nov 2011, 01:39
by Jan
Hi, this error is mostly displayed in case, there is no memory for the database. While using Phoca Gallery, you are using whole Joomla! framework too, so you need to look at your memory settings.

Try to set Phoca Gallery to recommended settings too:
https://www.phoca.cz/documents/2-phoca-g ... -menu-item

Jan

Re: BIG PROBLEM ON SQL PHOCA GALLERY V3.1.x

Posted: 17 Nov 2011, 16:20
by jeannoel
Hello,

I sorry but i don't anderstand. My problem is in back end, to manage the Gallery. In front end all are OK.

You can here www(.)albatros-productions(.)com

I don't see where in the parrameters i can change for the good way.

Only Manage Image and Add multiple Image crash.

Regards.

Tell me some idea ?

Re: BIG PROBLEM ON SQL PHOCA GALLERY V3.1.x

Posted: 18 Nov 2011, 00:25
by Jan
Hi, while using your Joomla! in administration - you get memory problems, see recommended settings to reduce memory requirements

Jan

Re: BIG PROBLEM ON SQL PHOCA GALLERY V3.1.x

Posted: 18 Nov 2011, 14:30
by jeannoel
Hi,

THX for your help, is works now.

Regards

jn

Re: BIG PROBLEM ON SQL PHOCA GALLERY V3.1.x

Posted: 23 Nov 2011, 16:04
by Jan
Ok