Quote
Date: Fri, 18 Nov 2011 20:25:36 +0000 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 ') ORDER BY RAND() desc LIMIT 0,24' at line 2
mySQL query error: SELECT i.*,a.*,m.members_display_name, m.members_seo_name, m.member_id FROM gallery_images i LEFT JOIN gallery_albums_main a ON ( a.album_id=i.img_album_id ) LEFT JOIN members m ON ( m.member_id=i.member_id ) WHERE ( ( i.image_privacy IN (2,1,0,3) AND i.member_id=1 ) OR ( i.image_privacy IN (1,3) AND ( ( ( FIND_IN_SET(4,i.image_parent_permission) ) OR ( i.image_parent_permission='*' ) )) ) OR ( i.image_privacy IN (1,2) AND i.member_id IN(2,7,9,11,50,120,234,1097) ) ) AND i.approved IN(0,1) AND i.img_album_id IN() ORDER BY RAND() desc LIMIT 0,24
mySQL query error: SELECT i.*,a.*,m.members_display_name, m.members_seo_name, m.member_id FROM gallery_images i LEFT JOIN gallery_albums_main a ON ( a.album_id=i.img_album_id ) LEFT JOIN members m ON ( m.member_id=i.member_id ) WHERE ( ( i.image_privacy IN (2,1,0,3) AND i.member_id=1 ) OR ( i.image_privacy IN (1,3) AND ( ( ( FIND_IN_SET(4,i.image_parent_permission) ) OR ( i.image_parent_permission='*' ) )) ) OR ( i.image_privacy IN (1,2) AND i.member_id IN(2,7,9,11,50,120,234,1097) ) ) AND i.approved IN(0,1) AND i.img_album_id IN() ORDER BY RAND() desc LIMIT 0,24
Edited by pityfool, 18 November 2011 - 08:43 PM.















