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

PHP 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 [DATE]1229919579[/DATE] at [TIME]1229919579[/TIME] ---------------

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.