Phoca Forum

Hi!

First of all, Phoca Gallery is a very nice component of Joomla.
My problem is: I have a site, with huge amount of images. In the images folder there is 7000+ user's folders, I set it each a category.
When I want to list it in the Categories view, i get a "Fatal error: Maximum execution time..." problem. I understand it, it is too much.
There is any posssibility to list categories with a more simple sql query? (Now the listing of 10 items = 18 second in MySql!!)

It's very important i have a tight deadlines...

Thanks

Hi, see similar posts in this forum, there is no problem with images as they use pagination - so e.g. 20 images per site are loaded or 100 hundred.

The problem can be with categories, e.g. if there is over 700 categories, etc. - All Categories need to be loaded at once as the tree of the category needs to be done. So it depends how many items in categories will be loaded.

Only for test, try to run Phoca Photo (if you are using Phoca Gallery 4.x and Joomla! 3) if you get the same problem for categories view:
https://www.phoca.cz/phocaphoto
https://www.phoca.cz/joomla3demo/phoca-photo

It is lightweight version of Phoca Gallery frontend output and does not inlcude features which can take some resources (like checking rights, etc. etc.).

There is no need to add the images newly, as Phoca Photo uses Phoca Gallery administration. Just install Phoca Photo and create a menu link to Phoca Photo categories view and test if you get the same problem

Jan

Hi Jan!

Thank you for your reply. I made an own query, so its works.
My new problem is: When im on the front-end User Control Panel everything is fine. User can make main category, can upload images to main cat.
BUT. When the user try to create a new subcategory, the subcategory appears in the database, but doesnt in the server folder system. I try to change the folders permission, i try to create subcats as user and as Super User, but nothing. You see it in the subcategory list, but its not exist phisicaly in the folder system.
Can you tell me which file makes the subcategories in the component? Or do you have any idea what is the problem? (I made changes inside the component's files)

Thank you, Dracon

This is the User Control Panel:
https://drive.google.com/open?id=0B8z3V ... authuser=0

Hi, see similar posts in this forum regarding independent database and filesystem layer used in Phoca Gallery - there are no folders for subcategories in Phoca Gallery - every image is stored in main category. So when user creates main category in frontend, only one category for the user is created and there all the images are stored (even they are in subcategory)

Jan