Phoca Forum

Hello !

I have the same problem listed here : viewtopic.php?f=1&t=2936&start=0&st=0&s ... ver#p14816

I the front end it is ok but in the back end it's impossible to go in the "images" menu...

Sometimes there is a simple "server error",

sometimes there is a "Error Loading ModulesMySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 2 AND m.client_id = 1 ORDER BY position, ordering",

sometimes there is a "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /homez.xxx/xxx/www/libraries/joomla/database/database/mysql.php on line 342

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /homez.xxx/xxx/www/libraries/joomla/database/database/mysql.php on line 342

Warning: Invalid argument supplied for foreach() in /homez.xxx/xxx/www/administrator/components/com_phocagallery/helpers/phocagallery.php on line 1245"

All this kind of errors after a very long loading time...

Somebody have an idea ?

Phoca version : 2.1.0 RC

A little up

I really cannot acces the images in the back end...

Hi, see:

https://www.phoca.cz/documents/2-phoca-g ... em-solving

Point 1

Jan

Ok thanks for your reply, i well check that.. but it was not a new install or upgrade, Phoca worked perfectly since the first install (some month ago) and crash a day without any reasons...

PS : sorry for my bad english

Jan wrote:Hi, see:
https://www.phoca.cz/documents/2-phoca-g ... em-solving
Point 1

Jan

Hello

I cheked the database and all seems ok.

I can view the images only in local (after a long time), but online it's impossible..

I have about 5000 pictures in the gallery, and I noticed the time of load is proportional among images. After a certain number of images, the server crash.

The error which I had today is "Server has gone away"

Did you enable the pagination thumbnail creation parameters, see:
https://www.phoca.cz/documents/2-phoca-g ... n_Settings

Jan

Ok, with this setting I can now acces the images in the back end, but the thumbs are not automatically created..

I don"t understand this setting, I thought it was only for the upload ?

Hi,

the pagination thumbnails creation prevents that all thumbs are created in only one turn (which is a high server load). Now thumbnails are created when you go to the page the thumbnails are displayed.

So if you have 100 new images added, and you display only 20 images per page, only for 20 images thumbnails are created at one time. To create the other, you need to go to that page in the backend.

I hope I explained it good enough,

Regards, Carolien

Thanks for your reply !
it was exactly what I thought..

This setting has resolved my problem, but it was not a thumbnail creation problem..
The creation of the thumbs works great, it is only the back end access of the images wich crash..

With Pagination off, when I clik on the "images" menu in the back end, impossible to display anything (the thumbs was already created during the upload, so there is normally no high server load at this time ?)

well... your server has to load all those images (it displays the small thumbs in the images tab)...So if you have set to display 50 or 100 (or all) in one page, then I can imagine that your server has got some problems loading them.

Regards, Carolien