Fixing the MySQL Error “Numeric value out of range: 167 Out of range value for column ‘value_id’ at row 1” in Magento 2

Are you encountering the frustrating MySQL error "Numeric value out of range: 167 Out of range value for column 'value_id' at row 1" when you try to run your Magento 2 store? If so, you're not alone. This error, stemming from a limitation in MySQL InnoDB database tables with an auto-increment column defined as int, …

Continue reading Fixing the MySQL Error “Numeric value out of range: 167 Out of range value for column ‘value_id’ at row 1” in Magento 2

How to fix “Text fields are not optimized for operations that require per-document field data like aggregations and sorting, so these operations are disabled by default.” in Magento 2

A few days ago, I came across an issue in a Magento 2 project where the client complained that no products were being displayed when a customer searched for anything on the site. The most curious part is that this only happened in their production environment. Everything was working fine in their staging environment, which …

Continue reading How to fix “Text fields are not optimized for operations that require per-document field data like aggregations and sorting, so these operations are disabled by default.” in Magento 2