Komplette Fehlermeldung:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`magento`.`mag_ugiftcert_history`, CONSTRAINT `FK_ugiftcert_history_order` FOREIGN KEY (`order_id`) REFERENCES `mag_sales_order` (`entity_id`) ON DELETE SET NULL ON UPDATE SET NULL)#0 /var/www/htdocs/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/htdocs/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/www/htdocs/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /var/www/htdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `mag_ugiftcert_history` (`cert_id`, `action_code`, `ts`, `amount`, `currency_code`, `status`, `customer_id`, `customer_email`, `order_id`, `order_increment_id`) VALUES (?, ?, '2014-09-09 10:19:32', ?, ?, ?, ?, ?, ?, ?)', Array)
#4 /var/www/htdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `mag_ugiftcert_history` (`cert_id`, `action_code`, `ts`, `amount`, `currency_code`, `status`, `customer_id`, `customer_email`, `order_id`, `order_increment_id`) VALUES (?, ?, '2014-09-09 10:19:32', ?, ?, ?, ?, ?, ?, ?)', Array)
#5 /var/www/htdocs/lib/Zend/Db/Adapter/Abstract.php(574): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `mag_ugiftcert_history` (`cert_id`, `action_code`, `ts`, `amount`, `currency_code`, `status`, `customer_id`, `customer_email`, `order_id`, `order_increment_id`) VALUES (?, ?, '2014-09-09 10:19:32', ?, ?, ?, ?, ?, ?, ?)', Array)
#6 /var/www/htdocs/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert('mag_ugiftcert_history', Array)
#7 /var/www/htdocs/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Unirgy_Giftcert_Model_History)
#8 /var/www/htdocs/app/code/community/Unirgy/Giftcert/Model/Cert.php(61): Mage_Core_Model_Abstract->save()
#9 /var/www/htdocs/app/code/community/Unirgy/Giftcert/Model/Observer.php(186): Unirgy_Giftcert_Model_Cert->addHistory(Array)
#10 /var/www/htdocs/app/code/core/Mage/Core/Model/App.php(1338): Unirgy_Giftcert_Model_Observer->sales_order_save_after(Varien_Event_Observer)
#11 /var/www/htdocs/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Unirgy_Giftcert_Model_Observer, 'sales_order_save_after', Varien_Event_Observer)
#12 /var/www/htdocs/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent('sales_order_save_after', Array)
#13 /var/www/htdocs/app/code/core/Mage/Core/Model/Abstract.php(466): Mage->dispatchEvent('sales_order_save_after', Array)
#14 /var/www/htdocs/app/code/local/Mage/Sales/Model/Order.php(2173): Mage_Core_Model_Abstract->_afterSave()
#15 /var/www/htdocs/app/code/core/Mage/Core/Model/Abstract.php(319): Mage_Sales_Model_Order->_afterSave()
#16 (): Mage_Core_Model_Abstract->save()
#17 /var/www/htdocs/app/code/core/Mage/Core/Model/Resource/Transaction.php(105): call_user_func(Array)
#18 /var/www/htdocs/app/code/core/Mage/Core/Model/Resource/Transaction.php(159): Mage_Core_Model_Resource_Transaction->_runCallbacks()
#19 /var/www/htdocs/app/code/core/Mage/Sales/Model/Service/Quote.php(189): Mage_Core_Model_Resource_Transaction->save()
#20 /var/www/htdocs/app/code/community/Paymentnetwork/Pnsofortueberweisung/Model/Service/Quote.php(8): Mage_Sales_Model_Service_Quote->submitOrder()
#21 /var/www/htdocs/app/code/core/Mage/Sales/Model/Service/Quote.php(249): Paymentnetwork_Pnsofortueberweisung_Model_Service_Quote->submitOrder()
#22 /var/www/htdocs/app/code/core/Mage/Checkout/Model/Type/Onepage.php(785): Mage_Sales_Model_Service_Quote->submitAll()
#23 /var/www/htdocs/app/code/core/Mage/Checkout/controllers/OnepageController.php(579): Mage_Checkout_Model_Type_Onepage->saveOrder()
#24 /var/www/htdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Checkout_OnepageController->saveOrderAction()
#25 /var/www/htdocs/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('saveOrder')
#26 /var/www/htdocs/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Mage_Core_Controller_Request_Http)
#27 /var/www/htdocs/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#28 /var/www/htdocs/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#29 /var/www/htdocs/index.php(118): Mage->run('zed_de', 'website')
Fehlerbehebung:
alter table ugiftcert_history drop foreign key FK_ugiftcert_history_order_item, drop foreign key FK_ugiftcert_history_customer, drop foreign key FK_ugiftcert_history_order, drop foreign key FK_ugiftcert_history_user;