Download the PHP package 0stoya/btfix without Composer
On this page you can find all versions of the php package 0stoya/btfix. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Package btfix
Short Description Fixes malformed SQL aliases (main_table.main_table) caused by Braintree or other extensions in Magento 2 admin order grid.
License MIT
Informations about the package btfix
FixBraintreeWhereClause
A Magento 2 module that fixes malformed SQL aliases generated by certain extensions (commonly Braintree) in the Admin Sales Order Grid.
Some modules incorrectly construct SQL like:
which breaks the grid with errors such as:
This module cleans the SQL on-the-fly, ensuring your order grid loads correctly.
π¦ Installation
Install via Composer:
Then enable the module:
That's it β no configuration required.
π What This Module Fixes
Magentoβs sales_order_grid uses the alias main_table.
Some payment/reporting modules incorrectly prepend the alias twice, causing SQL like:
This module:
- Hooks into
Magento\Sales\Model\ResourceModel\Order\Grid\Collection::load() - Inspects the generated SQL (
WHEREclause) -
Detects invalid patterns:
`main_table`.`main_table`.fieldmain_table.main_table.field
-
Automatically rewrites them to:
`main_table`.fieldmain_table.field
- Allows the grid to execute normally.
It is safe, upgrade-proof, and does not override core or vendor files.
π Compatibility
β Magento 2.3.x β Magento 2.4.x β Fully compatible with Magento 2.4.8-p1 β Works alongside Braintree, PayPal, Adyen, Klarna, custom modules, etc. β No overrides β safe for upgrades
βοΈ Troubleshooting
Still seeing errors?
Some extensions may inject malformed aliases into other SQL parts such as:
ORDER BYHAVING
You can extend the cleaning list inside the plugin:
Other aliases broken?
If another module uses a different alias, simply add another replacement rule.
π License
MIT License (or choose another if you prefer).