FriendsOfShopware / shopware-cli

CLI for Shopware Account and Shopware 6
MIT License
81 stars 32 forks source link

project dump --anonymize produces a corrupted dump file #292

Closed Saiyan closed 9 months ago

Saiyan commented 9 months ago

PHP Version

8.1.27

Shopware Version

6.5.8.0

Plugin Version

0.4.12

Actual behaviour

When importing a anonymized dump the following error occurs:

ERROR at line 6303: Unknown command '\"'.

The specified line did not show any visible error but one or two lines above (inside the same statement). I saw that the dumped data contains names with unescaped single quotation marks like this 'Janiya O'Connell'

Expected behaviour

The dump should be imported without errors.

Steps to Reproduce?

Create a anonymized dump of a database with multiple existing customers and try to import it into an empty database. Since the values are randomized you maybe have to dump a few times.