Internal Error 500 on checkout success page - Numinix Optional Insurance Module

Hello all,

I have placed test orders with my site and now every time I come to the checkout success page, I get a very ambiguous error message. It is when I choose to pay via money order and it doesn't matter if I choose a shipping option or pickup. I wiped out the checkout_success page and reinstalled the original code, but it didn't seem to make a difference. On my Admin page, the only thing I put in was "thanks for shopping here" and my logo.

any ideas???

Thanks~
April

See the "Similar Threads" section at the bottom of this page for related discussions.
There's also an FAQ article on the topic you mention.

I looked thru some of the posts here, and re-uploaded every file I could...I can't seem to find anything else on this in the FAQ. I know one person mentioned it was an invalid email address causing the issue, however I am using a secondary email address of mine so I know it works.

I am at my wits end here :censored:

The confirmation email is still being sent & received at the destination address, and when I refresh the page it tells me my cart is empty. There are no other issues with site either :(

Thanks for any help you could give me.

April

The details of a "500 Internal Server" error should be logged in the server's apache logs. Contact your hosting company to obtain that information. Without that, one can only speculate.

Test using the Classic template. What happens then?

Using a rewrite module for your urls? A checkout module?

~Melanie

Ok! I found the debugging module and uploaded it (thx it worked!!!) i am running 1.3.8 and installed the Optional Insurance Module.

I set myself up as a customer in the US with a valid email.

this is the error I received during checkout success:

PHP Warning: constant() [<a href='function.constant'>function.constant</a>]: Couldn't find constant MODULE_ORDER_TOTAL_INSURANCE_ZONE_2 in /home/knott9/public_html/zencart/includes/modules/order_total/ot_insurance.php on line 43

This is how that module reads:

<?php /** * Order Total Module * * * @package - Optional Insurance * @copyright Copyright 2007 Numinix Technology <http://www.numinix.com> * @copyright Copyright 2003-2007 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license <http://www.zen-cart.com/license/2_0.txt> GNU Public License V2.0 * @version $Id: v2.10 12/28/2007 19:40:59Z numinix $ */ if ($_SESSION['shipping']['id'] == 'storepickup_storepickup') { class ot_insurance extends base{ function process() { } } } else { class ot_insurance { var $title, $output, $num_zones, $enabled, $dest_zone; function ot_insurance() { global $order, $currencies, $db; $this->code = 'ot_insurance'; $this->title = MODULE_ORDER_TOTAL_INSURANCE_TITLE; $this->description = MODULE_ORDER_TOTAL_INSURANCE_DESCRIPTION; $this->enabled = ((MODULE_ORDER_TOTAL_INSURANCE_STATUS == 'true') ? true : false); $this->sort_order = MODULE_ORDER_TOTAL_INSURANCE_SORT_ORDER; $this->credit_class = 'true'; $this->output = array(); $geozones = $db->Execute("SELECT * FROM " . TABLE_GEO_ZONES); $this->num_zones = $geozones->RecordCount(); if ($this->enabled == true) { $this->dest_zone = 0; for ($i=1; $i<=$this->num_zones; $i++) { if ((int)constant('MODULE_ORDER_TOTAL_INSURANCE_ZONE_' . $i) > 0) { $check = $db->Execute("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . constant('MODULE_ORDER_TOTAL_INSURANCE_ZONE_' . $i) . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id"); while (!$check->EOF) { if ($check->fields['zone_id'] < 1) { $this->dest_zone = $i; break; } elseif ($check->fields['zone_id'] == $order->delivery['zone_id']) { $this->dest_zone = $i; break; } $check->MoveNext(); } // end while } // END if ((int)constant('MODULE_ORDER_TOTAL_INSURANCE_ZONE_' . $i) > 0) } // END for ($i=1; $i<=$this->num_zones; $i++) if ($this->dest_zone < 1) { $this->enabled = false; } } I have set up USPS insurance in my store as Zone 2 with no tax zone. it specifies that only US residents (all states) are in this Zone 2. Is there something I'm forgetting to do? Thanks for all your help :smile: April

I'm pretty sure it's the zones that are screwing me up. I've uninstalled and reinstalled after adding the zone, with the same results!

If you uninstall the module and then do a checkout, does the error stop?

No, it doesn't. That's what's so frustrating! I still get the same 500 error...have checked, reinstalled several pages (checkout process, success, etc.). I have to offer insurance-I sell jewelry and do not want to be responsible if a package gets lost or damaged during delivery.

I even tried an earlier version of the insurance module, did all my de/re installs, and now the error message that shows up in debug does not now appear in my admin...

Are you using the FEC mod?

Reason I ask, is I think the opt ins is not built in to the FEC... so adding "again" could make big troubles.

I was going to check by hand, but you are collecting everything but DNA on your registration form :(

~Melanie

What is FEC mode?:dontgetit

Boy, am I the world's biggest DUMBASS! :blush:

I should have known...the insurance mod is working fine. I was wondering why all the errors weren't showing up but I was still getting the 500 IS message. I didn't have my email set correctly (smtpauth). That's why the orders were being processed and and email going to the customer worked, but the checkout success wasn't.

Thanks for your PATIENCE and endeavor to help...as always I appreciate the knowledge of this forum.

Everyone have a great day!!!

April