Magento

Hallo,

Ik krijg bij het importeren van het mage_report_viewed_product_index een foutmelding, iemand een idee hoe ik dit kan oplossen?

Fout
SQL-query:

--—Gegevens worden uitgevoerd voor tabel `mage_report_viewed_product_index`—INSERT INTO `mage_report_viewed_product_index` (`index_id`, `visitor_id`, `customer_id`, `product_id`, `store_id`, `added_at`) VALUES (1, 7, NULL, 16, 1, \\\’2012-04-25 06:11:32\\\’), (2, 122, 1, 65, 1, \\\’2012-04-29 16:54:50\\\’), (5, 13, 1, 101, 1, \\\’2012-04-25 12:35:02\\\’), (6, 13, 1, 97, 1, \\\’2012-04-25 13:39:00\\\’), (8, 13, 1, 246, 1, \\\’2012-04-25 13:37:44\\\’), (10, 17, NULL, 326, 1, \\\’2012-04-25 14:34:51\\\’), (14, 17, NULL, 327, 1, \\\’2012-04-25 15:54:08\\\’), (15, 18, NULL, 327, 1, \\\’2012-04-25 15:52:05\\\’), (18, 17, NULL, 222, 1, \\\’2012-04-25 16:54:11\\\’), (19, 17, NULL, 293, 1, \\\’2012-04-25 17:25:34\\\’), (20, 26, NULL, 222, 1, \\\’2012-04-26 05:32:47\\\’), (21, 24, NULL, 270, 1, \\\’2012-04-26 06:51:13\\\’), (22, 24, NULL, 231, 1, \\\’2012-04-26 06:52:20\\\’), (24, 24, NULL, 230, 1, \\\’2012-04-26 06:54:45\\\’), (26, 24, NULL, 292, 1, \\\’2012-04-26 12:19:19\\\’), (28, 35, NULL, 137, 1, \\\’2012-04-27 04:08:09\\\’), (29, NULL, 2, 263, 1, \\\’2012-04-29 21:08:01\\\’), (30[...]

MySQL retourneerde: 

#1062 - Duplicate entry \\\’1\\\’ for key \\\’PRIMARY\\\’

Dat betekent dat die tabel mage_report_viewed_product_index al informatie bevat die het niet zou mogen hebben. Oplossing is even die tabel leegmaken.

Ik heb een nieuwe database aangemaakt en alles opnieuw geupload en geimporteerd

nu krijg ik maar twee foutmeldingen eerst waren het er meer. Wat moet ik nu doen?

Fout

SQL-query:

--—Gegevens worden uitgevoerd voor tabel `mage_adminnotification_inbox`—INSERT INTO `mage_adminnotification_inbox` (`notification_id`, `severity`, `date_added`, `title`, `description`, `url`, `is_read`, `is_remove`) VALUES (1, 4, ‘2008-07-25 01:24:40’, ‘Magento 1.1 Production Version Now Available’, ‘We are thrilled to announce the availability of the production release of Magento 1.1. Read more about the release in the Magento Blog.’, ‘http://www.magentocommerce.com/blog/comments/magento-11-is-here-1/’, 0, 0), (2, 4, ‘2008-08-02 01:30:16’, ‘Updated iPhone Theme is now available’, ‘Updated iPhone theme for Magento 1.1 is now available on Magento Connect and for upgrade through your Magento Connect Manager.’, ‘http://www.magentocommerce.com/blog/comments/updated-iphone-theme-for-magento-11-is-now-available/’, 0, 0), (3, 3, ‘2008-08-02 01:40:27’, ‘Magento version 1.1.2 is now available’, ‘Magento version 1.1.2 is now available for download and upgrade.’, ‘http://www.mag[...]

MySQL retourneerde:
#1062 - Duplicate entry ‘1’ for key ‘PRIMARY’

--------------------------------------------------------------------------------------------------------------------------------------------------

Fout

SQL-query:

--
-- Beperkingen voor tabel `mage_sales_flat_invoice`
--
ALTERTABLE`mage_sales_flat_invoice` ADDCONSTRAINT`FK_73A125E46767E6A3C1A73FD562A17D7F`FOREIGNKEY (`order_id`)REFERENCES`mage_sales_flat_order` (`entity_id`)ONDELETECASCADEONUPDATECASCADE ,
ADDCONSTRAINT`FK_MAGE_SALES_FLAT_INVOICE_STORE_ID_MAGE_CORE_STORE_STORE_ID`FOREIGNKEY (`store_id`)REFERENCES`mage_core_store` (`store_id`)ONDELETESETNULLONUPDATECASCADE ;

MySQL retourneerde:
#1452 - Cannot add or update a child row: a foreign key constraint fails (`DB1171620`.`#sql-321d_191604`, CONSTRAINT `FK_73A125E46767E6A3C1A73FD562A17D7F` FOREIGN KEY (`order_id`) REFERENCES `mage_sales_flat_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE)