Fix error in Magento: SQLSTATE [23000]
Project ID:
480430Project Type:
FixedBudget:
$30-$250 USD
Project Description:
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
Skills required:
Magento, PHP, SQL
Public Clarification Board
Awarded Bids
All Bids ()
TakeReal
|
TakeReal
From Russian Federation
Offline
|
Foundation Freelancer.co.uk Member
HTML Level 1 (93%, 99th percentile)
JavaScript Level 1 (88%, 94th percentile)
ASP Level 1 (75%, 94th percentile)
SQL Level 1 (90%, 85th percentile)
General Freelancer Orientation (85%, 95th percentile)
Foundation EUFreelance.com Member
$30
in 1 day
over 2 years ago
I can fix right now. I need FTP access and access to database.
Ready to take care of this right away. Thank you.
ClusterStudio
|
ClusterStudio
From Russian Federation
Offline
|
US English Level 1 (%, 21st percentile)
Freelancer Orientation (75%, 94th percentile)
PHP Level 2 (80%, 80th percentile)
SQL Level 1 (85%, 61st percentile)
Unix Level 1 (90%, 61st percentile)
Employer Orientation (85%, 100th percentile)
General Freelancer Orientation (85%, 95th percentile)
$30
in 0 days
over 2 years ago
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... more
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 relationships had been broken. I can fix that. Thank you. less