You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I am using Adobe Commerce ver. 2.4.6-p1 and we are getting error while print pdf of credit memo. It is returning error.
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous, query was: SELECT main_table.*, sales_alias.tj_salestax_sync_date FROM sales_creditmemo_grid AS main_table LEFT JOIN sales_creditmemo AS sales_alias ON main_table.entity_id = sales_alias.entity_id WHERE (((entity_id IN('1'))))
Steps to Reproduce
Go to Credit memo grid
Select a credit memo from checkbox and select 'PDF Credit Memo'
An error will occur
Expected Result
Go to Credit memo grid
Select a credit memo from checkbox and select 'PDF Credit Memo'
It should open PDF for credit memo
Actual Result
Go to Credit memo grid
Select a credit memo from checkbox and select 'PDF Credit Memo'
It returns an error.
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous, query was: SELECT main_table.*, sales_alias.tj_salestax_sync_date FROM sales_creditmemo_grid AS main_table LEFT JOIN sales_creditmemo AS sales_alias ON main_table.entity_id = sales_alias.entity_id WHERE (((entity_id IN('1'))))
Versions
This is our Version Adobe Commerce ver. 2.4.6-p1
PHP 8.1
The text was updated successfully, but these errors were encountered:
Prerequisites
I am using Adobe Commerce ver. 2.4.6-p1 and we are getting error while print pdf of credit memo. It is returning error.
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous, query was: SELECT
main_table
.*,sales_alias
.tj_salestax_sync_date
FROMsales_creditmemo_grid
ASmain_table
LEFT JOINsales_creditmemo
ASsales_alias
ON main_table.entity_id = sales_alias.entity_id WHERE (((entity_id
IN('1'))))Steps to Reproduce
Expected Result
Actual Result
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous, query was: SELECT
main_table
.*,sales_alias
.tj_salestax_sync_date
FROMsales_creditmemo_grid
ASmain_table
LEFT JOINsales_creditmemo
ASsales_alias
ON main_table.entity_id = sales_alias.entity_id WHERE (((entity_id
IN('1'))))Versions
This is our Version Adobe Commerce ver. 2.4.6-p1
The text was updated successfully, but these errors were encountered: