General Error wrote:SQL ERROR [ mysql4 ]
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 '.username, u.user_colour, u.user_id FROM (table_prefix_blog bb CROSS JOIN table_prefix_blog_co' at line 2 [1064]
SQL
SELECT b.*, COUNT(bb.blog_id) as blog_count, COUNT(c.cmnt_id) as cmnts_approved, COUNT(cc.cmnt_id) as cmnts_unapproved, ct.cat_title, ct.cat_id u.username, u.user_colour, u.user_id FROM (table_prefix_ bb CROSS JOIN table_prefix_blog_comments cc CROSS JOIN table_prefix_blog_categories ct CROSS JOIN table_prefix_users u) WHERE ct.cat_id = b.blog_cat_id AND c.cmnt_approved = 1 AND cc.cmnt_approved = 0 AND b.blog_poster_id = u.user_id ORDER BY b.blog_id DESC LIMIT 10
BACKTRACE
FILE: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()
FILE: [ROOT]/includes/db/mysql.php
LINE: 222
CALL: dbal_mysql->sql_query()
FILE: [ROOT]/includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()
FILE: [ROOT]/blog.php
LINE: 107
CALL: dbal->sql_query_limit()
i installed with automod !Parse error: syntax error, unexpected T_VARIABLE in /home/xxxx/public_html/ghs/blog.php on line 107