All Questions

Filter by
Sorted by
Tagged with
0
votes
0answers
64 views

SQLSTATE[42000]: Syntax error or access violation: 1235 This version of MySQL doesn't yet support Magento 2

I am facing below error while run setup upgrade commands. SQLSTATE[42000]: Syntax error or access violation: 1235 This version of MySQL doesn't yet support 'multiple triggers with the same action ...
5
votes
2answers
442 views

Disable all Mage_CatalogInventory features

We don't use any feature of Mage_CatalogInventory and I disabled some of it in the system configuration, but there are still a lot MySQL Queries especially in the checkout, which took very long. My ...
1
vote
1answer
1k views

Slow Save Order Due To Re-Index

We're running CE 1.9.1.0 with all the latest patches and use New Relic, among others, to track site performance. I've noticed a number of slow queries when customers are checking out, and in every ...
2
votes
1answer
330 views

cataloginventory_stock_item.low_stock_date?

Table cataloginventory_stock_item column low_stock_date In our db most of the products have the same exact timestamp. how the event trigger for low stock and how to get the exact date. Actually lot of ...
1
vote
1answer
606 views

Magento sold more products than in inventory

My client had a big traffic on server for 1 day. They added one product (ID X) with quantity = 10000. After few hours they sold about 15000 items of this product - I can say because of simple query: ...