Upgrade strategy ... (and server move)

[montello1984]

Ah .... it seems to be connected now ... dunno why that has suddenly changed.

I think I just now need to do some customisation of colours.

Thanks for all your help so far.

[montello1984]

OK - I think I have sort of worked it out ...

Something a bit odd is going on regarding how various components are connecting.

If I add the text:
80.76.216.10 www.petticrows.co.uk
to my hosts file I see the staging site on the new server and a virgin ZC install with no products.

If I then remove that line from my hosts file I see a virgin ZC install with my products.

If I view the site on another PC I see the old site as I expected ... old ZC install

Something odd is going on when I mess with the hosts file to re-direct the browser to the staging site.

Any thoughts?

[DrByte]

OK - I think I have sort of worked it out ...

Something a bit odd is going on regarding how various components are connecting.

If I add the text:
80.76.216.10 www.petticrows.co.uk
to my hosts file I see the staging site on the new server and a virgin ZC install with no products.

If I then remove that line from my hosts file I see a virgin ZC install with my products.

If I view the site on another PC I see the old site as I expected ... old ZC install

Something odd is going on when I mess with the hosts file to re-direct the browser to the staging site.

Any thoughts?

That would be the normal caching that your browser does, as well as IP address caching that your PC does.
You'll need to clear your browser cache and cookies, and also "flush IP routes" (google for "windows flush routes"). Or just use 2 PCs.

[montello1984]

OK - had a bit of a clean up and rebooted and using a new browser in private mode and I can now see the staged version.

Sadly it is not linking to the DB where as when the IP routing was slightly muddled it was ...

Any tips/ideas?

[DrByte]

I still don't really know what you mean by "is not linking to the database".

[montello1984]

The ZC shop is not picking up all the product listings that are contained in the SQL data base and the product images.

For a while it looked almost done when the browser was obviously getting IP routing a bit confused and all the products were listed.

Now all I see is what looks like a completely blank ZC install with no product listings as the install is not connecting with the SQL database which contains all the shop details.

[DrByte]

The ZC shop is not picking up all the product listings that are contained in the SQL data base and the product images.

For a while it looked almost done when the browser was obviously getting IP routing a bit confused and all the products were listed.

Now all I see is what looks like a completely blank ZC install with no product listings as the install is not connecting with the SQL database which contains all the shop details.

That's exactly symptomatic of having a different DB_PREFIX on the new site than what you had on the old site. Thus, the database is being told to look at tables which are named differently in both databases, thus you're making it look at a completely separate set of data.
That's why step #1 in my instructions earlier told you to note and use the same prefix on the new site as you did on the old.

[montello1984]

I believe I have:

Here is the section from the current live site:


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


Here is the same section from the staged site:

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_CHARSET', 'utf8');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'dragon_petticrow');
define('DB_SERVER_PASSWORD', '**************');
define('DB_DATABASE', 'dragon_onlineshop');

[DrByte]

I have had the database copied over by the hosting company.

Can you explain what you mean by this?

[montello1984]

My hosting company moved(took a copy) the SQL database from my old Plesk based server (which is currently still live) to my new cPanel server which I am working on at present in the background.

I didn't migrate the database myself.

I am operating on the fringes of my expertise here ... (thanks for helping)