Optional Shipping Insurance Module [Support Thread]

I need some help here please. I cannot seem to get rid of this:

Warning: constant() [function.constant]: Couldn't find constant MODULE_ORDER_TOTAL_INSURANCE_ZONE_2 in xxxx/includes/modules/order_total/ot_insurance.php on line 43

I read where another member had the same thing and they uninstalled the sql patch and re-installed. I do not know how to uninstall the patch. :blink:
Can someone let me know what I need to put in the sql patch area to uninstall the table from the database so I can have the error above removed from the admin side.

Thanks

I have no idea what I am doing wrong. I am trying to install this so it gives the option to add an extra $2.30 to the order if they would like insurance. I don't ever want it to be required.

I just can't get it to work. Can someone help?

This is what I have:

Shipping Insurance

Enable Insurance Module
true

Sort Order
1

Use Table Rates?
false

Alternate Insurance Type
amount

Insurance Percentage
0

Insurance Rate
$2.30

Increment Amount
$1,000.00

Amount Exempt From Fee
$1.00

Tax Class
--none--

No Insurance Fee on Virtual Products
true

No Insurance Fee on Gift Vouchers
true

No Insurance Fee on Free Shipping
true

Required Insurance Amount
$10,000.00

Insurance Zone 1
--none--

Zone 1 Insurance Table

Please, can someone help? Where is the support for this mod?

I have searched all day for answers, maybe someone can help. I am looking to restrict First Class International Mail and Priority International Mail by the price of the transaction.

I want to set these restrictions: If a customer is spending $100 or less First Class International Mail (lessen the $ risk on non-tracking packages) can be used, over $100 it cannot. Likewise, Priority International Mail is available for orders under $400, but not for over $400. USPS doesn't not allow Priority International Mail to have declared values over $400. This would mean an international customer would have to use Express International Mail for orders over $400.

It seems someone would have had this answered somewhere or posted something close but I have found nothing. I have received orders for items totaling over $400 and had to upgrade the shipping to Express at my cost so I could document the customs documents properly. If I would have sent the items Priority International Mail I would have had to max out the package contents at the $400 limited cap.

Anybody using this mod with Paypal Express Checkout?

All my orders that include optional insurance and pay with Paypal Express drop their item descriptions (Product Name and Product Model) in paypal receipt emails, and transaction histories. PPE sees the insurance fee as a credit and does not submit the line items to paypal. Only the Total amount is carried over to paypal.

I thought this was a Paypal Express bug, so I started this thread in the paypal express forum

Thanks to Dr. Byte I was able to quickly find out this issue is due to this mod.

I was using the older version 3.13 from 5/2008 so I downloaded and installed the newest version of Optional insurance 3.2.0, today and tweaked all the settings but still see this issue.

Is it just my cart? or does everyone have this issue?

Did this get resolved? I wasn't getting this error message, but I am now. Not sure what to do.

perkiekat:

I need some help here please. I cannot seem to get rid of this:

Warning: constant() [function.constant]: Couldn't find constant MODULE_ORDER_TOTAL_INSURANCE_ZONE_2 in xxxx/includes/modules/order_total/ot_insurance.php on line 43

I read where another member had the same thing and they uninstalled the sql patch and re-installed. I do not know how to uninstall the patch. :blink:
Can someone let me know what I need to put in the sql patch area to uninstall the table from the database so I can have the error above removed from the admin side.

Thanks

OK, after a bit of experimentation, I discovered that removing the module (through admin) and installing it again solved this problem for me. Hopefully, it will for you as well.

I just started getting this error as well as of a couple weeks ago. I'll uninstall the mod and reinstall and hope that fixes mine as well.

Warning: constant(): Couldn't find constant
MODULE_ORDER_TOTAL_INSURANCE_ZONE_3 in
/home/content/a/v/e/avenuebeads/html/includes/modules/order_total/ot_insurance.php
on line 43

Warning: Cannot modify header information - headers already sent by (output
started at
/home/content/a/v/e/avenuebeads/html/includes/modules/order_total/ot_insurance.php:43)
in
/home/content/a/v/e/avenuebeads/html/includes/functions/functions_general.php
on line 44

AvenueBeads:

I just started getting this error as well as of a couple weeks ago. I'll uninstall the mod and reinstall and hope that fixes mine as well.
This will happen if you add a new zone after enabling the module

Any tricks to getting this to work on 3.9b?

I installed it after an upgrade from 3.8x to 3.9b, then removed it / reinstalled, no go.

Uploaded files again, installed, no go. removed / reinstalled, no go.

Nothing shows up in the shopping cart, no errors given.

No tricks needed here...it just continued to work. Hard to speculate on what your problem is given the limited information, but...I'd venture it's not 1.3.9b.

mzimmers:

No tricks needed here...it just continued to work. Hard to speculate on what your problem is given the limited information, but...I'd venture it's not 1.3.9b.

Not sure what more information I need give you that would help determine why it doesn't work...... I did a new install of 3.9b in a new folder, imported the database from 3.8x, updated the database, installed the FedEx shipping module and the Shipping insurance module. The FedEx module works after removing it / reinstalling as suggested by someone else but the shipping insurance module doesn't work after repeated remove / install / upload files / remove install processes.

Nothing 'shipping insurance' related shows up at checkout. Anyone else have any tips?

Thanks

Does it show up in Modules->Order Totals? Do you have it enabled there? Did you set up your zones?

mzimmers:

Did you set up your zones?

I didn't have zones set up in the shipping insurance module in 3.8x (There was no option listed in that version for zones) and it worked fine, so I left it that way in 3.9b.

I added all the zones just now with zero percent tax and it is working. Previously it was only working for the one state zone I had installed for sales tax purposes as it was in 3.8x.

Thanks

FYI, there are two blank data entry boxes at the bottom of the shipping insurance module options menu that have no descriptive text near them. Any ideas what might be causing that? (After Zone 1 Insurance Table)

I can't speak to 1.3.8 and Shipping Insurance, but on my site, I needed to create a few zone definitions (as distinct from zones) and put them into my configuration of the insurance module, along with the rates for those particular zones. (Perhaps you can make do with only one zone definition; I needed one for the USA, another for Canada, and a third for all other countries I'm willing to ship to.) I don't think the module will work without these being defined.

Where are the instructions to install this module? I've uploaded ot_insurance to the appropriate folder but I don't see it in the admin console to install it. Also, when I tried to run the sql patch that came with it for zone information, I got an error saying that a primary key violation had occurred and the information could not be loaded.
If someone could please point me in the right direction that would be great.

I've installed plenty of zen cart ad-ons, but this one didn't come with instructions.

Did you look on numinix' support thread?

http://www.numinix.com/forum/viewtopic.php?t=23

I think there's some information there on installation.

I too struggled with this module. You'll see some of my posts towards the end of that thread on the numinix site.

I'm not sure this will solve it, but when you ran the SQL patch, did you upload the file, or cut its contents and paste them into the window in your admin area? The latter approach seems to work better with some SQL patches (may be a file type issue or something).

Thanks I will check it out. I managed to install the file to the proper locations in languages and modules.

I tried to copy and paste the code after the uploading didn't work and got the same error message:

1062 Duplicate entry '20' for key 'PRIMARY'
in:
[INSERT INTO geo_zones (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added) VALUES (20, 'International', 'All Countries/Zones', NULL, '2007-12-30 20:26:59');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Hmm...well, what I know about SQL could fit into a thimble with plenty of room for a finger, but it sounds like the installation already "took," at least partly. Did you get this error message the first time you tried the patch? You might try dropping the table and running the patch again. (Proceed with caution.)

Easy there. :blink:
I have all my tax rates set up in those tables. I don't want to wipe them out. I think it's just coincidence but Iowa has the geo_zone_id of 20, that's why the insert fails.

Do you know if the reference to 20 in the sql patch can be changed to a different number (one that is not yet in use in my zone and tax rate tables?

If I can simply change the value to 200, let's say, then I could insert the values without any issue. I just don't know if 20 is referenced somewhere in the code for the insurance module.