vulcan wrote:
I'm referring to a plain phpmyadmin export from the menu at the top of the database window with the default values except change "Function to use when dumping data:INSERT" to UPDATE and select file download as zip format. No other options to be changed phpmyadmin 3.4.2. Then a straight import into the new database of the .sql.zip exported.
When I do that query, I get the following error:
Quote:
Error
SQL query:
--
-- Dumping data for table `cc_card_group`
--
INSERT INTO `cc_card_group` ( `id` , `name` , `description` , `users_perms` , `id_agent` , `provisioning` )
VALUES ( 1, 'Online', 'This group is the default group used when you create a customer. It\\''s forbidden to delete it because you need at least one group but you can edit it.', 517630, -1, NULL ) , ( 2, 'HalfMoon', 'HalfMoon Customers created in MO', 454654, 1, 'NULL' ) , ( 3, 'Stockholm', 'NULL', 520190, 2, 'NULL' ) , ( 4, 'Prepaid Cards Spain', 'Prepaid Cards distributed in Spain', 255806, -1, 'NULL' ) , ( 5, 'Wholesale', 'Wholesalers, call centers, retailist, etc.', 189022, 3, 'NULL' ) , ( 7, 'B2B', 'Business to Business leaded costumers', 518142, 3, 'NULL' ) ;
MySQL said: Documentation
#1062 - Duplicate entry '1' for key 1
You may have to increase memory and execution time settings in php.ini
I have the memory in 2048MG, and the scripting in 600ms.. already, before start the production.
Quote:
Are you getting getting php or mysql errors in the log?
No, only asterisk who's complaining with this errors...
Quote:
Did you run a "check tables" on the database with phpmyadmin and possibly a repair?
I did, but the same, no difference...