Quote:
Originally Posted by mathforum
I've installed everything and re-uploaded to make sure I didn't miss anything, but I keep getting this MySQL error:
mySQL query error: SELECT g.gid, g.active, count(*) nb, g.bestscore, g.bestmid AS champ_mid, u.username AS champ_name FROM games_list AS g INNER JOIN user AS u ON u.userid=g.bestmid WHERE active=1 GROUP BY bestmid ORDER BY 3 DESC LIMIT 1
mySQL error: Unknown column 'g.bestscore' in 'field list'
mySQL error code:
Date: Monday 14th of August 2006 06:31:47 PM
when I try to access arcade.php on my main site and
mySQL query error: SELECT usergroupid, title, arcade_access, p_require, max_play, ppd_require, ibpa_cats, tourney FROM usergroup
mySQL error: Unknown column 'tourney' in 'field list'
mySQL error code:
Date: Monday 14th of August 2006 06:34:01 PM
when I access Group Permissions from my AdminCP
I uploaded version 2.5.6 but in my product manager it says I have version 2.5.3.
Please help
Fixed! No help needed. Thank you MrZeroPage!
|
How did you fix it? I've been having that error on a friend's forum for about a week.
Edit: My cousin fixed it. Was an issue with the game_list table, which was corrupted. Simply uploading a back-up fixed it.