Customer Tax Exempt v2 - Support Thread

[wsworx]

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.

[jimmie]

You need to add that field in your database for customers

[wsworx]

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.

[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

[wsworx]

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.