Problems with creating a copy of install

[mlbacher]

I'm trying to create a duplicate of my zen-cart installation (for testing purposes). I created a new domain name (testing.mydomain.com), created a second database, dumped all the data from one and inserted it to the second, and changed all the relevant fields in the two configure.php files. I also changed the admin directory for the seconds installation for good measure. Going to the new test site looks fine, but when I try to log into the admin, I get this error:

1062 Duplicate entry '0' for key 'PRIMARY'
in:
[insert into zen_admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '0', 'login.php ', '', '99.225.132.169')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I've tried deleting all enteries in the zen_admin_activity_log, with no change in the error message. Can someone give me a clue as to how I might resolve this issue?

TIA!

[jfaletra]

I got mine to work by modifying the config.php files in the /admin/includes to change the URL paths.

// Define the webserver and path parameters
// HTTP_SERVER is your Main webserver: eg-http://www.your_domain.com
// HTTPS_SERVER is your Secure webserver: eg-https://www.your_domain.com
define('HTTP_SERVER', 'http://www.NEW PLACE.com');
define('HTTPS_SERVER', 'https://www.NEWPLACE.com');


My problem is that I cannot see any of the entrys in my sandbox site. I did a frsh install and copied the database and modified the configs. Once I installed the new and changed the configs I copied all of the production site files to the sandbox site.

When I look at the site none of my 20 products show up.

[mlbacher]

Thanks... actually, I eventually got it to work.

I started from scratch, but did things in a different order. This time, I started with a fresh install at the new location, made a back-up of the two configure.php files, then did a full dump of the existing database (I don't know if it mattered, but I completely deleted the admin activity log table before I imported the old data to the new database). I copied over all of my files onto the new server, not over-writing the configure files.

That seemed to do the trick!

I'm not sure why it didn't work the first way, but it seems everything is okay now.