No replies to this topic

[pityfool]

Hi. Set the hook on version 3.2.3 and gallery 4.1.4, an error:

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

Edited by pityfool, 18 November 2011 - 08:43 PM.