Log in

View Full Version : Database Error


Abhik
07-01-2010, 04:01 PM
Hello,
I am getting this since upgrading to vBulletin 4.0.4

mySQL query error: SELECT s.userid, s.location, s.in_game, u.username, g.opentag, g.closetag, u.options
FROM mst_session as s
LEFT JOIN mst_user as u ON (u.userid = s.userid)
LEFT JOIN mst_usergroup as g ON (u.usergroupid = g.usergroupid)
WHERE s.lastactivity > 1278002675 AND s.location LIKE '%rcade%' AND s.location NOT LIKE '%admin%'
GROUP BY s.userid
ORDER BY u.username ASC

mySQL error: Unknown column 's.in_game' in 'field list'
mySQL error code:
Date: Thursday 01st 2010f July 2010 12:59:35 PM

Any idea how to solve this?

Hippy
07-25-2010, 01:08 PM
are you uising the latest version of the arcade ?
if not upgrade it..

you may also want to try a re-install..

don't un-install it ..
just run the reinstall.