Database error - unsure what it's related to

[Kung!]

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:

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.

[Zachery]

That's not a default query, its from one of your third party addons.

[Kung!]

It just hit me that FlashChat is still supposedly installed on that site...which would explain it.

Here comes what may be a supremely stupid question but I gotta ask: Could fixing it be as simple as uninstalling the addon? LOL (I say that because it's never that easy, it seems like.)

[Zachery]

uninstalling or disabling would do it.

[Kung!]

Well, I uninstalled it, and....no dice. Same error. LOL

That said, I would assume that there's some code that needs to be removed, unless I'm missing something.

[ForceHSS]

And did you remove all files from ftp and if any custom coding came with it reverted the templates

[Kung!]

I'm just now coming to that conclusion. I did indeed revert the templates, but it's still happening, obviously.

So far it looks like it's only happening on the main index page, and when I click 'Mark forums read' in the Activity Stream.

This said, it's been a while (like 2 years) since I've had to manually edit any templates...so I'm having a bit of a hard time figuring out specifically what needs editing. It seems that there's code in whatever files are used to display the main index page that refers to the third party hack that needs to be removed.

[tpearl5]

It could just be a spider accessing an old php script that calls that query. Did you delete the files associated with the mod?

[Kung!]

Well, that's the problem...I've been searching around trying to find all the files associated with the mod, and figure out the changes it made/makes, but as of yet have been unsuccessful.

[tpearl5]

it will be in the error message under referral