TCMS Build 201703171903
Posted: Mon Mar 20, 2017 11:04 am
Обновил сегодня до билда указанного в заголовке
Запуск rotation.php стал выдавать одинаковую ошибку на всех доменах
PHP Fatal error:
Uncaught exception 'Exception' with message 'Mysql error:: 1064 (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 '))
ORDER BY tested_thumb DESC, gs.total_ctr DESC LIMIT 0, 1' at line 3) (db_link) in query 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, gi.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_data1 as gd on gd.gallery_id = gs.gallery_id
JOIN rot_gallery_info as gi on gi.gallery_id = gs.gallery_id JOIN rot_thumbs as gt on gt.thumb_id = gs.thumb_id
WHERE 1 = 1 AND gi.gallery_status = 'active' AND gi.gallery_type = 0 and gs.best_thumb = 'yes' and gs.group_id IN (1) and gs.gallery_id NOT IN ( SELECT gallery_id FROM rot_gallery_stats1 in /home/user/domains/domain.com/public_html/scj/includes/db_modules/mysql.php on line 72
Запуск rotation.php стал выдавать одинаковую ошибку на всех доменах
PHP Fatal error:
Uncaught exception 'Exception' with message 'Mysql error:: 1064 (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 '))
ORDER BY tested_thumb DESC, gs.total_ctr DESC LIMIT 0, 1' at line 3) (db_link) in query 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, gi.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_data1 as gd on gd.gallery_id = gs.gallery_id
JOIN rot_gallery_info as gi on gi.gallery_id = gs.gallery_id JOIN rot_thumbs as gt on gt.thumb_id = gs.thumb_id
WHERE 1 = 1 AND gi.gallery_status = 'active' AND gi.gallery_type = 0 and gs.best_thumb = 'yes' and gs.group_id IN (1) and gs.gallery_id NOT IN ( SELECT gallery_id FROM rot_gallery_stats1 in /home/user/domains/domain.com/public_html/scj/includes/db_modules/mysql.php on line 72