Forums / All Other Contributions/Addons / SQL update for Tax Exempt Status module

SQL update for Tax Exempt Status module

Locked

Started by themusician on 9 Jul 2007, 6:07 PM · Views: 1,948

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
9 Jul 2007, 6:07 PM
#1
themusician avatar

themusician

New Zenner

Join Date:
Jun 2007
Posts:
64
Plugin Contributions:
0

SQL update for Tax Exempt Status module

Hello,

I have been working on installing the Tax Exempt Status module for a client of mine. The SQL update throws an error when I run the query. The error is as follows:

1146 Table 'bostec_zencart.bos_zen_customers' doesn't exist
in:
[show fields from bos_zen_customers]
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.

The query that is supplied with the module is this.

CREATE TABLE `zen_tax_exempt` (
  `tax_exempt_id` int(11) NOT NULL auto_increment,
  `tax_exempt_name` varchar(32) NOT NULL default '',
  `tax_exempt_percentage` decimal(5,2) NOT NULL default '0.00',
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0001-01-01 00:00:00',
  PRIMARY KEY  (`tax_exempt_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

ALTER TABLE zen_customers ADD COLUMN customers_tax_exempt int(11) NOT NULL default '0' AFTER customers_group_pricing;

My database is named bostec_zencart and the tables are all prefixed with bos_

To correct the error I need to change the zen_tax_exempt to bos_tax_exempt amd zen_customers to bos_customers.

Is there anything else that I need to change? Thank you.

9 Jul 2007, 6:28 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: SQL update for Tax Exempt Status module

That SQL will not work well as it has added the zen_ to all the references to table names as the prefix ...

You would need to remove those to run that ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

9 Jul 2007, 8:09 PM
#3
themusician avatar

themusician

New Zenner

Join Date:
Jun 2007
Posts:
64
Plugin Contributions:
0

Re: SQL update for Tax Exempt Status module

Ajeh:

That SQL will not work well as it has added the zen_ to all the references to table names as the prefix ...

You would need to remove those to run that ...

Thank you. That worked perfectly.