After update, all states taxed

[RixStix]

Performed the update to V1.5.3 yesterday.

First order calculated and charged sales tax for a state where there is no tax rate.

We only charge sales tax for Idaho. First order was from PA and the Idaho tax rate was used.

No setup changes were made when importing the v1.3.9H database into v1.5.3.

I didn't read anything about needing to revisit those settings and assumed the update would keep the previous settings.

Install v1.5.3 & verify functionality
Drop v1.5.3 DB & import v1.3.9h DB
Drop table prefix
Run zc_install to update DB to v1.5.3
Verify basic functionality.
convert charset from latin1 to utf8

Proceed to install new template and plugins.

Wake up this morning with first order showing sales tax charged to PA customer.

[Ajeh]

If you look at your Zone Definitions, what do you see in the DETAILS for you Idaho Tax Zone?

[RixStix]

Zone definitions:

Idaho
International
USA

No IOWA

All are RED dot status

[RixStix]

I just noticed

when looking at admin/customers/customers

WARNING: An Error occurred, please refresh the page and try again.

appears at the top of the screen.

And the typical customer info details box that usually appears to the right, is not present.

[lat9]

Hmm, that doesn't happen in my ZC v1.5.3 test installation; what's been logged (remember that admin-level logs might include your admin folder name)?

[RixStix]

Going to look right now.

It appears to function as expected in my sandbox.

The only difference is that when making the move to the live site, I used the v1.5.3hotfix installer.
Then copied all the files from the functional sandbox which contained the mods.

Brainfart, possibly

[Ajeh]

Go to Locations / Taxes ... Zones Definitions ... and for Idaho click on the DETAILS ... what do you have set?

You should see:
Country: United States
Zone: Idaho

If not, you need to set the DETAILS of the Zone Definition for it to work ... the red dot means the Zone is not defined so you will get everything ...

[RixStix]

Logfile probably indicates an OOPS or overlooked edit when moved from sandbox to live

[04-Aug-2014 07:18:36 America/Los_Angeles] PHP Fatal error:  1054:Unknown column 'EMP_LOGIN_ADMIN_PROFILE_ID' in 'where clause' :: SELECT admin_profile, admin_pass from admin WHERE admin_id = 1 AND admin_profile IN (EMP_LOGIN_ADMIN_PROFILE_ID) ==> (as called by) /home/chainwea/public_html/ADMIN/customers.php on line 1211 <== in /home/chainwea/public_html/includes/classes/db/mysql/query_factory.php on line 155

[RixStix]

Go to Locations / Taxes ... Zones Definitions ... and for Idaho click on the DETAILS ... what do you have set?

You should see:
Country: United States
Zone: Idaho

If not, you need to set the DETAILS of the Zone Definition for it to work ... the red dot means the Zone is not defined so you will get everything ...

Something is not quite right since I didn't have to do anything when working with my sandbox installation.
Surely a brainfart on my part when things moved.

Will making these edits potentially compound the issues if caused by a glitch during my upgrade?

[Ajeh]

It shouldn't ... right now it appears all of your Zone Definitions have no DETAILS set on them so none of them will work ...