Group and sorting not working

[gabrielef71]

Hi all,
here are a couple of questions. My PhpScheduleIT version is 1.2.12.

1) When I try to working with groups I get this message so I'm not able to create/manage groups at all.

DB Error: syntax error SELECT g.groupid, g.group_name, u.fname, u.lname, cnt.user_count FROM groups g LEFT JOIN user_groups ug ON g.groupid = ug.groupid AND ug.is_admin = 1 LEFT JOIN login u ON ug.memberid = u.memberid LEFT JOIN ( SELECT ug.groupid, COUNT(ug.memberid) as user_count FROM user_groups ug GROUP BY ug.groupid ) cnt ON cnt.groupid = g.groupid ORDER BY group_name LIMIT 0, 25 [nativecode=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 ug.groupid, COUNT(ug.memberid) as user_count FROM user_g]

My Mysql version is 4.0.30. Php version: 5.2.13.

2) When I try to sort my booking by date (Start Date or End Date), the sorting process it doesn't work.

Any idea? Thanks.
Best, Gabriele

[Nick]

I *think* this is a limitation of older versions of MySQL.  A thread with the fix is here: http://php.brickhost.com/forums/index.php?topic=2153.0

[gabrielef71]

Thanks, it's working with the fix.