New customers and orders not showing on admin home or individual pages

We just upgraded from 1.3.8 to 1.3.9h. Everything seems to be working fine. New customers can register. Orders are going through, getting payment processed, and emails are coming through. However, none of that is showing up in zen. There are no new customers or orders on the admin home page and no customers or orders at all under Customers - Customers and Customers - Orders. I have checked the databases and all customers and orders are there dating back to 2004 including the test customers and orders we just registered and places after the upgrade. Any idea why they are getting to the database but not to zen? Any idea how to fix it?

When you upgraded ... did you go to each of the Modules for Payment, Shipping and Order Totals and:

1 Save each modules settings to NotePad

2 Click on REMOVE, INSTALL and then re-configure

doing this for every single one of them?

Have you tried your Test Customer account and tried to make an order yourself?

Have you tested your email in your Zen Cart Admin and tried to send an email?

Have you tried using the Contact Us on your shop and send an email?

Have you checked that the two configure.php files are using the correct database information in:
/includes/configure.php

/your_admin_dir/includes/configure.php

Ajeh:

When you upgraded ... did you go to each of the Modules for Payment, Shipping and Order Totals and:

1 Save each modules settings to NotePad

2 Click on REMOVE, INSTALL and then re-configure

doing this for every single one of them?

Yes to both.

Have you tried your Test Customer account and tried to make an order yourself?

We actually have a live site in which we created a new customer and made a couple of orders. The new customer is in the database and the orders are there but neither shows up in zen.

Have you tested your email in your Zen Cart Admin and tried to send an email?

No, but we are getting orders emailed to us from zen. They just aren't showing up in the admin panel.

Have you tried using the Contact Us on your shop and send an email?

Just sent one and get a message that message sent successfully. Waiting to hear from recipient if he receives it.

Have you checked that the two configure.php files are using the correct database information in:
/includes/configure.php

/your_admin_dir/includes/configure.php

Just checked. It was different in the admin/includes/configure.php. Updated and waiting to see if the server does anything with it. As of a couple minutes after the update nothing different.

When you say it was different in the Admin, was it pointing to a different database or using different paths or settings for the server settings for your domain?

Different database. It's pointing to the correct one no.

Contact us works.

If you were pointed to the wrong database when you did the updates or the resets on all of the modules you may what to check everything is still valid ...

Ajeh:

If you were pointed to the wrong database when you did the updates or the resets on all of the modules you may what to check everything is still valid ...

Just went back and did the following:

When you upgraded ... did you go to each of the Modules for Payment, Shipping and Order Totals and:

1 Save each modules settings to NotePad

2 Click on REMOVE, INSTALL and then re-configure

doing this for every single one of them

Still no change. Customers and orders are not showing up.

Have you tried to place an order then track it yourself through the database directly?

The admin needs to 'see' data in order to 'display' it.
The cart needs to 'record' said data to the database.

Assuming your settings are correct, Ajeh mentioned things may not be valid... is the admin looking in the correct table/field for the data?

Is the data actually being recorded?

its really very nice

thank you sir :smile:

Currently having this problem now. Using version 1.5.5 and my banner manager and layout boxes controller aren’t working on Zen cart. I have some banners turned on that aren’t displaying and some boxes turned off that are displaying in layout boxes controller. Also new orders and customers aren’t showing on ZenCart at all, I only know about them due to the confirmation email. It was fine until Tuesday last week, I’m not sure what changed but it has caused the problems just mentioned.

JakeLawless:

Currently having this problem now. Using version 1.5.5 and my banner manager and layout boxes controller aren’t working on Zen cart. I have some banners turned on that aren’t displaying and some boxes turned off that are displaying in layout boxes controller. Also new orders and customers aren’t showing on ZenCart at all, I only know about them due to the confirmation email. It was fine until Tuesday last week, I’m not sure what changed but it has caused the problems just mentioned.

Based on that information (changes made in the admin not reflected on the catalog/store side) it appears that the database information in YOUR_ADMIN/includes/configure.php is different than the database information within includes/configure.php... Could attempt to confirm this by making a very small change in some area that basically only you would know about (Extra period in a sentence, add a word, change the capitalization of something, etc...) and see if that is reflected on the store side...

Hi, I have a similar problem. Zen Cart 1.5.7b, PHP Version: 7.4.7, MySQL 5.6.51. The store is working but today I found that customers list do not appear in admin panel. Instead comes message: Customers. WARNING: An Error occurred, please refresh the page and try again.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.
myDEBUG-adm says:
[14-Feb-2021 11:09:37 UTC] Request URI: /sssss/index.php?cmd=customers, IP address: 212.5.158.109
#1 trigger_error() called at [/storage/eeeee/public_html/includes/classes/db/mysql/query_factory.php:170]
#2 queryFactory->show_error() called at [/storage/ eeeee /public_html/includes/classes/db/mysql/query_factory.php:142]
#3 queryFactory->set_error() called at [/storage/ eeeee /public_html/includes/classes/db/mysql/query_factory.php:269]
#4 queryFactory->Execute() called at [/storage/ eeeee /public_html/sssss/customers.php:1236]
#5 require(/storage/ eeeee /public_html/ sssss /customers.php) called at [/storage/ eeeee /public_html/ sssss /index.php:11]
--> PHP Fatal error: 1054:Unknown column 'c.customers_secret' in 'field list' :: SELECT c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_group_pricing, c.customers_telephone, c.customers_authorization, c.customers_referral, c.customers_secret, a.entry_country_id, a.entry_company, a.entry_company, a.entry_street_address, a.entry_city, a.entry_postcode, ci.customers_info_date_of_last_logon, ci.customers_info_date_account_created , cgc.amount FROM zen_customers c LEFT JOIN zen_customers_info ci ON c.customers_id= ci.customers_info_id LEFT JOIN zen_address_book a ON c.customers_id = a.customers_id AND c.customers_default_address_id = a.address_book_id LEFT JOIN zen_coupon_gv_customer cgc ON c.customers_id = cgc.customer_id ORDER BY ci.customers_info_date_account_created DESC limit 0, 20 ==> (as called by) /storage/ eeeee /public_html/ sssss /customers.php on line 1236 <== in /storage/ eeeee /public_html/includes/classes/db/mysql/query_factory.php on line 170.

sssss is admin
Any help to solve this please!

One wild guess would be that you recently upgraded to 1.5.7b but did not do a database upgrade.

Guesses have to be made if we don't have the info from the posting tips. Enquiring (and helping) minds NEED to know.

Database Patch Level: 1.5.7b . I can try start zc_install again in test site tomorrow.

It sounds like you DID the database upgrade but the change to add the customers_secret field to the customers table didn't work.
This can happen if you have non-conforming dates in the table. Have you added any fields to the customers table?
What happens if you go into phpMyAdmin and type

ALTER TABLE zen_customers ADD customers_secret varchar(64) NOT NULL default '';

This will give you a specific error message that will explain why this operation failed. Once the root cause has been fixed, you can rerun this ALTER TABLE command.

swguy:

It sounds like you DID the database upgrade but the change to add the customers_secret field to the customers table didn't work.
This can happen if you have non-conforming dates in the table. Have you added any fields to the customers table?
What happens if you go into phpMyAdmin and type

ALTER TABLE zen_customers ADD customers_secret varchar(64) NOT NULL default '';

This will give you a specific error message that will explain why this operation failed. Once the root cause has been fixed, you can rerun this ALTER TABLE command.
Thanks a lot for help you both. As I wrote this become a message " MySQL returned an empty result set (i.e. zero rows). (Query took 0.0795 seconds.)" I did not understand what exactly happen but now customers list is present. I did not make nothing more.