Database error

[Oldiesmann]

Just upgraded one of my sites to 2.1 RC4 and keep getting this error in the log...

Code: [Select]

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

[SMFHacks]

Are you using the latest gallery version thought I fixed it.  Issue was using the || operator instead of OR
What was line/file number of the error.

[SMFHacks]

Found a couple spots I missed use the latest version attached to
https://www.smfhacks.com/index.php/topic,9539.msg41642.html#msg41642