USPS woes Pls Help

[Guest]

I have installed the latest contribution to update the USPS module. I believe I have done everything correctly. When I go to install the usps module it loads ok and everything looks correct all domestic and new Itnl shipping methods are there. But when I go to edit to enter my ID and PW only the check boxes for domestic show up and nothing under international.

 

Have I done something wrong....possibly in executing the SQL (because it is all new to me)

[kellbot]

I have installed the latest contribution to update the USPS module. I believe I have done everything correctly. When I go to install the usps module it loads ok and everything looks correct all domestic and new Itnl shipping methods are there. But when I go to edit to enter my ID and PW only the check boxes for domestic show up and nothing under international.

 

Have I done something wrong....possibly in executing the SQL (because it is all new to me)

 

 

Most likely what happened is the "set_function" field was truncated when you entered your sql commands (since the string provided in the fix is too long for some setups).

 

you'll need to go in and edit the "set_function" field so it has a trailing ")," which will bring back your check boxes. This may require shortening the list of shipping options to fit within the field (or using a larger data type).

 

I changed my set_function to the following, and it works now:

 

tep_cfg_select_multioption(array('Global Express', 'Express Non-Doc Non-Rect', 'Express Mail Int', 'Express Mail Int Flat Rate Env', 'Priority Mail Int', 'Priority Mail Int Flat Rate Env'),

[ramstainedglass]

Most likely what happened is the "set_function" field was truncated when you entered your sql commands (since the string provided in the fix is too long for some setups).

 

you'll need to go in and edit the "set_function" field so it has a trailing ")," which will bring back your check boxes. This may require shortening the list of shipping options to fit within the field (or using a larger data type).

 

I changed my set_function to the following, and it works now:

 

tep_cfg_select_multioption(array('Global Express', 'Express Non-Doc Non-Rect', 'Express Mail Int', 'Express Mail Int Flat Rate Env', 'Priority Mail Int', 'Priority Mail Int Flat Rate Env'),

 

 

Please help. I received code from USPS but I have no idea where it is supposed to go. In usps.ph? What lines do you take out and replace?

[kurtar]

Most likely what happened is the "set_function" field was truncated when you entered your sql commands (since the string provided in the fix is too long for some setups).

 

you'll need to go in and edit the "set_function" field so it has a trailing ")," which will bring back your check boxes. This may require shortening the list of shipping options to fit within the field (or using a larger data type).

 

I changed my set_function to the following, and it works now:

 

tep_cfg_select_multioption(array('Global Express', 'Express Non-Doc Non-Rect', 'Express Mail Int', 'Express Mail Int Flat Rate Env', 'Priority Mail Int', 'Priority Mail Int Flat Rate Env'),

 

Many thanks kellbot - that worked perfectly for me... Regards, Kurt