منتدى استراحات زايد

I've seen a million posts about this and I've tried almost all of the solutions provided and I don't know what to do. I currently seeing the following error on my forum and no users are able to login however i am allowed to access the admin cp (thank goodness):

Database error in vBulletin 3.8.2:

Invalid SQL:
SELECT COUNT(*) AS newposts FROM post WHERE dateline >= 07:49 PM, 05-29-2009 AND visible = 1;

MySQL Error : 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 ':49 PM, 05-29-2009 AND visible = 1' at line 1
Error Number : 1064
Request Date : Monday, June 1st 2009 @ 09:28:54 PM
Error Date : Monday, June 1st 2009 @ 09:28:54 PM
Script : http://www.mydomain.com/forums/index.php
Referrer :
IP Address : my IP address
Username : myusername
Classname : vB_Database
MySQL Version : 5.0.51b-community-nt

about 10 minutes before I got an error I was trying to add the members who are chatting mod to my site. it worked great for about 10 minutes and then WHAM error code. I contacted the guy who made the mod on vbulletin.org and he said he couldn't help me.

I'm scared that I can't fix this and would appreciate any advise that you can give me :)

thanks