Errors when displaying customer data

[nmtaser]

Hello,

I am running zen-cart v2.1.0, when i try and show my customer data it shows the following

"WARNING: An Error occurred, please let us know! If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you entered valid data."

In the admin debug is shows

21-Dec-2025 09:56:19 America/Boise] Request URI: /adminfoldername/index.php?cmd=customers, IP address: (IPSHOWN removed here), Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /includes/classes/db/mysql/query_factory.php(733): trigger_error()
#2 /includes/classes/db/mysql/query_factory.php(678): queryFactory->show_error()
#3 /includes/classes/db/mysql/query_factory.php(307): queryFactory->set_error()
#4 /adminfoldername/includes/classes/split_page_results.php(220): queryFactory->Execute()
#5 /adminfoldername/includes/classes/split_page_results.php(131): splitPageResults->numberRows()
#6 /adminfoldername/customers.php(1612): splitPageResults->__construct()
#7 /adminfoldername/index.php(16): require('/home2/uorgvlmy...')
--> PHP Fatal error: MySQL error 1054: Unknown column 'ci.customers_info_source_id' in 'field list' :: SELECT count(*) as total FROM (SELECT c.customers_id , ci.customers_info_source_id, cgc.amount FROM zen6b_customers c LEFT JOIN zen6b_customers_info ci ON c.customers_id= ci.customers_info_id LEFT JOIN zen6b_address_book a ON c.customers_id = a.customers_id AND c.customers_default_address_id = a.address_book_id LEFT JOIN zen6b_coupon_gv_customer cgc ON c.customers_id = cgc.customer_id ORDER BY ci.customers_info_date_account_created DESC) countresults ==> (as called by) /adminfoldername/includes/classes/split_page_results.php on line 220 <== in /includes/classes/db/mysql/query_factory.php on line 733.

Any help that could be given would be appreciated.

[dbltoe]

You don't say how you got to 2.1.0.

customers_info_source_id is not a standard Zen Cart field in the customers table. Perhaps it came from a previous mod.

[nmtaser]

I will look into that file, I installed it through softaculous but it has been working up until this point, I have a feeling you are correct in that its that file, I will take a look into that file and see what I can find. Thank you for your response.

[dbltoe]

I installed it through softaculous but it has been working up until this point

You've apparently come across one of the main reasons why any ZC developer or seasoned forum member would never use Softaculous for anything other than a quick test site load. And most of them would probably not even do that.

https://docs.zen-cart.com/user/first..._do_i_install/

[nmtaser]

I found the issue, I hadn't went to that part of the admin for a while other parts were working, I was installing the how-did-you-hear-about-us-2.0.2 and guess I didn't install it right or didn't finish so the files where calling that, I deleted all the files in that plugin and that fixed the site.

[dbltoe]

You might still want to make sure Softaculous didn't mess with you, especially if you used it for upgrading.

[nmtaser]

Thank you for your help, it was very appreciated.

[nmtaser]

You might still want to make sure Softaculous didn't mess with you, especially if you used it for upgrading.

I will definitely do that, would the DB be intact, if was to do a fresh install using the core files from here and just move the database across would that work, or should I redo everything from the ground up with core files from here.

[dbltoe]

There are so many factors to take into account. How far along in the upgrade, how many products, how many mods, etc.

I would start by going to Tools > System Inspection to see if there are any indications of a problem. If not, you are probably good to go.

If not, if you have cPanel in your hosting, I would follow these test site creation instructions and then compare the basic files and databases to see if there is anything else thrown in the mix.