[resolved] Connection Reset Error - Dont get it! (3 posts)

  1. CallMeAndy
    Posted 3 years ago #

    Editing a function in functions.php is causing a "connection reset" error on a page. But I cant see why this would be.

    I have made an error in an embedded SQL Script by including a "GROUP BY" in each query (a multisite aggregation) in a multi "UNION" Script.

    Of course the page was displaying, as all the script was doing was listing terms for a taxonomy aggregated across a mutisite.

    The taxonomy is "localities" so by having the "GROUP BY" in the individual queries I am getting two results for Europe etc (well in fact many, not two, as there are many blogs involved in the Union's)

    So I simply removed the "GROUP BY" element thus: (no other code changed)

    ...WHERE post_status = 'publish' AND post_type = 'post' AND t.taxonomy = 'localities' GROUP BY the_slug";

    changed to

    ...WHERE post_status = 'publish' AND post_type = 'post' AND t.taxonomy = 'localities'"; //GROUP BY the_slug";

    Gives the connnection reset error.

    I dont get it - can anybody advise me on this please.

  2. Chandan Kumar
    Posted 3 years ago #

    Can you share the whole query here?

  3. CallMeAndy
    Posted 3 years ago #

    OH sorry didnt see your response - I dont see the relevence to the wider code to be honest however ordinarily if you wanted to see it I would put it up for you. Unfortunatly in this instance the code has changed out of all recognition and I dont seem to have a backup of how it was at that point.

    I have marked this as resolved but in reality it was a workaround.

    Thanks for coming back to me anyway!

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.