MySQL errors

  • Slushman

    (@butimnoexpert)


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

    https://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?

Viewing 9 replies - 1 through 9 (of 9 total)
  • Moderator Samuel Wood (Otto)

    (@otto42)

    www.ads-software.com Admin

    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.

    Thread Starter Slushman

    (@butimnoexpert)

    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?

    dmkjr

    (@dmkjr)

    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?

    Moderator Samuel Wood (Otto)

    (@otto42)

    www.ads-software.com Admin

    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.

    rodrifernandes

    (@rodrifernandes)

    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’

    Moderator Samuel Wood (Otto)

    (@otto42)

    www.ads-software.com Admin

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

    drmike

    (@drmike)

    I asked him that in the poster’s other thread…

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

    check out this link:

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

    it seem to solve the problem

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘MySQL errors’ is closed to new replies.