Code: Select all
2021-01-04 23:17:24:#0 /data/www/domains.com/scj/includes/db_modules/mysql.php(182): db_error('SELECT gs.gal...', 1054, 'Unknown column ...', 'db_link')
#1 /data/www/domains.com/scj/includes/libs/tpl_tags.php(0): db_query('SELECT gs.gal...', 'db_link')
#2 /data/www/domains.com/scj/includes/libs/tpl_tags.php(0): rot_get_item_execute_query('SELECT gs.gal...', Array, Array)
#3 /data/www/domains.com/scj/includes/libs/tpl_functions.php(0): rot_get_items(Array, 0, Array)
#4 /data/www/domains.com/scj/tube/index.php(0): rot_create_page('content_page', 0, Array, Array, Array)
#5 {main}
Mysql error:: 1054 (Unknown column 'rot_gal2tag.tag_id' in 'where clause') (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, 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 FORCE INDEX (group_id) STRAIGHT_JOIN rot_gallery_info as gi on gi.gallery_id = gs.gallery_id
STRAIGHT_JOIN rot_gallery_data1 as gd on gd.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 = 0 AND rot_gal2tag.tag_id IN ('1119','6382','11290','25471','29922') and rot_gal2tag.site_id = '1' ORDER BY tested_thumb DESC, gs.total_ctr DESC LIMIT 0, 51# queryitems.
ошибок стало меньше , но еще есть.