Ошибки MySQL
Posted: Mon May 18, 2020 5:25 am
Приветствую, подскажите пожалуйста что нужно исправить или заменить? Приходят время от времени такие ошибки:
2020-05-18 05:16:23 : 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 ') ORDER BY tested_thumb DESC, gs.total_ctr DESC # queryitems' at line 4 (SELECT gs.gallery_id, gs.thumb_id, gi.sponsor_id, gi.content_count, gi.content_type, gs.total_shows, gs.total_clicks, gs.total_ctr, gt.thumb_url, gd.*, gi.content_count, gi.crop_profile_id, gs.activation_date, gi.added_date, gi.duration, gi.url, gi.gallery_total_shows, gi.sponsor_id, gi.source_url, gi.custom_gallery FROM rot_gallery_stats1 as gs JOIN rot_gallery_info as gi on gi.gallery_id = gs.gallery_id<br> JOIN rot_gallery_data1 as gd on gd.gallery_id = gs.gallery_id<br> JOIN rot_thumbs as gt on gt.thumb_id = gs.thumb_id <br> WHERE 1 = 1 AND gi.gallery_status = 'active' AND gi.gallery_type = 0 and gs.best_thumb = 'yes' and gs.group_id IN (315) AND gs.gallery_id NOT IN ('5191', '5176', '5174', '5125', '5115', '4967', '4872', '4518') AND gi.gallery_id IN () ORDER BY tested_thumb DESC, gs.total_ctr DESC # queryitems)
Ранее игнорировал их, просто удалял - так как не замечал на что они влияют, но понимаю что их быть не должно.. Хелп плз.
2020-05-18 05:16:23 : 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 ') ORDER BY tested_thumb DESC, gs.total_ctr DESC # queryitems' at line 4 (SELECT gs.gallery_id, gs.thumb_id, gi.sponsor_id, gi.content_count, gi.content_type, gs.total_shows, gs.total_clicks, gs.total_ctr, gt.thumb_url, gd.*, gi.content_count, gi.crop_profile_id, gs.activation_date, gi.added_date, gi.duration, gi.url, gi.gallery_total_shows, gi.sponsor_id, gi.source_url, gi.custom_gallery FROM rot_gallery_stats1 as gs JOIN rot_gallery_info as gi on gi.gallery_id = gs.gallery_id<br> JOIN rot_gallery_data1 as gd on gd.gallery_id = gs.gallery_id<br> JOIN rot_thumbs as gt on gt.thumb_id = gs.thumb_id <br> WHERE 1 = 1 AND gi.gallery_status = 'active' AND gi.gallery_type = 0 and gs.best_thumb = 'yes' and gs.group_id IN (315) AND gs.gallery_id NOT IN ('5191', '5176', '5174', '5125', '5115', '4967', '4872', '4518') AND gi.gallery_id IN () ORDER BY tested_thumb DESC, gs.total_ctr DESC # queryitems)
Ранее игнорировал их, просто удалял - так как не замечал на что они влияют, но понимаю что их быть не должно.. Хелп плз.