Acumulus Forum

Voor leden en niet-leden (openbaar) => Webkoppelingen => Topic gestart door: missmore op 13 augustus, 2014, 12:45:40

Titel: foutmelding in magento
Bericht door: missmore op 13 augustus, 2014, 12:45:40
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?

Titel: Re: foutmelding in magento
Bericht door: Guido op 13 augustus, 2014, 12:50:20
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 )
Titel: Re: foutmelding in magento
Bericht door: Guido op 14 augustus, 2014, 10:33:21
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.