Optional Shipping Insurance Module [Support Thread]

[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.

[LRS]

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

[mzimmers]

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

[LRS]

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)

[mzimmers]

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.

[joe.davila]

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.

[mzimmers]

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).

[joe.davila]

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.

[mzimmers]

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.)

[joe.davila]

Easy there.
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.