WordPress.org

Ready to get started?Download WordPress

Forums

MySQL errors (10 posts)

  1. Slushman
    Member
    Posted 7 years ago #

    I just downloaded and installed WordPress on my server a few days ago. I've gotten my blog setup and everything was working fine until yesterday. First, I got locked out of my account. I followed these instructions for resetting my password:

    http://www.tamba2.org.uk/wordpress/phpmyadmin/

    They worked like a charm. I also installed a few add-ons: WordPress Widgets, Adsense Widget, and the one to monitor my adsense revenue (can't remember the name exactly). Now, when I try to log in and admin my blog, I'm getting these following:

    WordPress database error: [Lost connection to MySQL server during query]
    UPDATE wp_options SET option_value = '1173293550' WHERE option_name = 'adsensedailytime'

    WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM wp_options WHERE option_name = 'widget_text' LIMIT 1

    WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM wp_options WHERE option_name = 'widget_rss' LIMIT 1

    WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM wp_options WHERE option_name = 'sidebars_widgets' LIMIT 1

    WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM wp_options WHERE option_name = 'sidebars_widgets' LIMIT 1

    WordPress database error: [MySQL server has gone away]
    SELECT * FROM wp_users WHERE user_login = 'admin'

    WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM wp_options WHERE option_name = 'sidebars_widgets' LIMIT 1

    WordPress database error: [MySQL server has gone away]
    SELECT * FROM wp_users WHERE user_login = 'admin'

    Warning: Cannot modify header information - headers already sent by (output started at /home/content/c/w/i/cwilcoxson/html/wp-includes/wp-db.php:121) in /home/content/c/w/i/cwilcoxson/html/wp-includes/pluggable.php on line 275

    I didn't touch anything in the database when I reset my password, except the password. What does this mean and how do I fix it?

  2. Samuel Wood (Otto)
    Tech Ninja
    Posted 7 years ago #

    WordPress database error: [Lost connection to MySQL server during query]

    This means that you need to contact your host to find out what's wrong with your DB server.

  3. Slushman
    Member
    Posted 7 years ago #

    That's really weird because I can log into that server and see all the tables and fields. The database itself seems to be running ok. Anything else I should check?

  4. dmkjr
    Member
    Posted 7 years ago #

    I'm having the same problem.

    Warning: session_start() [function.session-start]: open(/tmp/sess_a5658671cb0494836638d787fb8d7af2, O_RDWR) failed: Read-only file system (30) in /home/dmkjr/public_html/wp-content/plugins/alinks/alinks.php on line 23

    Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/dmkjr/public_html/wp-content/plugins/alinks/alinks.php:23) in /home/dmkjr/public_html/wp-content/plugins/alinks/alinks.php on line 23

    Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/dmkjr/public_html/wp-content/plugins/alinks/alinks.php:23) in /home/dmkjr/public_html/wp-content/plugins/alinks/alinks.php on line 23

    WordPress database error: [Can't create/write to file '/tmp/#sql_be7_0.MYI' (Errcode: 30)]
    SELECT * FROM wp_alinks_keyphrases ORDER BY RAND()

    That's the error I'm recieving. Help?

  5. Samuel Wood (Otto)
    Tech Ninja
    Posted 7 years ago #

    dmkjr: That's not the same problem at all, and your problem is with a plugin. Disable that plugin, it's not going to work on your server, since you don't have write permissions to /tmp.

  6. rodrifernandes
    Member
    Posted 7 years ago #

    I have the same problem:

    WordPress database error: [Lost connection to MySQL server during query]
    UPDATE wp_options SET option_value = '1173355012' WHERE option_name = 'adsensedailytime'

  7. Samuel Wood (Otto)
    Tech Ninja
    Posted 7 years ago #

    What is "adsensedailytime"? Is this some kind of plugin you're running? It's not a default option anywhere in the core.

  8. drmike
    Member
    Posted 7 years ago #

    I asked him that in the poster's other thread...

  9. mlanger
    Member
    Posted 7 years ago #

    butimnoexpert, are you using GoDaddy.com for your server?

  10. bregutz
    Member
    Posted 7 years ago #

    check out this link:

    http://www.openadvent.com/blog/?p=30#more-30

    it seem to solve the problem

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags