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 join magentocatalog_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

Popular posts from this blog

c++ - Delete matches in OpenCV (Keypoints and descriptors) -

java - Could not locate OpenAL library -

sorting - opencl Bitonic sort with 64 bits keys -