Upgraded from 1.3.7 to 1.5.3 BUT database does not seem to be there

OK.... I made a copy of my original database then I renamed it. I made the modifications to the new site and uploaded it to a sub directory. I ran the zen-cart install answered all the questions!

http://www.petestown.com here is the working site.

http://www.petestowntest.com here is the test site.

It just seems the database is just not there? Did i do wrong by making a copy of the old database and renaming it? I have read several posts here in the forum but the database is not my strong suite shall i say.

Here's the instructions that are ideal to follow:

http://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading

As to renaming the database, technically can do whatever you want, but you have to keep track of the bits and pieces so that they all still fit together...

petestownrich:

It just seems the database is just not there? Did i do wrong by making a copy of the old database and renaming it? I have read several posts here in the forum but the database is not my strong suite shall i say.

In all the upgrade documentation and all the FAQs about setting up a new server or moving to a new server (all similar actions) it reminds you that when you're copying a database from one server to another, you MUST use the same DB_PREFIX on the new server as what was on the old server, else Zen Cart will look at the wrong tablenames in your database.

So ... it's simple:
a) when installing the new site, simply provide the correct prefix to start with
or
b) if you screwed that up, go look at DB_PREFIX in the /includes/configure.php of the old server and make DB_PREFIX on the new server be the same thing. Repeat for the admin configure.php file too.

Thanks Doc you just helped a bunch. I appreciate that.

Hi Doc

OLD

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_SERVER', 'p3nl41mysql5.secureserver.net');
define('DB_SERVER_USERNAME', 'petesdbgodaddy');
define('DB_SERVER_PASSWORD', 'XXXXXXXXXXX');
define('DB_DATABASE', 'petesdbgodaddy');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

NEW

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_CHARSET', 'utf8');
define('DB_SERVER', 'petesdb2godaddy.db.3390044.hostedresource.com');
define('DB_SERVER_USERNAME', 'petesdb2godaddy');
define('DB_SERVER_PASSWORD', 'XXXXXXXXX');
define('DB_DATABASE', 'petesdb2godaddy');

They are the same. But one thing dies bother me. When I ran the installer it did not ask me about a database upgrade. It just asked for database information? Did I miss it?

Given that the prefixes are the same and it's not suggesting an upgrade, it sounds like you've not successfully imported the data from the old db into the new db.

Ok Doc....I dont know why but I should have went and physically looked but i did not. I appreciate the direction and I will play from there.

OK..... So I restored the database again and I now have product SOME WHAT!.. When I go to the control panel it tells me I need to do a database upgrade using the ZEN-CART install program? So do I need to just start all over?

petestownrich:

OK..... So I restored the database again and I now have product SOME WHAT!.. When I go to the control panel it tells me I need to do a database upgrade using the ZEN-CART install program? So do I need to just start all over?

No, now is when you reupload the zc_install folder, run zc_install and do a database upgrade and then remove the zc_install folder... Links and posts in this thread previously provided cover this aspect in more detail.

Hi MC yes I went back up and read that. One thing I dont understand... do I need to rename the folder that SHOULD BE CALLED ADMIN back to ADMIN? I am getting a 404 error denied access? I am in the test site of coarse and reloaded the zc_install folder via FTP

petestownrich:

Hi MC yes I went back up and read that. One thing I dont understand... do I need to rename the folder that SHOULD BE CALLED ADMIN back to ADMIN? I am getting a 404 error denied access? I am in the test site of coarse and reloaded the zc_install folder via FTP

No need to rename admin, also no need to make configure.php files writeable. This process is all about the contents of the database, not how to reach it, or other setup aspects. As to the 404 error, well, that I thought has been some of the story of the thread. :P be sure the files are loaded where they should be. And I'm not trying to be any sort of pain in the backside... The zc_install folder should be in the same folder that has folders such as images, includes, and other folders that are in the root of your store.

ok... so i followed the instructions.... BUT when I try and do the database upgrade I am getting the error about username and password? I have read some other posts but have not been able to get it to work. So I am back to the same point again?

Run zc_install. What are the PHP and MySQL versions it's reporting?

petestownrich:

ok... so i followed the instructions.... BUT when I try and do the database upgrade I am getting the error about username and password? I have read some other posts but have not been able to get it to work. So I am back to the same point again?

You should be using/trying admin credentials applicable to the database that was imported. If that is not working, please report back. (Do so also if it works. :) helps the next person that reads this thread.)

ok.... you mean the DATABASE username and password! I will try right now

PHP is 5.2.17 MYSQL 5.5.19 and still have no products?

No, it's not asking for the MySQL password.

zc_install needs the password for the administrator of the store so that it can authorize doing an upgrade.
So, when you import the database from another site, it's THAT site's administrator password that's needed.

petestownrich:

ok.... you mean the DATABASE username and password! I will try right now

Should be the admin credentials that have been previously used for the store that was upgraded. It may take more than one try if they have expired. As in when you used to log into the admin panel of the store that has been upgraded, the credentials entered then are what should be entered now.

PHP is 5.2.17 MYSQL 5.5.19 and still have no products?

Yes I tried my username and password from the admin control panel as well

petestownrich:

PHP is 5.2.17
Ya, that could be a problem. It works much better with PHP 5.3.7 or newer.
And officially the PHP folks have stopped supporting 5.3.x, so better to use 5.4 or 5.5 or 5.6.