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

[petestownrich]

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.

[mc12345678]

Here's the instructions that are ideal to follow:

http://www.zen-cart.com/entry.php?3-...d-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...

[DrByte]

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.

[petestownrich]

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

[petestownrich]

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?

[DrByte]

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.

[petestownrich]

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.

[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?

[mc12345678]

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.

[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