response to creeperkat, jeremy7786, wickedstangs, perhaps others:
Regarding the message displayed on the Order Total section of the checkout process that reads "select zip from local_zips where zip='#####'" where ##### is a zip code:
First, if the message also mentions "does not exist" then do as DrByte mentions: verify that your local_zips table has been installed in your database. If you have a unique table prefix, you must go through the code in includes/modules/order_total/ot_zip_tax.php and add the prefix to every instance of 'local_zips'. For instance, I use the characters"as" for the prefix to my tables so I changed each instance of 'local_zips" to 'as_local_zips'.
This should eliminate the "does not exist" message, however you may still get the rest of the message ("select zip from local_zips where zip='#####'). If you would like to remove this message from your displays then open the following file in an editor:
Code:
file: includes/modules/order_total/ot_zip_tax.php
Find the following lines:
$selstr = "select zip from local_zips where zip='$zip'";
echo $selstr;
Change to:
$selstr = "SELECT zip FROM local_zips WHERE zip='$zip'";
// echo $selstr;
That should clear it up.
Also, I found an error in the included readme.txt file for this contribution:
In the instructions "to install the database version:" in step 3 there are two files you should copy to your store. The second one reads includes/modules/ot_zip_tax.php when it should read includes/modules/order_total/ot_zip_tax.php.
It's possible a similar error appears in step 2 of the instructions "to install inline zip version" but I didn't use that method so have not verified it as an error.
Once I made the above changes I found this contribution to work very smoothly.
Ron
Bookmarks