Käynnissä

Magento error: SQLSTATE[23000]

This error occured after trying to update Magento to a new version.

The problem occurs during the shopping process for users that shop as guest. (The shopping process is working if you are logged in.)

When confirming items in the shopping basket you click next for payment. Here the payment module should be loaded. Now users get an error message: saying that there has been a problem, please come back later.

Then I get an email with this code:

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)

You need to be a Magento expert in order to solve this problem

This could be relevant:
http://www.magentocommerce.com/boards/viewthread/13206/

Taidot: Magento, PHP, SQL

Näytä lisää: this error, magento error update, error sqlstate 23000, sqlstate 23000 magento, sqlstate 23000 integrity constraint violation magento, message error, error 0, violation, update magento website, solve php error, payment module magento, null, magento module, error, basket, order working magento, 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

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

Projektin tunnus: #482909

Myönnetty käyttäjälle:

CoVaLiDiTy

canh help you. tnx.

30 $ USD 0 päivässä
(470 arvostelua)
7.5

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

anode

Ready to start right away. Thank you.

30 $ USD 0 päivässä
(109 arvostelua)
6.1
tipstersoft

magento pro..lets fix it

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

very easy work. I'm ready to fix! Best Regards.

30 $ USD 0 päivässä
(14 arvostelua)
4.2
ms2006

can do it now!

30 $ USD 1 päivässä
(5 arvostelua)
4.3