Mysql error:: 1064
Posted: Sat Sep 07, 2013 10:49 am
Во вкладке List Thumbs если выбираю показать Active at this site only выпадает такая ошибка:
Mysql 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 ') and g.status IN ( 0,1,2,10) group by g.gallery_md5 order by date desc limit ' at line 6) (db_link) in query select SQL_CALC_FOUND_ROWS g.id, gs.total_ctr as max_ctr, gs.total_shows as casts, gs.total_clicks as clicks, g.priority as gs_priority FROM rot_galleries as g JOIN rot_gallery_data as gd on gd.gallery_md5 = g.gallery_md5 JOIN rot_gallery_info as gi on gi.gallery_md5 = g.gallery_md5 JOIN rot_gal2group as g2gr on g2gr.gal_id = g.id JOIN rot_gallery_stats as gs on gs.thumb_id = g.id WHERE 1 = 1 and gs.best_thumb = "yes" and not (g.rgroup = '0' and sponsor_id = 3) and sponsor_id IN (SELECT sponsor_id FROM rot_sponsors_data WHERE status = 1 and site_id = ) and g.status IN ( 0,1,2,10) group by g.gallery_md5 order by date desc limit 0, 20. (basistube.com)
Mysql 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 ') and g.status IN ( 0,1,2,10) group by g.gallery_md5 order by date desc limit ' at line 6) (db_link) in query select SQL_CALC_FOUND_ROWS g.id, gs.total_ctr as max_ctr, gs.total_shows as casts, gs.total_clicks as clicks, g.priority as gs_priority FROM rot_galleries as g JOIN rot_gallery_data as gd on gd.gallery_md5 = g.gallery_md5 JOIN rot_gallery_info as gi on gi.gallery_md5 = g.gallery_md5 JOIN rot_gal2group as g2gr on g2gr.gal_id = g.id JOIN rot_gallery_stats as gs on gs.thumb_id = g.id WHERE 1 = 1 and gs.best_thumb = "yes" and not (g.rgroup = '0' and sponsor_id = 3) and sponsor_id IN (SELECT sponsor_id FROM rot_sponsors_data WHERE status = 1 and site_id = ) and g.status IN ( 0,1,2,10) group by g.gallery_md5 order by date desc limit 0, 20. (basistube.com)