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?
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?