Hi there,
I'm trying to put my site live from my local dev environment.
My setup:
- MODX version: Rev 2.2.2-pl
- PHP version: 5.3.0
- MySQL version: 5.1.37
- Apache via XAMPP v1.7.2a
After closing all browser windows with my site in it, clearing cache, flushing permissions, flushing sessions, I go to export my database via phpmyadmin.
When I go to import the database into my live environment via phpmyadmin I get the following error:
SQL query:
--
-- Dumping data for table `modx_access_context`
--
INSERT INTO `modx_access_context` ( `id` , `target` , `principal_class` , `principal` , `authority` , `policy` )
VALUES ( 1, 'web', 'modUserGroup', 0, 9999, 3 ) , ( 2, 'mgr', 'modUserGroup', 1, 0, 2 ) , ( 3, 'web', 'modUserGroup', 1, 0, 2 ) , ( 4, 'mgr', 'modUserGroup', 1, 9999, 11 ) ;
MySQL said:
#1062 - Duplicate entry '1' for key 1
I came across this in the forum:
https://forums.modx.com/index.php?topic=31342.0
But there was no actual solution to how he fixed the problem.
Can anyone help?