Unknown column 'max_ctr' in 'order clause'

Post Reply
alexscj
Posts: 160
Joined: Mon Apr 01, 2013 3:04 pm

Unknown column 'max_ctr' in 'order clause'

Post by alexscj »

Hello, migrated db from SCJ to TCMS (202006241231), I'm getting this error when trying to Rotation - List thumbs:
Fatal error: Uncaught Exception: 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, gs.activation_date, gi.added_date, gi.duration, gi.url, gi.gallery_total_shows, gi.sponsor_id, gi.source_url, gi.custom_gallery ,gallery_type FROM rot_gallery_stats1 as gs JOIN rot_gallery_info as gi on gi.gallery_id = gs.gallery_id 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 IN ('12') AND gi.gallery_type = 0 and gs.best_thumb = 'yes' and gs.group_id = 0 group by gs.gallery_id, gs.thumb_id ORDER BY max_ctr desc LIMIT 0, 15# queryitems. (domain_removed) in /path_removed/includes/db_modules/mysql.php:129 Stack trace: #0 /path_removed in /path_removed/includes/db_modules/mysql.php on line 129

In Script messages:
Mysql error 1054: Unknown column 'max_ctr' in 'order clause' (Please, run update. If it doesnt help - contact script support)
admin
Site Admin
Posts: 37247
Joined: Wed Sep 10, 2008 11:43 am

Re: Unknown column 'max_ctr' in 'order clause'

Post by admin »

Hello, reset browser cookies or run update
Don't forget to run script update
alexscj
Posts: 160
Joined: Mon Apr 01, 2013 3:04 pm

Re: Unknown column 'max_ctr' in 'order clause'

Post by alexscj »

Already tried updating but clearing the browser cache/cookies solved the problem, thanks!

Out of curiosity, why would the mysql SELECT command from "List thumbs" have anything to do with the local cache/cookies ?
admin
Site Admin
Posts: 37247
Joined: Wed Sep 10, 2008 11:43 am

Re: Unknown column 'max_ctr' in 'order clause'

Post by admin »

sort order was saves in cookie, version 1 had max_ctr, version 2 has other variables
Don't forget to run script update
Post Reply