2009-04-09, 01:52 AM
Ok, I checked for any updates of my plugins and saw that there is a new release of game section. I downloaded it and reinstalled all the files. I went to the link and this is the message i got:
~alien5
Quote:MyBB SQL Errorcan anyone tell me what this means and what I have to do to fix it. thanks!
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1054 - Unknown column 'g.numratings' in 'field list'
Query:
SELECT DISTINCT g.gid, g.title, g.name, g.description, g.played, g.lastplayed, g.lastplayedby, g.rating, g.numratings, g.dateline, c.username, c.score, f.fid, r.rid, s.score AS pscore, u.username AS lastplayedusername FROM mybb_games g LEFT JOIN mybb_games_champions c ON (g.gid=c.gid) LEFT JOIN mybb_games_favourites f ON (g.gid=f.gid AND f.uid='2') LEFT JOIN mybb_games_rating r ON (g.gid=r.gid AND r.uid='2') LEFT JOIN mybb_games_scores s ON (g.gid=s.gid AND s.uid='2') LEFT JOIN mybb_users u ON (g.lastplayedby=u.uid) WHERE g.active='1' GROUP BY g.gid ORDER BY g.title ASC LIMIT 0,20
~alien5