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, …
In the labyrinth of Magento development, encountering unexpected roadblocks is all too familiar. One such conundrum that has puzzled many administrators is the failure of the reset password feature for the admin user in Magento versions 2.4.6-p3 and below. It's a perplexing issue that leaves users stranded, unable to regain access to their vital accounts. …
Continue reading How to Fix: Admin Password Reset Fails in Magento 2.4.6-p3 and Below
I was talking to a friend of mine recently about the strategy we are using on one of the projects we're working on together and I noticed that it would be great if I could create a blog post and share some knowledge with some developers, lead developers, managers, or anywho, who suffer a lot …
In the dynamic realm of command-line interfaces, the terminal serves as a potent hub for executing tasks, running scripts, and managing server operations. However, a common challenge arises when you need to keep processes running in the background, especially when working over SSH. Enter the 'screen' command—a versatile and powerful tool that unlocks a world …
Today I want to talk about something different from what I've been posting on my blog lately. I'm not going to talk about anything technical, nor explain how something works behind the scenes. I want to talk a little to you, a developer or aspiring developer who is learning about Magento or any other platform …
Continue reading How I got in the international market and what I’ve learned so far
Generating a database dump is a critical practice in the realm of database management, offering a safeguard against data loss, aiding in disaster recovery, and facilitating seamless data migration or replication. A database dump essentially involves creating a snapshot of the entire database, capturing its structure and content at a specific point in time. While …
A few days ago a client complained their Magento website was suffering from a bot attack in the checkout with the credit card payment. They received thousands and thousands (I mean, thousands, like more than 30 thousand) of failed transaction emails in their email inbox. They immediately asked for our help to investigate and apply …
A few days ago I worked on a very interesting issue for a client in Magento 2 Commerce Edition. Basically, they have some multi-select product attributes and these attributes allow the admin user to add different values depending on the Store View because when these attributes were created, they were set to Store View in …
A few days ago I was working as usual from my home office. I was entertained working on an investigation for a non-critical bug for one of our clients. Suddenly a Slack message popped up on my screen: "We have a critical bug happening on production for this given client that started happening after the …
Continue reading Finding the Villain Commit in the Magento 2 Codebase Using the GIT Bisect
Magento, the powerhouse of e-commerce solutions, continues its journey of evolution and enhancement with the release of version 2.4.6. Packed with new features, improvements, and bug fixes, this version promises to elevate the e-commerce experience for both merchants and developers. In this blog post, we'll dive into the key changes introduced in Magento 2.4.6, shedding …
Continue reading Exploring the New Horizons: Magento 2.4.6 Overview
Tiago Sampaio 