Printable View
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?Quote:
Originally Posted by Robbyn7
Are you sure that the upgraded /YOUR_ADMIN/includes/configure.php file is referencing the correct database?
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.
Just checked my configure.php file and yes, it is referencing the correct database. Not sure where to look from here.Quote:
Originally Posted by lat9
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'.
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?
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...)Quote:
Originally Posted by mc12345678
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?
Twitchtoo, where would I find the stock zc_install code?Quote:
Originally Posted by twitchtoo
From my includes/configure.php:Quote:
Originally Posted by Ajeh
// 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.
Either on a backup/local copy that was made as part of installing ZC, or by downloading a fresh copy of ZC from this site...Quote:
Originally Posted by Robbyn7
There's a lot of SQL there, but perhaps can find something by sifting through and verifying that each action was performed, or perform it again yourself.
Once again, I can't express how important it is to accept help when help is offered. Thank you Robbyn7.
There are many errors with your site, the first has been corrected:
line 1099 of customers.php was calling a non existent function from one of your previous v1.38 modules.
Your customers list has now been restored in admin.
I'm now working on fixes for the rest of the errors :)
Stay tuned.
Here's the list of things gone wrong with your upgrade:
- template files were in the wrong locations
- admin index page failed because it was trying to call a newsletter/subscription table that was not available/defined
- customers page called a non existent function from a past module
- define_main_page was missing and the template improperly avoided displaying it
- 4 categories had duplicate products mixed with categories
Moving forward...
I managed to correct all of the admin and cart errors I was able to produce during testing and now your /logs folder is void of errors!
There may be other bits and pieces you find that don't work based on what I could see in the code some of the module names do not have 1.51 supported versions.
For now it all looks to be up and running and stable.
Be sure to backup your site locally including your SQL database with the changes/updates I have made so you have a copy.
Do test the site yourself as a guest/customer and admin and let me know if you find any other problems.
:)
I would like to thank the smart and wonderful Zenners especially Twitchtoo. You went above and beyond to help a novice with major website issues. Thank you so much for your time, patience, and kindness. You accomplished in a short period of time what would have taken me months to figure out! Your generosity is much appreciated.
I will heed your advice listed above as I surely don't want the same to happen during the next upgrade.
Robyn
Thank you.
and
You're Welcome.
:)
Also, as infrequent as it may be, following the guidelines for upgrading would significantly help in preventing such an issue of the files. If things are back to the way they should be and any new modifications are properly added/designed, the next upgrade should be a relative breeze.Quote:
Originally Posted by Robbyn7