Post Office CASS Address Verification module

[VioletEye]

I can't install this module--

when I tried to use the uploader in the patch section, I got a syntax error. (I apologize for not having the wherewithal to actually copy it)

On a second try, I got a duplicate entry error:

1062 Duplicate entry 'USPS_CASS_USER_ID' for key 2
in:
[INSERT INTO zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('USPS CASS User ID', 'USPS_CASS_USER_ID', '', 'Your user id for the CASS API as provided by the USPS.', 7, 20, 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.

Can anyone help me out with this? I tried version 1.2.
Thanks.

[deere20]

Hi,

Anyone using the CASS usps address validator shipping module successfully ?

It's the one at -
http://www.zen-cart.com/forum/showthread.php?t=115744

I've installed but when it goes to confirm the shipping address, I get a zen '404 page not found'.

Thanks

[deere20]

I've installed this module, but when it goes to display the shipping address warning (index.php?main_page=checkout_shipping_address_warning), I get a zen 404 page not found ...

[JMatthewGore]

I can't install this module--

when I tried to use the uploader in the patch section, I got a syntax error. (I apologize for not having the wherewithal to actually copy it)

On a second try, I got a duplicate entry error:

1062 Duplicate entry 'USPS_CASS_USER_ID' for key 2
in:
[INSERT INTO zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('USPS CASS User ID', 'USPS_CASS_USER_ID', '', 'Your user id for the CASS API as provided by the USPS.', 7, 20, 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.

Can anyone help me out with this? I tried version 1.2.
Thanks.

The exact same thing happened to me today. I was installing this so that I could reliably use the local tax codes for WA state, which require the +4 zip codes.

I don't get a "Enable CASS Address Validation" in Shipping/Packaging as the readme.txt indicates I should, although there is a place to enter the CASS Username.

When I go through the checkout process, there is no indication that anything is different than pre-installation of this mod. No errors, but also no functionality.

I'm using Zen Cart 1.3.8a, minimal modification at this point, but the USPS Shipping module is active.

Would appreciate any help!

- Matt

[JMatthewGore]

This is the error message from ZenCart:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '·, NULL, 'zen_cfg_select_option(array(''true'', ''false''), ' )' at line 1
in:
[INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function) VALUES ( 'Enable CASS Address Validation', 'USPS_CASS_ENABLED', 'true', 'Toggle the USPS CASS Address checking module.', 7, 21·, NULL, 'zen_cfg_select_option(array(''true'', ''false''), ' );]
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.

[JMatthewGore]

FARK! Just took the time to inspect the error message a little more closely and I saw the little dot next to the "21". I removed the dot and it installed.

- Matt

[JMatthewGore]

OK, let me start over and explain the problem, how I made it worse, how I made it better, and how I resolved it.

1. Tried to upload the SQL Patch and got a syntax error. "

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '·, NULL, 'zen_cfg_select_option(array(''true'', ''false''), ' )' at line 1
in:
[INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function) VALUES ( 'Enable CASS Address Validation', 'USPS_CASS_ENABLED', 'true', 'Toggle the USPS CASS Address checking module.', 7, 21·, NULL, 'zen_cfg_select_option(array(''true'', ''false''), ' );]
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.

2. Thought that it might be a problem caused by uploading the file rather than copying and pasting, so I copied the whole thing and pasted it into the SQL Patch pane and submitted it. That got me the error listed by VioletEye.

3. So, I realized that the first half of the patch had installed correctly on the first try, it was just the second that was a problem, so I copied that and pasted it, and stopped getting the Duplicate Error, but got the Syntax Error instead.

4. Looked at the syntax (finally!) and found an extra dot next to "21" and deleted it, then copied the second half of the code into the patcher, and it worked just fine.

The syntax is an error in the 1.2 release, so hopefully the author will notice this post and fix it!

- Matt

[Stamper]

I'm having problems with this module.

Using Zen Cart 1.3.8a

I received the API access confirmation from USPS. USPS sent the email indicating I'm enabled for their production server. The user ID and enable CASS fields appear in my MySQL database after installation. The includes files appeared to copy over to my installation OK. However, address validation does not occur in my Zen Cart site (yes, it is enabled and user ID added in the Admin Panel).

Can anyone suggest what the problem may be? Are there any known compatibility issues with certain templates or other mods?

Thanks!

[jasmel]

Is there supposed to be something in this folder?

CASSValidation_v1.2\includes\modules\pages\checkout_shipping_address_warning\

[jasmel]

4. Looked at the syntax (finally!) and found an extra dot next to "21" and deleted it, then copied the second half of the code into the patcher, and it worked just fine.

The syntax is an error in the 1.2 release, so hopefully the author will notice this post and fix it!

- Matt

Same error here. Just had to remove the · after the 21

INSERT INTO configuration (configuration_title, 
						   configuration_key,
						   configuration_value,
						   configuration_description, 
						   configuration_group_id, 
						   sort_order, 
						   use_function, 
						   set_function) VALUES (
						   'Enable CASS Address Validation', 
						   'USPS_CASS_ENABLED', 
						   'true', 
						   'Toggle the USPS CASS Address checking module.', 
						   7, 
						   21·,
						   NULL, 
						   'zen_cfg_select_option(array(''true'', ''false''), '
						   );