sql error - quick help needed :)

[MetalMilitia]

http://forums.armageddononline.org

I uninstalled flashchat ( https://vborg.vbsupport.ru/showthread.php?t=166834 )

and am stuck with an sql error.

Can any geniuses help?

[R1lover]

did you remove any template edit you did when installing it?

you have some bad code

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
ORDER BY start' at line 6

--------------- Added 1229919579 at 1229919579 ---------------

here

Invalid SQL:

SELECT connections.*, rooms.*, user.*
FROM flashchat_connections as connections
LEFT JOIN flashchat_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 != ''
AND connections.updated > DATE_SUB(NOW(),INTERVAL SECOND)
ORDER BY start;

[MetalMilitia]

Yeesh, I figured it out. I need some sleep.

MODS DELETE THIS :)

[R1lover]

It would be better to explain what happened so the next guy might find this to help him. :)