Local Sales Tax Mod - Support Thread

[zcnb]

Thank you very much! This is clear now.

Unfortunately however, it seems that I was too quick to declare that I installed without any problem. Now that I try to do a test checkout, I receive the following in step 2 of 3 (Payment Information):

Your Total
1146 Table 'zc_store.TABLE_LOCAL_SALES_TAXES' doesn't exist
in:
[select local_tax_id, zone_id, local_fieldmatch, local_datamatch, local_tax_rate, local_tax_label, local_tax_shipping, local_tax_class_id from TABLE_LOCAL_SALES_TAXES where zone_id = '']

Have you seen this before? What could be causing this?

[zcnb]

Just in case the following could be helpful in diagnosing the above problem: I suspected the the table that was supposed to be created by running LocalSalesTaxv2.2.sql wasn't really created.

I decided to re-run it (via the edit box (copy & paste) because the 'upload file' doesn't really work) and I received the following which looked familiar from the first run (which I mistook for a non-failure):

Query Results:
CREATE TABLE tax_rates_local ( local_tax_id int(11) NOT NULL auto_increment COMMENT 'tax id', zone_id int(11) default NULL COMMENT 'zen cart zone to apply tax', local_fieldmatch varchar(100) default NULL COMMENT 'name of field from delivery table to match', local_datamatch text COMMENT 'Data to match delievery field', local_tax_rate decimal(7,4) default '0.0000' COMMENT 'local tax rate', local_tax_label varchar(100) default NULL COMMENT 'Label for checkout', local_tax_shipping varchar(5) default 'false' COMMENT 'Apply this tax to shipping', local_tax_class_id int(1) default NULL COMMENT 'Apply to products in what tax class', PRIMARY KEY (local_tax_id) );

Any idea what I could be doing wrong?

Update: wait a minute... I didn't see the top pink bar containing the error message. It says:

Failed: 1
Error ERROR: Cannot create table tax_rates_local because it already exists
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

[LadyHLG]

Check your database to be sure the table is there and it is named correctly with whatever table prefix you have chosen (if any).
LadyHLG

[KathyM]

Check your database to be sure the table is there and it is named correctly with whatever table prefix you have chosen (if any).
LadyHLG

I've just installed this mod--thanks! Being from NY has made collecting sales tax a nightmare... my issue:

When I goto Local Sales Taxes I get this messsage (like another poster):

~~~~~~~~~~~
1146 Table 'chargeshop.tax_rates_local' doesn't exist
in:
[select count(*) as total FROM (tax_rates_local st LEFT JOIN tax_class tc ON st.local_tax_class_id = tc.tax_class_id) LEFT JOIN zones z ON st.zone_id = z.zone_id]
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.
~~~~~~~~~~~

I have no other modules installed, just Zen Cart 1.3.8a.

Was the quote above for fixing this problem? If so, I still don't know what I should do. Would you please explain it a bit more? Thanks!

[LadyHLG]

It looks like the mod can't find the table. Did you have any probelms with the sql install? You need to verify that the table actaully exists in the database.
LadyHLG

[KathyM]

Thanks for the quick response!


I wasn't sure if it installed correctly, but it showed up in the drop down menu so I thought it must have. Is there somewhere I can go to dwonlad that table, then a spot I should put it in on the ftp? Or another type of fix? I looked for a way to unistall to try again but couldn't figure it out.

[LadyHLG]

As part of the mod there is a folder called
FullVersion\sqlfiles\NewInstall
With a file called LocalSalesTaxv2.2.sql
You need to use the cart admin Install SQL Patches to run the sql file and create the table.

[Kokopelli628]

LadyHLG,

That did the trick!

Thanks so much!!

[zcnb]

Update: baffled by the mismatch by the table names (TABLE_LOCAL_SALES_TAXES vs. tax_rates_local) I tried to see where that TABLE_LOCAL_SALES_TAXES could possibly come from. I found two places in which TABLE_LOCAL_SALES_TAXES should be substitued by 'tax_rates_local'

define('TABLE_LOCAL_SALES_TAXES', DB_PREFIX . 'tax_rates_local'); 

That led me to find what my problem was: I forgot to upload one file: [FONT="Courier New"]/includes/extra_datafiles/ot_local_sales_taxes_databse_tables.php[/FONT]


See what I mean by "applying patches manually is error prone"?

I wish there were a way to unpack the entire package into the directory structure in one step. Something like 'tar -xvf LocalSalesTaxModv2.2.tar'.

Thanks again for your great mod. Now I am going to check the correctness for the calculations.

[zcnb]

Unfortunately, this mod seems to be not working for me. I repeated all steps properly this time - from the beginning (on a test store of course) - but I keep getting calculations as if no local sales tax is defined.

I mean, everything works just as before: State tax is applied but the local sales tax is simply not there:

Your Total
      Sub-Total: $1.98
  Free Shipping: $0.00
State Sales Tax: $0.12
          Total: $2.10

Shouldn't there be another line for local sales tax?

What could have I done wrong in installing/configuring this mod?