exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'order_increment_id' in 'where clause'

exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'order_increment_id' in 'where clause'

October 11, 2026 · Illustrated author avatarBy Stefan Bogdanescu
exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'order_increment_id' in 'where clause'

Solving ‘PDOException’ Errors After Upgrading Magento

Are you facing mysterious errors after upgrading your Magento installation? Let’s dive into understanding and resolving these issues step by step.

Understanding the PDOException Error Message

The error message you’re experiencing is a PDOException with the following details:

exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'order_increment_id' in 'where clause'' in lib/Zend/Db/Statement/Pdo.php:228

Analyzing the Error Stack Trace

The stack trace leads us to the app/code/core/Mage/Sales/Model/Order/Shipment/Api.php file, specifically to line 76:

foreach ($shipmentCollection as $shipment) {
    $shipments[] = $this->getAttributes($shipment, 'shipment');
}

The Root Cause of the Error

The root cause lies in lines 53-64 of the same function, where we find a join statement that includes the order_increment_id attribute:

$shipmentCollection = Mage::getResourceModel('sales/order_shipment_collection')
    ->addAttributeToSelect('increment_id')
    ->addAttributeToSelect('created_at')
    ->addAttributeToSelect('total_qty')
    ->joinAttribute('shipping_firstname', 'order_address/firstname', 'shipping_address_id', null, 'left')
    ->joinAttribute('shipping_lastname', 'order_address/lastname', 'shipping_address_id', null, 'left')
    ->joinAttribute('order_increment_id', 'order/increment_id', 'order_id', null, 'left')
    ->joinAttribute('order_created_at', 'order/created_at', 'order_id', null, 'left');

The Hidden Issue

Upon closer inspection of your database schema or the sales_order table structure, you’ll likely notice that there is no order_increment_id column. In Magento 1.x versions, this field was simply referred to as increment_id.

The error occurs because the join statement is trying to access a non-existent column in the order table.

Resolving the Error

To resolve this issue:

Step 1: Verify Your Database Schema

Ensure that your database schema matches the expected one for your Magento version. You can use tools like MySQL Workbench or phpMyAdmin to validate the structure of your sales_order table.

Step 2: Update the Join Statement

Since the column name has changed, update line 63 of the items() function:

->joinAttribute('increment_id', 'order/increment_id', 'entity_id', null, 'left')

Replace 'order_increment_id' with 'increment_id'.

Step 3: Clear Cache and Reindex

After making changes to core files, always clear your Magento cache and reindex the data. This ensures that the updated code is reflected in your store.

Conclusion

In this blog post, we’ve identified the root cause of a PDOException error you were experiencing after upgrading Magento. By understanding the database schema and the join statements used in the core API file, we were able to resolve the issue by updating the column name in the join statement.

Remember, when dealing with core file modifications:

  • Always backup your files before making changes.
  • Test your changes thoroughly on a staging environment before deploying them to production.
  • Keep track of your customizations for future upgrades.

For more detailed guidance on Magento development and best practices, visit Laravel Company.

Database API Orders Errors

Our network