Phoca Forum

Hi, thanks for good component. Sorry if topic dublicate (and for bad english:)).
I can't see no one categories.

I switch on debug mode and recieved answer

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 turiasdb_phocagall 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 turiasdb_phocagallery_categories AS a LEFT JOIN turiasdb_users AS u ON u.id = a.checked_out LEFT JOIN turiasdb_groups AS g ON g.id = a.access LEFT JOIN turiasdb_phocagallery_categories AS cc ON cc.id = a.parent_id LEFT JOIN turiasdb_phocagallery_votes_statistics AS v ON v.catid = a.id LEFT JOIN turiasdb_users AS ua ON ua.id = a.owner_id JOIN (SELECT c.parent_id, count(*) AS countid FROM turiasdb_phocagallery_categories AS c GROUP BY c.parent_id ) AS c ON a.p are arent_id = c.parent_id ORDER BY a.ordering

So, there two sql queries. As i understand that is problem with sql. I can't access to the hoster. May i something to decide this problem?

Hi, try to enable php error reporting and debug mode, maybe you will get some more info there.
https://www.phoca.cz/documents/16-joomla ... ent-errors
Jan

my sql can't understand subquery. And table category can't create.
A found this problem was already discussed in forum, but how fix that?

I can create patch to use temporary table, but I didn't find where these inquiries are created

Hi, really no experiences with sql which do not understand subqueries, so cannot give any clue advice there - maybe you need to somehow customize the sql queries and do the combination of their outcomes with php, etc.

Jan