authorize.net - Magento Payment Gateways Not Working -
magento v 1.9.1.0 trying use authorize.net and/or paypal. neither working... appreciated.
authorize gives error says "there error processing order. please contact or try again later." exception log follows:
2015-03-20t23:53:05+00:00 err (3): exception 'pdoexception' message 'sqlstate[hy000]: general error: 1205 lock wait timeout exceeded; try restarting transaction' in /..../public_html/lib/zend/db/statement/pdo.php:228 stack trace:
0 /..../public_html/lib/zend/db/statement/pdo.php(228): pdostatement->execute(array)
1 /..../public_html/lib/varien/db/statement/pdo/mysql.php(110): zend_db_statement_pdo->_execute(array)
2 /..../public_html/app/code/core/zend/db/statement.php(291): varien_db_statement_pdo_mysql->_execute(array)
3 /..../public_html/lib/zend/db/adapter/abstract.php(480): zend_db_statement->execute(array)
4 /..../public_html/lib/zend/db/adapter/pdo/abstract.php(238): zend_db_adapter_abstract->query('select
si
.*, ...', array)5 /..../public_html/lib/varien/db/adapter/pdo/mysql.php(428): zend_db_adapter_pdo_abstract->query('select
si
.*, ...', array)6 /..../public_html/lib/zend/db/adapter/abstract.php(737): varien_db_adapter_pdo_mysql->query(object(varien_db_select), array)
7 /..../public_html/app/code/core/mage/cataloginventory/model/resource/stock.php(138):
zend_db_adapter_abstract->fetchall(object(varien_db_select))
8 /..../public_html/app/code/local/mana/cataloginventory/model/stock.php(50):
mage_cataloginventory_model_resource_stock->getproductsstock(object(mana_cataloginventory_model_stock), array, true)
9 /..../public_html/app/code/core/mage/cataloginventory/model/observer.php(635):
mana_cataloginventory_model_stock->registerproductssale(array)
10 /..../public_html/app/code/core/mage/core/model/app.php(1338): mage_cataloginventory_model_observer->subtractquoteinventory(object(varien_event_observer))
11 /..../public_html/app/code/core/mage/core/model/app.php(1317): mage_core_model_app->_callobservermethod(object(mage_cataloginventory_model_observer),
'subtractquotein...', object(varien_event_observer))
12 /..../public_html/app/mage.php(448): mage_core_model_app->dispatchevent('sales_model_ser...', array)
13 /..../public_html/app/code/core/mage/sales/model/service/quote.php(187):
mage::dispatchevent('sales_model_ser...', array)
14 /..../public_html/app/code/core/mage/sales/model/service/quote.php(249):
mage_sales_model_service_quote->submitorder()
15 /..../public_html/app/code/core/mage/checkout/model/type/onepage.php(784):
mage_sales_model_service_quote->submitall()
16 /..../public_html/app/code/core/mage/checkout/controllers/onepagecontroller.php(579):
mage_checkout_model_type_onepage->saveorder()
17 /..../public_html/app/code/core/mage/core/controller/varien/action.php(418):
mage_checkout_onepagecontroller->saveorderaction()
18 /..../public_html/app/code/core/mage/core/controller/varien/router/standard.php(250):
mage_core_controller_varien_action->dispatch('saveorder')
19 /..../public_html/app/code/core/mage/core/controller/varien/front.php(172):
mage_core_controller_varien_router_standard->match(object(mage_core_controller_request_http))
20 /..../public_html/app/code/core/mage/core/model/app.php(354): mage_core_controller_varien_front->dispatch()
21 /..../public_html/app/mage.php(684): mage_core_model_app->run(array)
22 /..../public_html/index.php(91): mage::run('', 'store')
23 {main}
next exception 'zend_db_statement_exception' message 'sqlstate[hy000]: general error: 1205 lock wait timeout exceeded; try restarting transaction, query was: select
si
.*,p
.type_id
magentocataloginventory_stock_item
si
inner joinmagentocatalog_product_entity
p
on p.entity_id=si.product_id (stock_id=1) , (product_id in(1661396)) update' in /..../public_html/lib/zend/db/statement/pdo.php:235 stack trace:0 /..../public_html/lib/varien/db/statement/pdo/mysql.php(110): zend_db_statement_pdo->_execute(array)
1 /..../public_html/app/code/core/zend/db/statement.php(291): varien_db_statement_pdo_mysql->_execute(array)
2 /..../public_html/lib/zend/db/adapter/abstract.php(480): zend_db_statement->execute(array)
3 /..../public_html/lib/zend/db/adapter/pdo/abstract.php(238): zend_db_adapter_abstract->query('select
si
.*, ...', array)4 /..../public_html/lib/varien/db/adapter/pdo/mysql.php(428): zend_db_adapter_pdo_abstract->query('select
si
.*, ...', array)5 /..../public_html/lib/zend/db/adapter/abstract.php(737): varien_db_adapter_pdo_mysql->query(object(varien_db_select), array)
6 /..../public_html/app/code/core/mage/cataloginventory/model/resource/stock.php(138):
zend_db_adapter_abstract->fetchall(object(varien_db_select))
7 /..../public_html/app/code/local/mana/cataloginventory/model/stock.php(50):
mage_cataloginventory_model_resource_stock->getproductsstock(object(mana_cataloginventory_model_stock), array, true)
8 /..../public_html/app/code/core/mage/cataloginventory/model/observer.php(635):
mana_cataloginventory_model_stock->registerproductssale(array)
9 /..../public_html/app/code/core/mage/core/model/app.php(1338): mage_cataloginventory_model_observer->subtractquoteinventory(object(varien_event_observer))
10 /..../public_html/app/code/core/mage/core/model/app.php(1317): mage_core_model_app->_callobservermethod(object(mage_cataloginventory_model_observer),
'subtractquotein...', object(varien_event_observer))
11 /..../public_html/app/mage.php(448): mage_core_model_app->dispatchevent('sales_model_ser...', array)
12 /..../public_html/app/code/core/mage/sales/model/service/quote.php(187):
mage::dispatchevent('sales_model_ser...', array)
13 /..../public_html/app/code/core/mage/sales/model/service/quote.php(249):
mage_sales_model_service_quote->submitorder()
14 /..../public_html/app/code/core/mage/checkout/model/type/onepage.php(784):
mage_sales_model_service_quote->submitall()
15 /..../public_html/app/code/core/mage/checkout/controllers/onepagecontroller.php(579):
mage_checkout_model_type_onepage->saveorder()
16 /..../public_html/app/code/core/mage/core/controller/varien/action.php(418):
mage_checkout_onepagecontroller->saveorderaction()
17 /..../public_html/app/code/core/mage/core/controller/varien/router/standard.php(250):
mage_core_controller_varien_action->dispatch('saveorder')
18 /..../public_html/app/code/core/mage/core/controller/varien/front.php(172):
mage_core_controller_varien_router_standard->match(object(mage_core_controller_request_http))
19 /..../public_html/app/code/core/mage/core/model/app.php(354): mage_core_controller_varien_front->dispatch()
20 /..../public_html/app/mage.php(684): mage_core_model_app->run(array)
21 /..../public_html/index.php(91): mage::run('', 'store')
22 {main}
you need refresh cache, cache storage , reindex backend check it.
Comments
Post a Comment