WordPress.org

Ready to get started?Download WordPress

Forums

MySql, Database errors causing slow loading websites & Error-Filled Forum Page (4 posts)

  1. creepyqueen
    Member
    Posted 3 years ago #

    Alright, I'm hoping someone can help me with this, because I have been dealing with the worst tech support from my host for over two weeks, with absolutely zero steps in the right direction.

    I happened upon a new host a couple months ago, limewebs. I was originally using 'webs', but saw limewebs offered a free subdomain plan, so I figured I could create a wordpress site while still running my original website and then switch it over with minimal downtime for my readers.

    Unfortunately, the hosting plan I upgraded to didn't alott enough bandwidth for my website. So a week into using the new site, I had to upgrade again.

    But with limewebs, when you upgrade hosting, you don't just 'upgrade it'. you have to initiate a transfer from the old hosting plan to the new one. As I had learned from visiting their useless live chat service, this takes 48 hours.

    Immediately after initiating the transfer, the site began to load terribly slow. Users couldn't log in, pages would hang, etc. Some stuff works just like it did before the transfer, but I'm getting emails from members that pages hand, and they can no longer log in, etc.

    And most importatenly, the Forum (I'm using simple:press plugin), is no longer loading at all. And the page returns with a ton of mysql and database errors.

    directly from our forum page:

    WordPress database error: [MySQL server has gone away]
    SELECT COUNT(*) FROM wp_sfmessages WHERE to_id = 1 AND inbox=1 AND message_status=0

    WordPress database error: [MySQL server has gone away]
    SELECT wp_sfgroups.group_id, group_name, group_desc, group_rss, group_icon, group_message, forum_id, forum_name, forum_slug, forum_desc, forum_status, forum_icon, forum_rss_private, post_id, topic_count, parent, children FROM wp_sfgroups JOIN wp_sfforums ON wp_sfgroups.group_id = wp_sfforums.group_id ORDER BY group_seq, forum_seq;

    WordPress database error: [MySQL server has gone away]
    SELECT * FROM wp_sfgroups ORDER BY group_seq

    WordPress database error: [MySQL server has gone away]
    SELECT DISTINCT TOPIC_ID FROM wp_sfwaiting

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_sfmembers SET newposts = 'a:5:{i:0;s:1:"6";i:1;s:1:"7";i:2;s:1:"8";i:3;s:1:"9";i:4;s:2:"12";}' WHERE user_id=1

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_sfmembers SET checktime = '2010-05-19 14:29:56' WHERE user_id=1

    WordPress database error: [MySQL server has gone away]
    SELECT DISTINCT forum_id, topic_id FROM wp_sfposts WHERE topic_id=6 OR topic_id=7 OR topic_id=8 OR topic_id=9 OR topic_id=12 ORDER BY post_id DESC;

    WordPress database error: [MySQL server has gone away]
    SELECT DISTINCT forum_id, topic_id FROM wp_sfposts WHERE post_status = 0 ORDER BY post_id DESC LIMIT 15;

    WordPress database error: [MySQL server has gone away]
    SELECT * FROM wp_sfforums ORDER BY forum_seq

    WordPress database error: [MySQL server has gone away]
    SELECT COUNT(id) FROM wp_sftrack

    WordPress database error: [MySQL server has gone away]
    SELECT trackuserid, display_name, forum_id, topic_id FROM wp_sftrack JOIN wp_sfmembers ON wp_sftrack.trackuserid = wp_sfmembers.user_id ORDER BY trackuserid

    WordPress database error: [MySQL server has gone away]
    SELECT group_id, forum_id, topic_count, post_count FROM wp_sfforums ORDER BY group_id

    WordPress database error: [MySQL server has gone away]
    update wp_gdsr_data_article set views = views + 1 where post_id = 527

    WordPress database error: [MySQL server has gone away]
    select * from wp_gdsr_multis where auto_insert != 'none'

    WordPress database error: [MySQL server has gone away]
    SELECT * FROM wp_gdsr_data_article WHERE post_id in (527)

    WordPress database error: [MySQL server has gone away]
    select p.ID as ID, count(l.record_id) as counter from wp_posts p left join wp_gdsr_moderate l on l.id = p.ID and l.vote_type = 'article' and l.user_id = 1 where p.ID in (527) group by p.ID

    WordPress database error: [MySQL server has gone away]
    select p.ID as ID, count(l.record_id) as counter from wp_posts p left join wp_gdsr_moderate l on l.id = p.ID and l.vote_type = 'artthumb' and l.user_id = 1 where p.ID in (527) group by p.ID

    WordPress database error: [MySQL server has gone away]
    SELECT * FROM wp_sflinks WHERE post_id=527

    WordPress database error: [MySQL server has gone away]
    SELECT * FROM wp_wpsc_product_list WHERE display_frontpage IN('1') AND active IN('1')

    (located at http://www.creepyqueen.com/forum if you want to check it out)

    So after I had waited the 48 hour allotted time, the chat hosts finally referred me to tech support, I've been receiving emails the past two and half weeks from them telling me that I should deactivate my plugins, and reconfigure my 'wp-db.php' file.

    Now, I hadn't done anything to my website at this point. I hadn't even attempted add as much as a new post, let alone new plugins, so how could they all of a sudden cause problems?

    Either way, I still tried deactivating plugins - the forum page still doesn't work.

    The forum is what is causing the most problems, but members had just started posting in it before it crashed, and I spent a lot of time setting it up, and it was working and loading smoothly, right before the host upgrade- so I don't want to just delete it.

    I googled 'Wordpress database errors', and the only results I got were 'to check with the host' , or the sql isn't up to date or correct.

    At this point I'm tired of dealing with my host, and I am ready to just transfer my site to another, more reliable host. But I'm worried that if I do, this forum error and the slow-loading will come with it.

    I'm not going to pretend I know anything about the internet, so I really just need some help and suggestions about what i can do to get my site running smoothly.

    Thanks!

  2. James
    Happiness Engineer
    Posted 3 years ago #

    "MySQL server has gone away" means that the database server is crashing, which has nothing to do with you. I highly recommend switching to a different hosting provider, especially since your's is failing to acknowledge an obvious problem as their own.

  3. legedemon
    Member
    Posted 3 years ago #

    "MySQL server has gone away" doesn't mean that the database server is crashing. All it means is that the connection used to query the database has been lost. This can be due to a variety of reasons such as:
    1. Connection timing out.
    2. Query results taking too long (in which case some administrative process will kick you out).
    3. And MySQL crashing, of course.

    IMHO, if you keep transferring from host to host, you'll keep facing different kinds of problems. In my experience, it's better to work with one host and get your site to stabilize.

    Even in case your hosting provider is a total ass, I'd suggest that you follow this methodology to isolate your problem:

    1. Disable all plugins from your administrator console. Check if the page loads ok. If it does, it means that the problem is with one of the plugins. If it doesn't, trash your hosting provider immediately.

    2. If you have determined that the problem is with one of the plugins, proceed cautiously. Enable plugins whose names start with A. Recheck the page loading. If it's broken, one of these plugins is the reason.
    If it's not, proceed to enable plugins whose names begin with B and so on.

    3. I'm guessing that either you didn't reconfigure your wp-db.php or have since reverted back the fix because I can still see all these errors on your page. If reconfiguring your wp-db.php removed these errors, I'd recommend you to have it in place.

    4. Since you're running a forum using wordpress, I think you're using either bbPress or Simple-Press or some lesser known plugin. In that case, did you try asking these questions on the forums for these applications? Sometimes, it's just a simple setting change that can make all the difference.

    5. Also, a simple analysis of your page using Firebug tells me that you're using a number of plugins (I could make out gdsr, wp-e-commerce, wp-shopping-cart, sexy-bookmarks to name a few). It's again possible that multiple plugins are trying to read same tables in the database leading to these problems. In that case, step 2 can be more complex.

    Keep us posted so that we're able to help.

  4. Matthew Tommasi
    Member
    Posted 3 years ago #

Topic Closed

This topic has been closed to new replies.

About this Topic