• Some background.
    Two weeks ago the website I am working on and hosted at Go Daddy worked.
    Last week it started to exhibit the problem.
    I have a development site hosted by Host Papa and it works.
    WordPress, Themes and All Plugins are up to date.
    I contacted my SOLDPress plugin developer to report a problem about a specific search not returning any results. They troubleshot the problem and found it to be an Error #2013 Lost connection to MySQL server during query.
    The Plugin developer gave me the following SQL query to run directly through the cPanel phpMyAdmin.
    At Go Daddy, I tried this 20 times, once it worked, with all other failures happening somewhere past 30 seconds. At Host Papa it runs fast, typically 2 seconds or less and it never fails.

    My plugin developer is telling me that it’s not his problem, and Go Daddy responded to tell me that they don’t troubleshoot client code.

    If some kind soul could offer some input, how to troubleshoot this further, possibly configuration changes I may be able to make or what have you, I would appreciate it.

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
    INNER JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id) WHERE 1=1 AND wp_posts.post_type = ‘sp_property’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘private’) AND ( (wp_postmeta.meta_key = ‘dfd_ListPrice’ AND CAST(wp_postmeta.meta_value AS SIGNED) > ‘0’)
    AND (mt1.meta_key = ‘dfd_ListPrice’ AND CAST(mt1.meta_value AS SIGNED) BETWEEN ‘0’ AND ‘900000’) ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 12

Viewing 1 replies (of 1 total)
  • At Go Daddy, I tried this 20 times, once it worked, with all other failures happening somewhere past 30 seconds. At Host Papa it runs fast, typically 2 seconds or less and it never fails.

    That’s all you need to know. GoDaddy is an abysmal host. Their database servers are overloaded and time out.

    Find a better production site host.

Viewing 1 replies (of 1 total)
  • The topic ‘Go Daddy MySQL error 2014 SOLDPress plugin’ is closed to new replies.