WordPress DataBase Error

  • farrelldoc

    (@farrelldoc)


    15 years, 9 months ago

    I am getting the following error on http://www.bayareaball.org. This error is also visible on the Dashboard of new users who register for my website!

    WordPress database 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 'AND post_type = 'post' GROUP BY post_status' at line 1]
SELECT post_status, COUNT( * ) AS num_posts FROM wp_posts WHERE AND post_type = 'post' GROUP BY post_status

    I have the following plugins installed:

    AddThis Social Bookmarking Widget
    Akismet
    CaPa Protect (THIS WAS INSTALLED AFTER THE PROBLEM STARTED)
    Fast Secure Contact Form
    Google Analyticator
    LeagueManager (THIS WAS INSTALLED AFTER THE PROBLEM STARTED)
    MCE Table Buttons (THIS WAS INSTALLED AFTER THE PROBLEM STARTED)
    MiniMeta Widget
    Register Plus (NOT ACTIVE)

    I deactivated Register Plus because when I tried registering as a new user, I got the following error:

    Catchable fatal error: Object of class WP_Error could not be converted to string in /home/baba/public_html/wp-includes/formatting.php on line 2772

    When I deactivated the plugin, I was able to register without a problem, but that’s when I discovered the database error listed above.

    Also, when I log in with my admin login, I go straight to wp-admin, and if I open the public site in a new tab, it shows that I am not logged in. I cannot view the public site as a logged in user, which is really a pain because I have some protected pages on there that I need to view logged in (with CaPa Protect).

    Thanks for your help!
    Karen

Viewing 5 replies - 1 through 5 (of 5 total)
  • esmi

    (@esmi)

    15 years, 9 months ago

    Have you tried:

    – deactivating all plugins to see if this resolves the problem? If this works, re-activate the plugins one by one until you find the problematic plugin(s).

    – resetting the plugins folder by FTP or phpMyAdmin? Sometimes, an apparently inactive plugin can still cause problems.

    Thread Starter farrelldoc

    (@farrelldoc)

    15 years, 9 months ago

    Thank you for the response! I didn’t get a notification of it, so I’m glad I came back to the forum! 🙂

    I tried the first method, and that did not resolve the issue. Before I try the second method, I want to make sure that is the right thing to do. (I always get a little nervous when I mess around in phpMyAdmin.) I do have access to the wp-admin, and I can log in to wp-admin. (In fact, I am taken straight there when I log in.) The problem is that I am not recognized as a logged-in user or admin on the public site. I also now have no inactive plugins–I deleted all of them.

    I will try the second option if you think it will help, but I just want to make sure that is the right path before I venture into the database. 🙂

    Thanks again for your help!
    Karen

    Thread Starter farrelldoc

    (@farrelldoc)

    15 years, 9 months ago

    Oh–I just realized that I posted the wrong reply in the wrong thread. I have another thread about another problem that hasn’t gotten a response yet.

    The database problem seems to have disappears mysteriously???

    But this other issue is driving me bonkers…

    Thanks,
    Karen

    Thread Starter farrelldoc

    (@farrelldoc)

    15 years, 9 months ago

    I take that back–the database error is still there. 🙁

    Thread Starter farrelldoc

    (@farrelldoc)

    15 years, 9 months ago

    I take that back–the database error is still there. 🙁

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘WordPress DataBase Error’ is closed to new replies.