Categories-Error

[Jan]

Hi, try to enable debug mode to get more information from database

Jan

[Jan]

Hi, I think you need to upgrade to mysql 5

Jan

[Jan]

I have done some tests on this server:

- php 4.3.10
- mysql 4.1.9



and get no problem with this sql query.

Code: Select all

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

So it seems there needs not to be loaded mysql 5.

Jan