WordPress.org

Support

Support » How-To and Troubleshooting » DB errors, is it the host or WP?

DB errors, is it the host or WP?

  • Okay, we just upgraded, and no more MySQL errors — but plenty of DB-related ones:

    This set was generated by an attempt to post something I wrote before the upgrade:

    WordPress database error: [Access denied for user: ‘dbo159687748@%’ to database ‘db159687748’]
    INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (‘865′,’_pingme’,’1′)

    WordPress database error: [Access denied for user: ‘dbo159687748@%’ to database ‘db159687748’]
    INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (‘865′,’_encloseme’,’1′)

    WordPress database error: [Access denied for user: ‘dbo159687748@%’ to database ‘db159687748’]
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES (‘cron’, ‘a:2:{i:1182708993;a:1:{s:8:\”do_pings\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:2:{s:8:\”schedule\”;b:0;s:4:\”args\”;a:0:{}}}}s:7:\”version\”;i:2;}’, ”, ‘yes’)

    Warning: Cannot modify header information – headers already sent by (output started at /homepages/33/d157690626/htdocs/dsc040002073/wp-includes/wp-db.php:133) in /homepages/33/d157690626/htdocs/dsc040002073/wp-includes/pluggable.php on line 331

    And this is the set generated when I tried to post a new test message:

    WordPress database error: [Access denied for user: ‘dbo159687748@%’ to database ‘db159687748’]
    INSERT IGNORE INTO wp_posts (post_author, post_date, post_date_gmt, post_content, post_content_filtered, post_title, post_excerpt, post_status, post_type, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_parent, menu_order, post_mime_type) VALUES (‘3’, ‘2007-06-24 13:26:03’, ‘2007-06-24 18:26:03’, ‘DBO errors are so much fun’, ”, ‘wp test #2a’, ”, ‘publish’, ‘post’, ‘open’, ‘open’, ”, ‘wp-test-2a’, ”, ”, ‘2007-06-24 13:26:03’, ‘2007-06-24 18:26:03’, ‘0’, ‘0’, ”)

    WordPress database error: [Access denied for user: ‘dbo159687748@%’ to database ‘db159687748’]
    INSERT INTO wp_post2cat (post_id, category_id) VALUES (‘0’, ‘1’)

    WordPress database error: [Access denied for user: ‘dbo159687748@%’ to database ‘db159687748’]
    INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (‘0′,’_pingme’,’1′)

    WordPress database error: [Access denied for user: ‘dbo159687748@%’ to database ‘db159687748’]
    INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (‘0′,’_encloseme’,’1′)

    WordPress database error: [Access denied for user: ‘dbo159687748@%’ to database ‘db159687748’]
    INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES (‘cron’, ‘a:2:{i:1182709563;a:1:{s:8:\”do_pings\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:2:{s:8:\”schedule\”;b:0;s:4:\”args\”;a:0:{}}}}s:7:\”version\”;i:2;}’, ”, ‘yes’)

    WordPress database error: [Access denied for user: ‘dbo159687748@%’ to database ‘db159687748’]
    INSERT INTO wp_usermeta ( user_id, meta_key, meta_value ) VALUES ( ‘3’, ‘wp_autosave_draft_ids’, ‘a:1:{i:-1182708977;i:0;}’ )

    Warning: Cannot modify header information – headers already sent by (output started at /homepages/33/d157690626/htdocs/dsc040002073/wp-includes/wp-db.php:133) in /homepages/33/d157690626/htdocs/dsc040002073/wp-includes/pluggable.php on line 331

    —-

    So, is this a hosting error? Or is it a problem with upgrading DB permissions? Or something else?

    Oddly enough, I *was* able to post one test message after we upgraded — although it did give rise to similar error messages to those above when I posted it in Safari, I was able to view it in Firefox. But when I tried a second test message, it was no go. Error messages, yes, test post #2, nope.

    Another odd thing: I am receiving emailed trackbacks for every article I ever posted. Up to 277 of ’em so far!

Viewing 12 replies - 1 through 12 (of 12 total)
  • It seems the database user doesn’t have all the required privileges. In order to work properly the DB user need “ALL” privileges in the database.

    It seems the database user doesn’t have all the required privileges. In order to work properly the DB user need “ALL” privileges in the database.

    Hmm… any reason the admin might not have ALL the privileges?

    The admin has NOTHING to do with the DB user! Those are two different things.

    The DB user is this: dbo159687748.
    In the site admin panel (not the WP!!!) you may have something where you set up your databases and the users for them. In the same place, usually, there is a possibility to assign privileges to the DB user. If you find it – select “ALL”.

    Ouch! Sorry. My skillset just doesn’t happen to include DBA or WP… I’m doing the best I can to help my admin figure this all out.

    DB (not DBA) = DataBase/database (which is the same as MySQL… since WordPress is using MySQL database)

    WP = WordPress

    (no skillsets required 🙂

    Well, considering that our blogsite is still down, I do rather wish I knew more about MySQL and database foo. Call that a skillset or not, I can’t believe it wouldn’t help to know!

    So WP *doesn’t* mean Whipping Post? White People? Weird Planets? 😉

    Is it the blog linked to your profile here? (that one works)

    If it’s 5gigawattlizard.net then it must be. But I just attempted to post again and got the errors listed below.

    Please excuse my stupidity, but are you saying the profile works, or that the blog does? Because while the latter does show posts made before our current problems (and, oddly, one of my several test posts) I definitely cannot post to it, at least not from Safari or Firefox.

    Also puzzling me — why was I able to post a test once, right after upgrading, but not after that?

    [repeated error message moderated]

    Don’t post mile long error messages again and again.

    I told you above what is to be checked: the privileges of the database user. Post back when you can answer to the question – does the database user have all the privileges?

    Ataraxia,
    does your host offer CPanel?
    If so, enter CPanel and click on MySQL Databases.
    Scroll down to: Add Users To Your Databases
    Select user dbo159687748@% on database db159687748
    click on Privileges: All
    click on Add User to Databasebutton

    No. And I looked thoroughly. I did find the PHPMyAdmin section, but to be honest I am afraid to mess with it because it says that changes made from the interface cannot be rolled back.

    I really appreciate the helpfulness of the folks here, and I am going to stop thinking about this for a while — the admin has already set it aside for now anyway.

    I told you above what is to be checked: the privileges of the database user. Post back when you can answer to the question – does the database user have all the privileges?

    Yes, you did. And the admin and I both did our damnedest to get the domain host’s interface to cough up the info, but it really *doesn’t have* that info accessible. Seriously, you should see it — its the worst interface I have used in years; possibly ever. Simply redoing the site will be much simpler 😛

    Goodbye.

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘DB errors, is it the host or WP?’ is closed to new replies.
Skip to toolbar