Shipping Issue - Express Only

[serwachic]

Okay, changed the php code and when uninstalled - when I went to reinstall, got this message:

1062 Duplicate entry 'MODULE_SHIPPING_USPS_TYPES' for key 2
in:
[insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Domestic Shipping Methods', 'MODULE_SHIPPING_USPS_TYPES', 'EXPRESS, PRIORITY, FIRST CLASS, PARCEL, MEDIA, BPM, LIBRARY', 'Select the domestic services to be offered:', '6', '14', 'zen_cfg_select_multioption(array(\'EXPRESS\', \'PRIORITY\', \'FIRST CLASS\', \'PARCEL\', \'MEDIA\', \'BPM\', \'LIBRARY\'), ', now())]
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.


So I double checked to make sure I deleted the original PHP code, and I had. I'll check out the links dr. byte provided, and try that.

[serwachic]

Hmmm...even going back and trying to put my original code isn't working. Geesh, I feel like a doofus. If I copy the current code that I have, do you think you could tell me where I have the duplicate?

<SNIP>

[serwachic]

<code removed>

[serwachic]

< snip >

[DrByte]

Please don't post entire file contents ... it almost always isn't necessary ... plus it's VERY hard to read code that way.

[serwachic]

Sorry about posting all the scripts.

I did the SQL Query and sent it. Went to install the USPS module again, and got the same response.

[serwachic]

I ended up reposting my original usps file in order to clean up whatever I did wrong. Then I downloaded the latest patch and published that. All is well. Apparently I was using an old patch.

Thanks for all your help, and Bunyip, I really appreciate your patience!

[studio3d]

I had the same problem only my issue was that regardless of the choice picked, Priority would override it. I figured out that was because I didn't offer express. Thanks so much for this great post. It brings an end to more than 2 hours of debugging. I can only hope that others experiencing this problem find the same solution more quickly.

[DrByte]

Okay, changed the php code and when uninstalled - when I went to reinstall, got this message:

1062 Duplicate entry 'MODULE_SHIPPING_USPS_TYPES' for key 2
in:...

Something you've done has broken the normal operation of things.
Now you've got to do some ugly cleanup.

Start with this:

a) Admin->Tools->Install SQL Patches
b) Paste the following into the text field and click Send:

delete from configuration where configuration_key like 'MODULE\_SHIPPING\_USPS%';

c) Then go back to Admin->Modules->Shipping and click Install again.