SELECT COUNT(*) AS count FROM users_buddies WHERE users_buddies.user_id =
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 '' at line 1
SELECT DISTINCT journals.id, title, entry, journals.created, journals.view_policy, COUNT(comments.id) AS c FROM journals LEFT OUTER JOIN comments ON journals.comment_id = comments.instance_id AND comments.deleted = 0 LEFT OUTER JOIN users_buddies ON journals.user_id = users_buddies.user_id LEFT OUTER JOIN journal_security ON journal_security.journal_id = journals.id LEFT OUTER JOIN users_groups ON journal_security.capability_id = users_groups.group_id WHERE journals.user_id = AND ((users_buddies.buddy_id = 0 AND users_buddies.id <> '') AND journals.view_policy = 1 OR journals.view_policy = 0 OR 0 = ) OR (users_groups.user_id = 0 AND journal_security.journal_id <> '') AND journals.user_id = AND journals.view_policy = 3 OR ((users_groups.user_id = 0 AND journal_security.journal_id <> '') AND journals.user_id = AND journals.view_policy = 2 OR (users_buddies.buddy_id = 0 AND users_buddies.id <> '') AND journals.user_id = AND journals.view_policy = 2 )GROUP BY journals.id, title, entry, journals.created, journals.view_policy ORDER BY created DESC LIMIT 0,3
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 'AND ((users_buddies.buddy_id = 0 AND users_buddies.id <> '') AND journals.view_p' at line 1
Fatal error: Call to a member function count() on a non-object in /var/www/vhosts/synapticaudio.com/httpdocs/lib/page/user/journal.class.php on line 98