Local Sales Tax Mod (with admin!) for testing

[jaylyns]

Please help!!!! I uploaded all the files and tried to run the sql file patch and it said failed. What do I do now? Don't even know where to begin. Tried to upload the files again same error. Could it be because of the override system or customer template? Please help me get this working.

My site is www.jaylyns.com. Warning: this site sells products of adult nature.

Thanks for anyone's help.

[LadyHLG]

I need to know more about what you are trying to do. Is this an upgrade? What version of zen are you using? Have you tried to apply the sql directly to the sql server instead of through zen?

LadyHLG

[jaylyns]

I need to know more about what you are trying to do. Is this an upgrade? What version of zen are you using? Have you tried to apply the sql directly to the sql server instead of through zen?

LadyHLG

This is a new install. I am using version 1.3.8a of zen cart. Not sure how to apply the sql directly to the sql server. Have only done it through zen.

[LadyHLG]

I zen giving you anything more than just the sql failed?

[jaylyns]

No it wasn't. I did find out how to run it through my sql server. And that made it show up under modules>order total. I installed it there. However when I went to the next step locations/taxes>local taxes I get the following error.

1146 Table 'jaylyns_zc1.zen_tax_rates_local' doesn't exist
in:
[select count(*) as total FROM (zen_tax_rates_local st LEFT JOIN zen_tax_class tc ON st.local_tax_class_id = tc.tax_class_id) LEFT JOIN zen_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.

[LadyHLG]

Sorry its a little late and I forgot to tell you that you need to make sure that if you run the sql directly on the server not to forget to add the zen prefix to the table name. Do you know how to change the table's name on the server to add the prefix to the name? That is what is causing the problems.
LadyHLG

[jaylyns]

Yes I can rename it. Is that the only table I have to rename?

[LadyHLG]

Yes, there is only one.

[jaylyns]

thank you so much for your help. Working now. Although it adds the zip code to the begining of the description and percentage to the end durring check out. Is there a way to make it hide the zip in front? Not too worried about the percentage but looks funny with the zip in front. Thanks again.

[LadyHLG]

You have to edit the following file
\includes\modules\order_total\ot_local_sales_taxes.php

Go to line 128 and look for the following:

$ot_local_sales_taxes_rate_description = $ot_local_sales_taxes_rate_description . " " .$myfield;

Comment out the line by putting two slashes in front of it like this:

//$ot_local_sales_taxes_rate_description = $ot_local_sales_taxes_rate_description . " " .$myfield;

That will remove the zip code from the front of the sales tax line.

LadyHLG