|
|
Blog Ranking Order 9
|
Resolved
|
|
Affects: ProJam2 + All Mods (ProPack)
|
|
Priority: Normal
|
|
Created: 03/30/13 13:52
|
|
Resolved: 07/28/13 14:08
|
|
Created By: Douglas
|
|
Details
|
Using order 9 in blog ranking mode results in an error.
[ranking.php] dbQuery() db error 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 'GROUP BY m.message_category ORDER BY m.message_category ASC LIMIT 0,25' at line 17 : SELECT m.*, m.message_rating_1 AS blog_rating_1, m.message_rating_2 AS blog_rating_2, m.message_rating_3 AS blog_rating_3, m.message_rating_4 AS blog_rating_4, m.message_rating_5 AS blog_rating_5, m.message_rating_number AS blog_rating_number, m.message_rating_average AS blog_rating_average, i.*, q.*, u.* FROM jamroom_messages m LEFT JOIN jamroom_band_info i ON i.band_id = m.band_id LEFT JOIN jamroom_quota q ON q.quota_id = i.band_quota LEFT JOIN jamroom_user u ON u.user_id = m.message_author WHERE m.message_show != 'no' AND ((q.quota_message != 'no' AND i.band_active = '1') OR m.message_author = '0') AND (i.band_private != 'yes' OR i.band_private IS NULL OR i.band_id = '1' OR '0' = '0') GROUP BY m.message_id GROUP BY m.message_category ORDER BY m.message_category ASC LIMIT 0,25 |
|
Resolution
|
| This has been fixed in Jamroom 4.3.1 |
|
|
