Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

FOUTMELDING MySQL
 
freko64
Jr. Member
 
Total Posts:  2
Joined:  2012-10-22
 

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\\\’

 
Magento Community Magento Community
Magento Community
Magento Community
 
Appmerce
Guru
 
Avatar
Total Posts:  376
Joined:  2008-05-13
Amsterdam, The Netherlands
 

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
freko64
Jr. Member
 
Total Posts:  2
Joined:  2012-10-22
 

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)

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top