Phoca Forum

I love that gallery - but unfortunately I'm not able to fully make use of it. I add a few folder (containing rather a lot of pictures, I admit) - and everything is fine. Then I add another one - and I run into error 500.

Tried using PHP5 instead of PHP4, changed admission of folder to 777, removed some pictures, installed, removed the gallery and installed it more than 10 times - same result: After a few folders I run into error 500.

I do add the folders directly into the gallery and then they're added correctly - UNTIL the error 500 appears - then nothing else seems to help.

Any ideas?
Thanks a lot for your kind help.

Edit: Additionally I can't add any category. Always get that error: Warning: Invalid argument supplied for foreach() in XXXXX/components/com_phocagallery/models/phocagallerycs.php on line 126

Edit: No hints for me? I cannot edit the categories ...

Hi, you should enable debug mode as it seems you have some problem in database. Enabling debug mode will display more info about this problem.

Jan

Thank you very much for your help.

Yes, I have already used debug mode - with the folllowing result when I coll "categories":

500 - Es ist ein Fehler aufgetreten

JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.parent_id, count(*) AS countid FROM jos_phocagallery_c SQL=SELECT a.*, cc.title AS parentname, u.name AS editor, g.name AS groupname, v.average AS ratingavg, ua.username AS usercatname, c.countid AS countid FROM jos_phocagallery_categories AS a LEFT JOIN jos_users AS u ON u.id = a.checked_out LEFT JOIN jos_groups AS g ON g.id = a.access LEFT JOIN jos_phocagallery_categories AS cc ON cc.id = a.parent_id LEFT JOIN jos_phocagallery_votes_statistics AS v ON v.catid = a.id LEFT JOIN jos_users AS ua ON ua.id = a.owner_id JOIN (SELECT c.parent_id, count(*) AS countid FROM jos_phocagallery_categories AS c GROUP BY c.parent_id ) AS c ON a.parent_id = c.parent_id ORDER BY a.ordering

Doesn't help me very much, I'm afraid ...

EDIT: I can completely deinstall PHOCA, install it again - and the very first thing I want to do is create a category - impossible. Always get the error ...

Hi, yes, this is some problem with mysql settings. I thought it is a mysql4 problem, but then I have tested it with mysql4 on my test sites and it was working. It is a known issue, some users have had the same problem, for some the upgrading of mysql helped (seems like some limit by compound query )

Jan

Thank you very much, Jan. Sad - I really like that gallery - but I can't get it working fully ...

This is really disappointing - I upgraded my Mysql-DB to 5 - and still run into the same problem. I give in.

Hmmm, then maybe some limit settings there

Thanks again, Jan. Your effort is very much appreciated. Unfortunately it took me too much time fo figure out what's wrong - so now I just leve it alone. Nevertheless: Thank you.