WordPress.org

Forums

DB errors, is it the host or WP? (13 posts)

  1. Ataraxia
    Member
    Posted 8 years ago #

    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!

  2. moshu
    Member
    Posted 8 years ago #

    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.

  3. Ataraxia
    Member
    Posted 8 years ago #

    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?

  4. moshu
    Member
    Posted 8 years ago #

    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".

  5. Ataraxia
    Member
    Posted 8 years ago #

    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.

  6. moshu
    Member
    Posted 8 years ago #

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

    WP = WordPress

    (no skillsets required :)

  7. Ataraxia
    Member
    Posted 8 years ago #

    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? ;)

  8. moshu
    Member
    Posted 8 years ago #

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

  9. Ataraxia
    Member
    Posted 8 years ago #

    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]

  10. moshu
    Member
    Posted 8 years ago #

    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?

  11. Marcel Brinkkemper
    Member
    Posted 8 years ago #

    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

  12. Ataraxia
    Member
    Posted 8 years ago #

    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.

  13. Ataraxia
    Member
    Posted 8 years ago #

    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 :P

    Goodbye.

Topic Closed

This topic has been closed to new replies.

About this Topic