Error when filtering orders in the Admin
This article provides a patch for the ÃÛ¶¹ÊÓƵ Commerce issue where an error occurs when attempting to filter orders in the Admin by date, displaying the message: Integrity constraint violation: 1052 Column ‘created_at’ where clause is ambiguous.
Description description
Environments
ÃÛ¶¹ÊÓƵ Commerce (all deployment methods) 2.4.4 - 2.4.7
Issue/Symptoms
Filtering orders in the Admin by date returns an error.
The exception.log shows:
report.CRITICAL: PDOException: SQLSTATE[ 23000] : Integrity constraint violation: 1052 Column 'created_at' in where clause is ambiguous in /path/to/magento/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:90
Steps to reproduce:
-
Go to Admin
>Sales>Orders.- Set Purchase Date Ascending order in grid, OR
- Set Purchase Date Filter in filters.
-
An error appears: Something went wrong with processing the default view and we have restored the filter to its original state.
Cause
There’s an issue with the PayPal Braintree modules.
Resolution resolution
To solve the issue, apply the patch attached to this article. To download it, scroll down to the end of the article and click the file name, or click the following link:
The patch is compatible with all affected versions and editions.
How to apply the patch
For instructions, see Apply patches in the Commerce on Cloud Guide.