Hoofdmenu

foutmelding in magento

Gestart door missmore, 13 augustus, 2014, 12:45:40

Vorige topic - Volgende topic

missmore

Hallo,

Ik heb mijn webshop opgezet, en heb nu een testbestelling gedaan om te zien of alles werkt. Helaas niet dus. Als ik mijn bestelling probeer te verzenden in het systeem, geeft deze een fout: cannot save shipment. Als ik kijk in de log van mijn magento dan kom ik het volgende tegen:

2014-08-13T08:10:30+00:00 ERR (3):
exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'missmore_nl.acumulus_entries' doesn't exist' in /var/www/vhosts/missmore.nl/httpdocs/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /var/www/vhosts/missmore.nl/httpdocs/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /var/www/vhosts/missmore.nl/httpdocs/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /var/www/vhosts/missmore.nl/httpdocs/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#4 /var/www/vhosts/missmore.nl/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `main_ta...', Array)
#5 /var/www/vhosts/missmore.nl/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `main_ta...', Array)
#6 /var/www/vhosts/missmore.nl/httpdocs/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `main_ta...', Array)
#7 /var/www/vhosts/missmore.nl/httpdocs/lib/Varien/Data/Collection/Db.php(734): Zend_Db_Adapter_Abstract->fetchAll('SELECT `main_ta...', Array)
#8 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(521): Varien_Data_Collection_Db->_fetchAll('SELECT `main_ta...', Array)
#9 /var/www/vhosts/missmore.nl/httpdocs/lib/Varien/Data/Collection/Db.php(566): Mage_Core_Model_Resource_Db_Collection_Abstract->getData()
#10 /var/www/vhosts/missmore.nl/httpdocs/lib/Varien/Data/Collection.php(268): Varien_Data_Collection_Db->load()
#11 /var/www/vhosts/missmore.nl/httpdocs/app/code/community/Siel/Acumulus/Model/Entry.php(41): Varien_Data_Collection->getFirstItem()
#12 /var/www/vhosts/missmore.nl/httpdocs/app/code/community/Siel/Acumulus/Model/Order/Observer.php(123): Siel_Acumulus_Model_Entry->getByOrder(Object(Mage_Sales_Model_Order))
#13 /var/www/vhosts/missmore.nl/httpdocs/app/code/community/Siel/Acumulus/Model/Order/Observer.php(82): Siel_Acumulus_Model_Order_Observer->processResults(Array, Object(Mage_Sales_Model_Order), '100000001')
#14 /var/www/vhosts/missmore.nl/httpdocs/app/code/community/Siel/Acumulus/Model/Order/Observer.php(46): Siel_Acumulus_Model_Order_Observer->sendInvoiceToAcumulus(Object(Mage_Sales_Model_Order))
#15 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Core/Model/App.php(1338): Siel_Acumulus_Model_Order_Observer->orderSaveAfter(Object(Varien_Event_Observer))
#16 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Siel_Acumulus_Model_Order_Observer), 'orderSaveAfter', Object(Varien_Event_Observer))
#17 /var/www/vhosts/missmore.nl/httpdocs/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent('sales_order_sav...', Array)
#18 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Core/Model/Abstract.php(466): Mage::dispatchEvent('sales_order_sav...', Array)
#19 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Sales/Model/Order.php(2172): Mage_Core_Model_Abstract->_afterSave()
#20 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Core/Model/Abstract.php(319): Mage_Sales_Model_Order->_afterSave()
#21 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Core/Model/Resource/Transaction.php(151): Mage_Core_Model_Abstract->save()
#22 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Adminhtml/controllers/Sales/Order/ShipmentController.php(120): Mage_Core_Model_Resource_Transaction->save()
#23 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Adminhtml/controllers/Sales/Order/ShipmentController.php(220): Mage_Adminhtml_Sales_Order_ShipmentController->_saveShipment(Object(Mage_Sales_Model_Order_Shipment))
#24 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_Sales_Order_ShipmentController->saveAction()
#25 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('save')
#26 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#27 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#28 /var/www/vhosts/missmore.nl/httpdocs/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#29 /var/www/vhosts/missmore.nl/httpdocs/index.php(87): Mage::run('', 'store')
#30 {main}

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'missmore_nl.acumulus_entries' doesn't exist' in /var/www/vhosts/missmore.nl/httpdocs/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /var/www/vhosts/missmore.nl/httpdocs/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/www/vhosts/missmore.nl/httpdocs/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /var/www/vhosts/missmore.nl/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `main_ta...', Array)
#4 /var/www/vhosts/missmore.nl/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `main_ta...', Array)
#5 /var/www/vhosts/missmore.nl/httpdocs/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `main_ta...', Array)
#6 /var/www/vhosts/missmore.nl/httpdocs/lib/Varien/Data/Collection/Db.php(734): Zend_Db_Adapter_Abstract->fetchAll('SELECT `main_ta...', Array)
#7 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(521): Varien_Data_Collection_Db->_fetchAll('SELECT `main_ta...', Array)
#8 /var/www/vhosts/missmore.nl/httpdocs/lib/Varien/Data/Collection/Db.php(566): Mage_Core_Model_Resource_Db_Collection_Abstract->getData()
#9 /var/www/vhosts/missmore.nl/httpdocs/lib/Varien/Data/Collection.php(268): Varien_Data_Collection_Db->load()
#10 /var/www/vhosts/missmore.nl/httpdocs/app/code/community/Siel/Acumulus/Model/Entry.php(41): Varien_Data_Collection->getFirstItem()
#11 /var/www/vhosts/missmore.nl/httpdocs/app/code/community/Siel/Acumulus/Model/Order/Observer.php(123): Siel_Acumulus_Model_Entry->getByOrder(Object(Mage_Sales_Model_Order))
#12 /var/www/vhosts/missmore.nl/httpdocs/app/code/community/Siel/Acumulus/Model/Order/Observer.php(82): Siel_Acumulus_Model_Order_Observer->processResults(Array, Object(Mage_Sales_Model_Order), '100000001')
#13 /var/www/vhosts/missmore.nl/httpdocs/app/code/community/Siel/Acumulus/Model/Order/Observer.php(46): Siel_Acumulus_Model_Order_Observer->sendInvoiceToAcumulus(Object(Mage_Sales_Model_Order))
#14 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Core/Model/App.php(1338): Siel_Acumulus_Model_Order_Observer->orderSaveAfter(Object(Varien_Event_Observer))
#15 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Siel_Acumulus_Model_Order_Observer), 'orderSaveAfter', Object(Varien_Event_Observer))
#16 /var/www/vhosts/missmore.nl/httpdocs/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent('sales_order_sav...', Array)
#17 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Core/Model/Abstract.php(466): Mage::dispatchEvent('sales_order_sav...', Array)
#18 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Sales/Model/Order.php(2172): Mage_Core_Model_Abstract->_afterSave()
#19 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Core/Model/Abstract.php(319): Mage_Sales_Model_Order->_afterSave()
#20 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Core/Model/Resource/Transaction.php(151): Mage_Core_Model_Abstract->save()
#21 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Adminhtml/controllers/Sales/Order/ShipmentController.php(120): Mage_Core_Model_Resource_Transaction->save()
#22 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Adminhtml/controllers/Sales/Order/ShipmentController.php(220): Mage_Adminhtml_Sales_Order_ShipmentController->_saveShipment(Object(Mage_Sales_Model_Order_Shipment))
#23 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_Sales_Order_ShipmentController->saveAction()
#24 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('save')
#25 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#26 /var/www/vhosts/missmore.nl/httpdocs/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#27 /var/www/vhosts/missmore.nl/httpdocs/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#28 /var/www/vhosts/missmore.nl/httpdocs/index.php(87): Mage::run('', 'store')
#29 {main}

Is er iemand die mij hiermee kan helpen?


Guido

Kan het zijn dat je recentelijk een update van de Acumulus-Magento module geïnstalleerd hebt zonder eerst de oude te verwijderen? Dit is erg belangrijk en lijkt samen te hangen met de foutmelding. Zie ook installatie-instructies.

Als het om een nieuwe installatie gaat verzoek ik je om voor ondersteuning contact op te nemen met BuroRaDer. ( https://forum.acumulus.nl/index.php/topic,3817.0.html )

Guido

Als Magento bij het versturen van een factuur foutmeldngen blijft geven over een niet bestaande tabel 'acumulus_entries', dient uit de tabel core_resources het record met code 'acumulus_setup' verwijderd te worden, waarna de cache geschoond moet worden.

Dit probleem kan zich voordoen als versie Magento-1.7-1.9-Acumulus-3.2.1 de eerste koppeling-versie is geweest die u in uw webshop heeft geïnstalleerd.