MyBB Community Forums

Full Version: Another Problem.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Ok, now when I try to view my site at http://koolbots.biz/forum/ I see this error:

Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1064 - 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 ')' at line 1
Query:
SELECT COUNT(tid) AS newann FROM bluepowerproducts_threads WHERE dateline>'1240159824' AND fid IN (2,)

I just updated and it was working fine. Then I pressed Private Messages on accident. So I went back to the index, and I see this. But, the ACP is working fine.

What do I need to do?
What plugins do you have??
My current activated plugins:
  • Admin IP Match Plugin (1.1)
    AdminCp Popup (1.2)
    Awaiting Activation Message (1.1)
    Add Spiders (0.1)
    Admin Edit BBCode (1.0)
    Admin Password (1.0)
    Ad Rotation system (5.0.1)
    Affiliates Manager (1.0)
    Akismet (1.2.1)
    AutoMove (1.0)
    Awards (1.0)
    Birthday Mailer (2.0.1)
    Buddies In UserProfile (1.0)
    Board Messages (2.0.0)
    Buy Access (1.0)
    Cool Announcements (2.5 Beta)
    Construction Mode (1.0)
    Contact Form (3.0)
    Cool Download BBCode (1.0)
    Custom Pages (3.0)
    Delete Member Posts (2.0)
    Easy Refer (2.0)
    MyBB eCellular (1.1.2)
    Fast Menu (0.2b)
    Favicon (1.1)
    Forum Icons (2.0)
    Force Users To Read Threads (2.0)
    Form Manager (1.0)
    Googlesearch Mycode (1.0)
    Google Analytics (2.0)
    Notice On New GroupRequests (1.0)
    Guest Access (1.0)
    GuestQueue (1.0)
    Last Edit Lock (1.0)
    Last Threads, Posts and Popular Threads on UserCP Home (1.0)
    Multiple Account Detector (M.A.D) (1.0)
    Mail on activation (1.4)
    User E-mail Validation! (1.0.1)
    Message of The Day (1.0 Beta)
    The Minimum Posts Suite (1.1)
    Minimum Thread Titles (2.0)
    Miss You Email (1.0.0)
    Mod User Notes (1.1)
    Monthly Stats (1.0)
    MyMood (1.0 Beta)
    Member Of The Week/Month (1.1)
    Multiple reputations (2.0)
    My Ad Manager (1.1.4)
    My Proxy Killer (1.0)
    My Side Boxes (1.0)
    My Youtube (1.1)
    MyBlogs (1.0)
    [MyBlogs] Charge For Blogs (1.0)
    MyIPN (2.2)
    MyPayPal (1.2)
    MYPS (1.3)
    My Question (1.3)
    MyStaff v1.1 (1.1)
    MyStore (1.0)
    Mystore Bank (1.0)
    Necropost Notice (1.0)
    Online 24 (2.2)
    Profile Ads (1.0 Beta)
    Permissions box! (2.0)
    Prevent Posts With Links (1.0)
    Private Messages Admin (2.4.1)
    PM On New Buddy (1.0)
    Post icons on index in the last post (1.0.3)
    Post Please! (1.0)
    Profile Ban (2.0)
    Profile View Counter (1.0)
    Prune Members (2.0)
    Quick Theme! (1.1.2)
    reCAPTCHA Plugin (1.1)
    Repoco (1.0)
    Reported Posts In Thread (1.0)
    Reported Posts Message (1.0)
    Restricted private messages (2.0)
    Search Captcha Protection (1.0)
    Search Log (1.0)
    Send Mail To BoardAdmin On New Registration (1.0)
    Signature Groups (1.0)
    Spoiler BBCode (1.0)
    Stop Forum Spam (1.1.0)
    Tabbed Menu (1.1)
    Tagpad (2.1)
    Thread Viewer (1.0)
    Thread Subtitle (1.0)
    Specific forum banning (1.0.1)
    User Guestbooks (1.0)
    Usergroup legends (2.0)
    Username History w/ Time Restriction (2.0)
    Warn Recount (1.0)
    Extra Safety Check While Registering (2.0)
    YouTube BBCode (2.0)
Deactivate your "Cool Announcements" plugin
(2009-04-19, 09:40 PM)Ryan Gordon Wrote: [ -> ]Deactivate your "Cool Announcements" plugin

I get the same error.
I'm not sure what I did, but it's fixed. Thanks, though.
Does anyone know anything I should do? It came back. :/
Does anyone know what I should do?
Deactivate all your plugins one at a time to find the error, so you'll know if it's a plugin.
That is probably the only way to work out what is causing the problem.
When I deactivated Thread Subtitle and checked to see if it was back up, it was. Big Grin

But then I activated it, and it was still viewable.

Why would it be like that? I checked every time after I deactivated one.