Customer Tax Exempt v2 - Support Thread

ZC 2.1
PHP 8.3

The SQL script does not run when I refresh the admin home page after uploading this plugin.
Consequently, I get a broken "Customers" Details page and an error log stating, "Unknown Column" 'customer tax exempt'.
Can I just manually add the field in 'customers'?
Any assistance would be greatly appreciated.

[01-Feb-2025 13:29:39 America/Boise] Request URI: //index.php?cmd=customers&page=1&cID=5018&action=edit, IP address: , Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /home2//includes/classes/db/mysql/query_factory.php(733): trigger_error()
#2 /home2//includes/classes/db/mysql/query_factory.php(678): queryFactory->show_error()
#3 /home2//includes/classes/db/mysql/query_factory.php(307): queryFactory->set_error()
#4 /home2//admin/includes/classes/observers/CustomerTaxExemptAdminObserver.php(64): queryFactory->Execute()
#5 /home2//includes/classes/traits/NotifierManager.php(106): CustomerTaxExemptAdminObserver->update()
#6 /home2//Zcf294AkrVd6csa550FeF/customers.php(711): base->notify()
#7 /home2//Zcf294AkrVd6csa550FeF/index.php(16): require('/home2/wildstee...')
--> PHP Fatal error: MySQL error 1054: Unknown column 'customers_tax_exempt' in 'field list' :: SELECT customers_tax_exempt
FROM customers
WHERE customers_id = 5018
LIMIT 1 ==> (as called by) //admin/includes/classes/observers/CustomerTaxExemptAdminObserver.php on line 64 <== in //public_html/includes/classes/db/mysql/query_factory.php on line 733.

You need to add that field in your database for customers

jimmie:

You need to add that field in your database for customers

Thank you for the reply.
I just don't know exactly how to set the entry up in the database.

go to db customers, click structure add 1 column after
this is what i have there
customers_tax_exempt text utf8mb4_general_ci Yes NULL

jimmie:

go to db customers, click structure add 1 column after
this is what i have there
customers_tax_exempt text utf8mb4_general_ci Yes NULL

Excellent, thank you very much for taking the time and helping.

v3.0.0 of the Customers Tax Exempt plugin is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2259

Now released as an encapsulated plugin for Zen Cart versions 2.1.0 and later.

v3.0.1 replaces v3.0.0: Corrects the stored tax-rate when a customer is partially exempt, i.e. not ALL.

I had a momentary panic attack that this plugin might not be updated to deal with the migration of the tax_description field. Naturally my fears were without foundation - @lat9 to the rescue!

Thanks so much for keeping this plugin alive and well!