Käynnissä

Fix error in Magento: SQLSTATE [23000]

I get an error code from my Magento webshop.:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add

or update a child row: a foreign key constraint fails

(`website/sales_order`, CONSTRAINT

`FK_SALES_ORDER_CUSTOMER` FOREIGN KEY (`customer_id`) REFERENCES

`customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE

CASCADE)

I need this fixed.

Regards

Peter

Taidot: Magento, PHP, SQL

Näytä lisää: magento 23000, website in magento, get my fix, error 0, violation, update magento website, php fix error, null, magento\ , magento+, fix error, error, magento pending, 1452, integrity constraint violation 1452 add update add, magento 1452, add foreign key constraint, add update child row foreign, magento add update child row foreign key, integrity constraint violation 23000, foreign key, magento integrity constraint violation 1452 add update child, integrity constraint violation update, 23000 sql, website error

Tietoa työnantajasta:
( 5 arvostelua ) Aarhus, Denmark

Projektin tunnus: #480430

3 freelanceria on tarjonnut keskimäärin 30 $ tähän työhön

TakeReal

I can fix right now. I need FTP access and access to database.

30 $ USD 1 päivässä
(1262 arvostelua)
7.5
anode

Ready to take care of this right away. Thank you.

30 $ USD 0 päivässä
(110 arvostelua)
6.1
ClusterStudio

Hello. This type of errors appears when database have relationships between tables. With that relationships when a record in one table changes then record in foreign table changes too. Seems like one of this relationsh Lisää

30 $ USD 0 päivässä
(34 arvostelua)
4.9