Thread

I am a licensed customer with EE 1.7.0 but wasn’t able to post in that forum so here goes…

I have several pages that just stopped working on my site.  They worked fine a few days ago and now they produce an HTTP 500 Internal error.

All pages belong to a weblog called “Sub-Ministry” that are related to another weblog via a Relationship field.  The parent weblog works fine, and many of the sibling entries in sub-ministries work fine.  It’s a select number of pages that are having this problem, and they are all using the same template.

Here’s an example:
http://bit.ly/hfbgQ2
Under “Stages of Life” click on anything under “Children” and you’ll get the error.  Anything under the other pages will work fine.

I have cleared the cache using the control panel as well as manually removing all subfolders in the system/cache directory but still have the problem.

This was an upgraded install from 1.6.7 several months ago but these pages worked fine up until a few days ago.
Thanks,

James.

[Mod Edit: Moved to the EE 1 Technical Support forum]

Hi, James. We’re not seeing a license attached to your username. Can you send an email to .(JavaScript must be enabled to view this email address) with your registration details? They’ll be able to help you get access to the right forums.

I will try to do this, but in the mean time do you have idea why I’m getting these HTTP 500 errors on these pages?  Have you heard of this happening to anyone else?  It’s not happening on the development site and many of the pages using the same template are working fine.

Thanks.

I e-mailed sales about this issue and am thinking I might have to purchase a new license because of it originally being owned by the site’s original designer (who can’t find the license) :( but that doesn’t mean I can still get support, right?

Why would I be getting random server errors on pages that are in my CP?  Has anyone else ever seen this or could I just have a corrupted set-up of EE that is causing these few pages to go bonkers?

James, we really need so sort licensing issues out first. If you’re doing work for a licensed site, that’s fine. Sales should be able to sort you out.

Ok have purchased the license and would like to re-open this discussion.  This is very critical that this gets addresses and I am willing to give CP and FTP access to your support personnel immediately to fix this problem.

Thank you.

James, do you have an entry with a url_title called awana?

Yes I do.
http://www.riverlakeschurch.org/index.php/subministry/awana/

There are 5 entries related the to “Children” ministry.
This has worked previously but just completely stopped working.  It’s only for the Children ministry that I get the HTTP 500 errors.

Thanks for helping 😊

Since it’s happening on just a single template, you’ll need to do the following:

Create a new template group for testing. In the new template group, put in just enough code to get the exp:weblog:entries code to show for a single entry. If that works, then gradually add back in your design elements and other parts of the template until you can figure out what caused it. It’s a slow process, but necessary.

You mentioned that this used to work. What changed? Did you add any third party add-ons? Did the version of PHP or MySQL change?

Does that help?

Found the problem.  It had to do with the order of a {/exp:weblog:entries} statement with another line of code- tried switching the order and now it’s Ok.

And this was not displaying:

{related_entries id="subministry-ministry"}
    {exp:query sql="SELECT COUNT(a.rel_parent_id) AS myCounter2 FROM exp_relationships a JOIN exp_weblog_data b ON a.rel_parent_id = b.entry_id WHERE a.rel_child_id='{entry_id}' AND b.weblog_id='8'"}
        {if myCounter2 == 0}
            <li><h5>» <a href="http://{path=">View All Announcements</a></h5><p></li><br />
        {if:else}<br />
            {exp:query sql="SELECT a.rel_parent_id FROM exp_relationships a JOIN exp_weblog_data b on a.rel_parent_id = b.entry_id WHERE a.rel_child_id='{entry_id}' AND b.weblog_id='8'"}<br />
                {embed="includes/side_rt_submins_announcements" announcement_id="{rel_parent_id}"}<br />
            {/exp:query}                                <br />
        {/if}<br />
    {/exp:query}                    <br />
{/related_entries}

Changed it to this and it worked.

{related_entries id="subministry-ministry"}
    {exp:query sql="SELECT COUNT(a.rel_parent_id) AS myCounter2 FROM exp_relationships a JOIN exp_weblog_data b ON a.rel_parent_id = b.entry_id WHERE a.rel_child_id='{entry_id}' AND b.weblog_id='8'"}
        {if myCounter2 == 0}
            <li><h5>» <a href="http://{path=">View All Announcements</a></h5><p></li><br />
        {/if}<br />
        {exp:query sql="SELECT a.rel_parent_id FROM exp_relationships a JOIN exp_weblog_data b on a.rel_parent_id = b.entry_id WHERE a.rel_child_id='{entry_id}' AND b.weblog_id='8'"}<br />
            {embed="includes/side_rt_submins_announcements" announcement_id="{rel_parent_id}"}<br />
        {/exp:query}<br />
    {/exp:query}                    <br />
{/related_entries}

(If you think of a better way to do that let me know)

Re-adding the template piece by piece did the trick.  Thanks for the assistance!

James, glad things are working again.. Feel free to start a new thread if you have any more questions.