I'll state up front that I did a bit of searching around; so if I missed something, my profuse apologies.
A while back our site got infected with malware. We finally got it fully cleaned, and in the process of that we updated our site from 4.1.10 PL3 (or something - I forget just now lol) to 4.2.2 PL1.
I've got most of the kinks ironed out, but while I can access EVERY other page of the site, the main index gives me a database error:
Quote:
Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT connections.*,rooms.*,user.*
FROM connections as connections
LEFT JOIN rooms as rooms ON connections.roomid = rooms.id
LEFT JOIN user as user ON connections.userid = user.userid
WHERE connections.userid > 0 AND connections.ip != '0.0.0.0'
AND connections.updated > DATE_SUB(NOW(),INTERVAL 60 SECOND)
ORDER BY start;
MySQL Error : Table '(our database).connections' doesn't exist
|
By looking at it, it seems like it's related to some sort of chat room, but I'm unsure. Can anyone point me in the right direction? Help would be much appreciated.