Error 500 - no matter what I do

[Haraldio]

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 ...

[Jan]

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

[Haraldio]

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 ...

[Jan]

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

[Haraldio]

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

[Haraldio]

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

[Jan]

Hmmm, then maybe some limit settings there

[Haraldio]

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.