Duplicate entry error on sessions table with new install on Mountain Lion Server
I've been working with a test Mountain Lion Server building a new zencart site. Everything is ready to go, so I starting setting up my MacPro with another ML Server 10.8.2 to run the live site.
Multiple issues today:
1. After installing mySQL 5.5.29 community edition (test server used 5.5.14), I opened myphpadmin and setup my database for installing ZenCart.
Upon Zencart installation, the database wouldn't install at all over localhost or the external ip address (even though myphpadmin IS accessing with localhost!!). Multi-checked everything and all was perfect in the mySQL setup, user and password.
Finally, the ONLY way the database would install is over a host of: 127.0.0.1.
Then continued the install until everything was completed.
The customer side of ZenCart came up perfectly. :-)
2. Now, I cannot log into the admin with the user I created after the admin folder name was changed and ZC folder deleted. Tried and tried to no avail today. I reinstalled many times from scratch even deleting the mysql database and reinstalling all the apps.
WARNING: An Error occurred, please refresh the page and try again.
Here is the log file I received when I tried to log into the admin:
[27-Jan-2013 03:05:24 UTC] PHP Fatal error: 1062uplicate entry 'clmt7v4rkh46cufufqm5jq4kca7vm77c0p0k4t2v4ctgpill8e8eut6jug1jlrgr' for key 'PRIMARY' :: insert into sessions
values ('clmt7v4rkh46cufufqm5jq4kca7vm77c0p0k4t2v4ctgpill8e8eut6jug1jlrgr9ldhmcraptlmdo 12jput8i4i18t3pnhr2h1nic1', '1359256824', 'c2VjdXJpdHlUb2tlbnxzOjMyOiIzYmRmYzE5ZDIzOTc2MjQyYWJiYTA4NTY4M2M2ZWQ0NiI7bGFuZ3V hZ2V8czo3OiJlbmdsaXNoIjtsYW5ndWFnZXNfaWR8czoxOiIxIjtsYW5ndWFnZXNfY29kZXxzOjI6ImV uIjtzZWxlY3RlZF9ib3h8czoxMzoiY29uZmlndXJhdGlvbiI7aHRtbF9lZGl0b3JfcHJlZmVyZW5jZV9 zdGF0dXN8czo0OiJOT05FIjs=') in /Users/Shared/websites/zen-cart-v1.5.1/includes/classes/db/mysql/query_factory.php on line 120
Guys.... I lost on this. I have 2 other computers running ZenCart, but this OSX server will not install correctly. Those other 2 work perfectly under localhost, which makes this even more strange.
I can't figure out if the OSX install is 'wonky' or if it's the newer version of mySQL or something else.
pres of Musical Creations Ltd.