SmartCJ Support Forum

Code: Select all

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, 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  STRAIGHT_JOIN rot_gallery_data1 as gd on gd.gallery_id = gs.gallery_id 
			STRAIGHT_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 = 0  AND rot_gal2tag.tag_id IN ('13')  ORDER BY  tested_thumb DESC,  gs.total_ctr DESC  LIMIT 0, 10# queryitems. (stolenbeach.com) 
2016-10-31 09:03:35:#0 /home/admin/web/site.com/public_html/scj/includes/db_modules/mysql.php(89): db_error('SELECT   gs.gal...', 1054, 'Unknown column ...', 'db_link')
#1 /home/admin/web/site.com/public_html/scj/includes/libs/tpl_functions.php(0): db_query('SELECT   gs.gal...', 'db_link')
#2 /home/admin/web/site.com/public_html/scj/includes/libs/tpl_functions.php(0): rot_get_item_execute_query('SELECT   gs.gal...', Array, Array)
#3 /home/admin/web/site.com/public_html/scj/includes/libs/tpl_functions.php(0): rot_get_items(Array, 0, Array)
#4 /home/admin/web/site.com/public_html/scj/tube/index.php(0): rot_create_page('content_custom_...', 0, Array, Array, Array)
#5 /home/admin/web/site.com/public_html/scj/cgi/out.php(0): include('/home/admin/web...')
#6 /home/admin/web/site.com/public_html/scj/cgi/out.php(0): my_location(Array, true)
#7 {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, 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  STRAIGHT_JOIN rot_gallery_data1 as gd on gd.gallery_id = gs.gallery_id 
			STRAIGHT_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 = 0  AND rot_gal2tag.tag_id IN ('4')  ORDER BY  tested_thumb DESC,  gs.total_ctr DESC  LIMIT 0, 10# queryitems. (site.com) 

Code: Select all

2017-09-01 09:07:11:#0 /home/path/domain.net/script_folder/includes/db_modules/mysql.php(103): db_error('INSERT INTO rot...', 1054, 'Unknown column ...', 'db_link')
#1 /home/path/domain.net/script_folder/includes/libs/tpl_functions.php(0): db_query()
#2 /home/path/domain.net/script_folder/includes/libs/tpl_functions.php(0): rot_get_items()
#3 /home/path/domain.net/script_folder/tube/index.php(0): rot_create_page()
#4 /home/path/domain.net/index.php(0): unknown()
#5 {main}
Mysql error:: 1054 (Unknown column 'search_query_limit' in 'field list') (db_link) in query INSERT INTO rot_search_queries
				SET search_query = 'anal', 
				search_query_limit = '', 
				hits = '1', date = NOW()
				ON DUPLICATE KEY UPDATE hits = hits + 1. (domain.net)