Moved site and now have BIG ISSUES

[shags38]

Maybe all is not as well as it seems. How do I make a fresh new install of ZC on a server where there is an existing install on the same site without causing duplication issues? I figure back up files and database then delete and start again??

Is there a better way?

cheers,
Mike

[DrByte]

How do I make a fresh new install of ZC on a server where there is an existing install on the same site without causing duplication issues?

As to that specific question ...
Zen Cart exists as two components: a set of files and a MySQL database. If you create a separate database and use that database's credentials when you run zc_install in the new folder you uploaded the files to, then the two sites will run independently of each other. Don't use a one-click-install option from your hosting company since it probably won't support having two sites in the same hosting account.

[shags38]

Thanks again for your input Doc.

I am starting from scratch and have read all the available articles on how to move a site or indeed move a folder containing ZenCart.

One question at this point - before now starting from scratch I tried to import the old mysql database into the new fresh one but had error(s) regarding address_book format and also a 1062 error. Will using your Fix_Cache_Key which I have just downloaded fix that issue of recognition in database importing? I don't know why there would be an address book format mismatch - I haven't changed anything in the database at all.

cheers,
Mike

[DrByte]

One question at this point - before now starting from scratch I tried to import the old mysql database into the new fresh one but had error(s) regarding address_book format and also a 1062 error. Will using your Fix_Cache_Key which I have just downloaded fix that issue of recognition in database importing? I don't know why there would be an address book format mismatch - I haven't changed anything in the database at all.

No. The fix_cache_key utility has nothing to do with database-importing or database-integrity or anything like that. ALL it does is exactly what is described in its description and in the FAQ article that references it: it just sets a directory name in one record. Nothing more.

Your database-import issues will need to be sorted out separately. If you have a database integrity problem, you should sort that out before going any further. And we can't help you with those details without seeing exact error messages and the corresponding import data.

[shags38]

Thanks again Doc - here are the errors I get when trying to import the old database into the new database. I have not touched a thing in PhPmyadmin as I haven't a clue what to do other than hit the import or export tabs - everything else is double dutch to me at present.

Any assistance is appreciated - cheers, Mike

Error

SQL query:

-- -- Dumping data for table `zen1_address_book` -- INSERT INTO `zen1_address_book` (`address_book_id`, `customers_id`, `entry_gender`, `entry_company`, `entry_firstname`, `entry_lastname`, `entry_street_address`, `entry_suburb`, `entry_postcode`, `entry_city`, `entry_state`, `entry_country_id`, `entry_zone_id`) VALUES

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 1

after "VALUES" above it lists actual customer entries which I have left out for security reasons - shows them like this - false details inserted.

Error

SQL query:

-- -- Dumping data for table `zen1_address_book` -- INSERT INTO `zen1_address_book` (`address_book_id`, `customers_id`, `entry_gender`, `entry_company`, `entry_firstname`, `entry_lastname`, `entry_street_address`, `entry_suburb`, `entry_postcode`, `entry_city`, `entry_state`, `entry_country_id`, `entry_zone_id`) VALUES (1, 1, 'm', '', 'steven', 'jobs', '57 tooth cresent spanner', '', '19200', 'somewheresville', '', 13, 183), (2, 2, 'm', '', 'Mike', 'O''reily', '39 bouganvillia St', '', '25962', 'Papua', '', 13, 186),

[DrByte]

Sounds like you created your export without telling it to create DROP TABLE statements. Thus your import is attempting to add data that clashes with records already in the database, and it's a good thing that it's halting because otherwise you'd have all kinds of duplicate data or unrelated data messing things up.

Review the instructions for properly exporting your database for a backup: http://www.zen-cart.com/content.php?...ith-phpmyadmin

[shags38]

Sounds like you created your export without telling it to create DROP TABLE statements. Thus your import is attempting to add data that clashes with records already in the database, and it's a good thing that it's halting because otherwise you'd have all kinds of duplicate data or unrelated data messing things up.

Review the instructions for properly exporting your database for a backup: http://www.zen-cart.com/content.php?...ith-phpmyadmin

DOC - your blood is worth bottling !! I had in fact read the information and did a database export including drop tables BUT I didn't delete the previous export that didn't have the Drop Tables and .... you guessed it ... I was trying to import the wrong version. As soon as I read your response the penny dropped so I imported the correct version and BINGO !!

MANY, MANY THANKS indeed Doc - you have won my upmost respect as someone with experience and knowledge of ZenCart who has two essential character traits that make a great teacher ... patience and consideration for those of us who are still very much in the learning phase.

This experience (not yet over, not until both sites are actually live again :) ) has taught me NOT TO TAKE SHORTCUTS .. read the instructions FULLY and follow them EXACTLY. If by chance the instructions are not quite right then at least there is a fall back point. Like baking a cake really - if you want it perfect then follow the recipe.

I will now continue with this transfer process and I will let you know the outcome (hopefully I won't need to call upon you again, well not for this specific task).

cheers,
Mike