After upgrading to 1.5.1 No Customers found in Admin

[Robbyn7]

Hello All,

I recently upgraded to ver1.5.1, performed the database upgrade but when I click on Customers from within Admin there's no customers listed. I've checked in phpMyAdmin, zen_customers, and zen_customers_info, zen_address_book. All show the correct data.

Is there something I'm missing to get the Customer information to show up in my stores admin?

Thanks in advance.

[mc12345678]

Hello All,

I recently upgraded to ver1.5.1, performed the database upgrade but when I click on Customers from within Admin there's no customers listed. I've checked in phpMyAdmin, zen_customers, and zen_customers_info, zen_address_book. All show the correct data.

Is there something I'm missing to get the Customer information to show up in my stores admin?

Thanks in advance.

From what version, what encoding did the database have, what does it have now?

[lat9]

Are you sure that the upgraded /YOUR_ADMIN/includes/configure.php file is referencing the correct database?

[Robbyn7]

Thanks for the replies. I upgraded from ver1.3.8 to 1.5.1.
I'll take a look at my configure.php file this evening to see which database it's referencing.

[Robbyn7]

Are you sure that the upgraded /YOUR_ADMIN/includes/configure.php file is referencing the correct database?

Just checked my configure.php file and yes, it is referencing the correct database. Not sure where to look from here.

[twitchtoo]

Let's start at the beginning... Did the database upgrade actually work?

Have a look at the stock zc_install code and you'll see what it's actually doing when it 'upgrades' your database. You will see the changes in the new 1.51 database if it actually 'worked'.

[Ajeh]

Just to humor me ... could you post both your files:
/includes/configure.php
/your_secret_admin/includes/configure.php

*from your server* and without your username, password and secret admin dir?

[mc12345678]

From what version, what encoding did the database have, what does it have now?

There's still part of the above not answered, also, when in the admin panel and select Version in the toolbar along the top right (typically), what information about your database is there? (Ie, installed 1.3.8, upgraded to 1.3.9h, then upgraded to 1.5.0, etc...)

Also, said that having difficulties seeing the data from the admin panel, but the users are able to perfomr all functions? If so, recommend looking at the admin files to determine that they were properly upgraded, by comparing them to a "fresh" version of ZC1.5.1. Certainly some will have been modified because of add-ons, but keep an eye out for unnecessary/unneeded files that end with .php as these extra files may be loaded depending on where they are, and be causing issues. Also, some files may have been omitted in the upload, not overwritten because of file permissions, etc...

Lastly to the configure.php discussion, both configure.php files point to the same database?

[Robbyn7]

Let's start at the beginning... Did the database upgrade actually work?

Have a look at the stock zc_install code and you'll see what it's actually doing when it 'upgrades' your database. You will see the changes in the new 1.51 database if it actually 'worked'.

Twitchtoo, where would I find the stock zc_install code?

[Robbyn7]

Just to humor me ... could you post both your files:
/includes/configure.php
/your_secret_admin/includes/configure.php

*from your server* and without your username, password and secret admin dir?

From my includes/configure.php:

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', '***********');
define('DB_SERVER_PASSWORD', '***********');
define('DB_DATABASE', 'robyns_zc1');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

and from my admin:

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', '***********');
define('DB_SERVER_PASSWORD', '***********');
define('DB_DATABASE', 'robyns_zc1');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

It appears both configure.php files are identical.