User Statistics not working
Posted: 22 Sep 2011, 06:03
I was able to use user statistics for about 30 seconds, but when I tried to search for a user, it returned this message:
after which I couldn't view user statistics at all, just the error.
Code: Select all
500 - An error has occurred.
Unknown column 'a.title' in 'where clause' SQL=SELECT a.*,d.filename AS filename, d.title AS filetitle, a.date,ua.id AS userid, ua.username AS username, ua.name AS usernameno FROM `j16_phocadownload_user_stat` AS a LEFT JOIN j16_phocadownload AS d ON d.id = a.fileid LEFT JOIN j16_users AS ua ON ua.id = a.userid WHERE a.fileid = 1 AND ( a.title LIKE '%gayle%' OR a.filename LIKE '%gayle%') GROUP BY a.id ORDER BY a.ordering asc Unknown column 'a.title' in 'where clause' SQL=SELECT a.*,d.filename AS filename, d.title AS filetitle, a.date,ua.id AS userid, ua.username AS username, ua.name AS usernameno FROM `j16_phocadownload_user_stat` AS a LEFT JOIN j16_phocadownload AS d ON d.id = a.fileid LEFT JOIN j16_users AS ua ON ua.id = a.userid WHERE a.fileid = 1 AND ( a.title LIKE '%gayle%' OR a.filename LIKE '%gayle%') GROUP BY a.id ORDER BY a.ordering asc LIMIT 0, 20 Unknown column 'a.title' in 'where clause' SQL=SELECT a.*,d.filename AS filename, d.title AS filetitle, a.date,ua.id AS userid, ua.username AS username, ua.name AS usernameno FROM `j16_phocadownload_user_stat` AS a LEFT JOIN j16_phocadownload AS d ON d.id = a.fileid LEFT JOIN j16_users AS ua ON ua.id = a.userid WHERE a.fileid = 1 AND ( a.title LIKE '%gayle%' OR a.filename LIKE '%gayle%') GROUP BY a.id ORDER BY a.ordering asc Unknown column 'a.title' in 'where clause' SQL=SELECT a.*,d.filename AS filename, d.title AS filetitle, a.date,ua.id AS userid, ua.username AS username, ua.name AS usernameno FROM `j16_phocadownload_user_stat` AS a LEFT JOIN j16_phocadownload AS d ON d.id = a.fileid LEFT JOIN j16_users AS ua ON ua.id = a.userid WHERE a.fileid = 1 AND ( a.title LIKE '%gayle%' OR a.filename LIKE '%gayle%') GROUP BY a.id ORDER BY a.ordering asc
Return to Control Panel