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.