SmartCJ Support Forum

Code: Select all

Fatal error: Uncaught exception 'Exception' with message 'Mysql error:: 1054 (Unknown column 'time_spent' in 'field list') (db_link) in query select trader, SUM(raw) as raw, SUM(uni) as uni, SUM(`out`) as `out`, SUM(clicks_trade) as clicks_trade, SUM(clicks_url) as clicks_url, SUM(quality_trade) as quality_trade, SUM(quality_url) as quality_url, SUM(proxy) as proxy, SUM(proxy_out) as proxy_out, SUM(cheat) as cheat, SUM(user_count) as user_count, SUM(user_dis) as user_dis, SUM(next_click) as next_click, SUM(header) as header , ROUND(AVG(time_spent), 2) as time_spent FROM (select SUBSTRING_INDEX(trader, '/', 1) as trader, SUM(raw) as raw, SUM(uni) as uni, SUM(`out`) as `out`, SUM(clicks_trade) as clicks_trade, SUM(clicks_url) as clicks_url, SUM(quality_trade) as quality_trade, SUM(quality_url) as quality_url, SUM(proxy) as proxy, SUM(proxy_out) as proxy_out, SUM(cheat) as cheat, SUM(user_count) as user_count, SUM(user_dis) as user_dis, SUM(next_click) as next_click, SUM(head in /home/user/domains/domain.com/public_html/tcms/includes/db_modules/mysql.php on line 65
err