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, get fix, error 0, violation, update magento website, php fix error, null, fix error, error, magento pending, 1452, magento 1452, add foreign key constraint, integrity constraint violation 23000, foreign key, integrity constraint violation update, 23000 sql, website error, sql 23000, magento website code, sql sqlstate 23000, error 1452 sqlstate, 1452 foreign key constraint, integrity constraint violation key, php 23000

About the Employer:
( 5 reviews ) 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