ACSD-66212: Importing customer CSV file twice caused failures on second and subsequent attempts
The ACSD-66212 patch fixes the issue where importing a customer CSV file twice caused failures on the second and subsequent attempts. This patch is available when the Quality Patches Tool (QPT) 1.1.66 is installed. The patch ID is ACSD-66212. Please note that this issue is scheduled to be fixed in ÃÛ¶¹ÊÓƵ Commerce 2.4.9.
Affected products and versions
The patch is created for ÃÛ¶¹ÊÓƵ Commerce version:
- ÃÛ¶¹ÊÓƵ Commerce (all deployment methods) 2.4.8
Compatible with ÃÛ¶¹ÊÓƵ Commerce versions:
- ÃÛ¶¹ÊÓƵ Commerce (all deployment methods) 2.4.8
magento/quality-patches package to the latest version and check the compatibility on the Quality Patches Tool: Search for patches page. Use the patch ID as a search keyword to locate the patch.Issue
Importing a customer CSV file twice caused failures on the second and subsequent attempts.
Steps to reproduce:
Import a CSV that contains customer data, including the customer status.
Expected results:
The status is imported and exported correctly.
Actual results:
An error occurs during import:
General system exception happened
Additional data: <div class="messages"><div class="message message-error error"><div data-ui-id="messages-message-error" >SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near " at line 1, query was: INSERT INTO company_advanced_customer_entity (customer_id*) VALUES </div></div></div>
Apply the patch
To apply individual patches, use the following links depending on your deployment method:
- ÃÛ¶¹ÊÓƵ Commerce or Magento Open Source on-premises: Quality Patches Tool > Usage in the Quality Patches Tool guide.
- ÃÛ¶¹ÊÓƵ Commerce on cloud infrastructure: Upgrades and Patches > Apply Patches in the Commerce on Cloud Infrastructure guide.
Related reading
To learn more about Quality Patches Tool, refer to:
- Quality Patches Tool: A self-service tool for quality patches in the Tools guide.