SmartCJ Support Forum

Code: Select all

Fatal error: Uncaught exception 'Exception' with message 'Mysql error:: 1054 (Unknown column 'max_ctr' in 'order clause') (db_link) in query SELECT SQL_CALC_FOUND_ROWS DISTINCT(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 IN ('0','1','2','3','4','5','6','7','8','9','10','11','12','14') AND gi.gallery_type = 0 and gs.best_thumb = 'yes' and gs.group_id = 0 and ( url like '%32451%' or source_url like '%32451%' or gd.description like '%32451%' or gallery_slug like '%32451%' or gd.alt l in /home/httpd/domain.com/content/html/tcms/includes/db_modules/mysql.php on line 65 err

Code: Select all

/admin/?operation=rotation&sub=rot_list&vars[sort]=max_ctr%20desc&vars[have]=32451&vars[crop_profile_id]=0&vars[group]=cat_thumbs_less&vars[sponsor_id]=0&vars[status][]=0&vars[status][]=1&vars[status][]=2&vars[status][]=3&vars[status][]=4&vars[status][]=5&vars[status][]=6&vars[status][]=7&vars[status][]=8&vars[status][]=9&vars[status][]=10&vars[status][]=11&vars[status][]=12&vars[status][]=14&vars[show_thumbs]=0&vars[rows_per_page]=5&vars[cols_per_page]=3&vars[show_each_thumb]=0&vars[layout]=full&vars[content_type]=0&vars[show_new_thumbs]=0&vars[results_per_page]=18&page=0

Code: Select all

/admin/?operation=cheat&sub=reports&

Code: Select all

Build 201606010421     (Lastest build: 201606010421 )