Just upgraded one of my sites to 2.1 RC4 and keep getting this error in the log...
Database Error: You have an error in your SQL [syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '|| c.view =1)))
AND p.id_member = 53 AND p.approved = 1' at line 8
SELECT COUNT(*) AS total FROM (smf_gallery_pic as p)
LEFT JOIN smf_members AS m ON (m.id_member = p.id_member)
LEFT JOIN smf_membergroups AS mg ON (mg.ID_GROUP = IF(m.ID_GROUP = 0, m.ID_POST_GROUP, m.ID_GROUP))
LEFT JOIN smf_gallery_usersettings AS s ON (s.id_member = m.id_member)
LEFT JOIN smf_gallery_catperm AS c ON (c.ID_GROUP IN (-1) AND c.ID_CAT = p.ID_CAT)
LEFT JOIN smf_gallery_log_mark_view AS v ON (p.id_picture = v.id_picture AND v.id_member = 53 AND v.user_id_cat = p.USER_ID_CAT)
WHERE (((s.private =0 || s.private IS NULL ) AND (s.password = '' || s.password IS NULL ) AND p.USER_ID_CAT !=0 AND p.approved = 1) || (p.USER_ID_CAT =0 AND p.approved = 1 AND (c.view IS NULL || c.view =1)))
AND p.id_member = 53 AND p.approved = 1