Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

When project dump produces Unknown command '\"'. on import into mysql #433

Closed
func0der opened this issue Nov 8, 2024 · 2 comments
Closed

Comments

@func0der
Copy link

func0der commented Nov 8, 2024

PHP Version

irrelevant

Shopware Version

irrelevant

Plugin Version

0.4.59

Actual behaviour

If I try to import the dump into the database, I get the error Unknown command '\"'. from the mysql command

Expected behaviour

A successful import of the database

Steps to Reproduce?

  1. Create a dump: shopware-cli project dump --username db --password db --host db db
  2. Try to import the dump: mysql -udb -pdb db < dump.sql

It is basically the plugin table that is not properly functioning:

LOCK TABLES `plugin` WRITE;

INSERT INTO `plugin` (`id`, `name`, `base_class`, `composer_name`, `active`, `managed_by_composer`, `path`, `autoload`, `author`, `copyright`, `license`, `version`, `upgrade_version`, `icon`, `installed_at`, `upgraded_at`, `created_at`, `updated_at`) VALUES
( UNHEX('030b86417c7747719384acbf47236cf8'), 'KlarnaPayment', 'KlarnaPayment\\KlarnaPayment', 'klarna/payment', '1', '0', 'custom/plugins/KlarnaPayment', '{\"psr-4\":{\"KlarnaPayment\\\\\":\"src\\/\"}}', 'Klarna Bank AB (publ), Kellerkinder GmbH', '(c) Klarna Bank AB (publ)', 'MIT', '1.10.064', NULL, '?PNG\r\n\Z\n\0\0\0\rIHDR\0\0\0(\0\0\0(��\0\0\0???m\0\0�?IDATX??=h�A�??1�?\"?�D???,E?iD!?�?	?F???JD���;�?BD;���????X�???G�#?Qset$?3???U��xܹg?ywvv?yԄ�?'S|�~??f?K8熀U?,>??,Z�?�fFU�c]?<?|?�?{?�?�=?^?�Wg?\"??�4mpC�)b2???i?[?H�ϲH	\\h??6????�?:?60�???f?�4????H�??H?\r�?"E?\"�???Y?>�?�ڔk????=�}?@hcN(m?n?�v?,ҏ?��?9B�s\nX????sn�p�(?u?3?/Y?�??? p??xYg??�?�???U???{,?�????��v??Wy)???\\�l?8mN??l?????oT?2?�x*?���{T?V?b`�???|???�??q??P??3???=8???j0$?\0^???w?�U?U?A?=l�?�?*غ? :!r�k??\Z�\0?0?��Qs$???��????�?0?t1\'???�?�9?�?e0??	??�??.g?????P??????ܘw?0??B??r?2ў�y1?j?????��\0_??\"?w??9�E?gYE|????��z??f?�?y?1???51Gʟ??HsE???-ѴA?�絘\'?�`(?g??Ù?1?�?�̿??a`I6?c??G:�?��????�?�??�?ܖ?0\0\0\0IEND?B`?', '2022-04-12 14:11:25.606', '2023-10-08 21:25:08.233', '2022-04-12 14:11:23.417', '2024-10-25 12:00:43.283' );
UNLOCK TABLES;
@shyim
Copy link
Member

shyim commented Nov 11, 2024

Could you provide a regular mysqldump of plugin table? So I can reproduce it?
I installed locally the Klarna Plugin and exported and imported it successfully on mariadb 11.5.2

@func0der
Copy link
Author

plugin.sql.gz

There you go. :)

shyim added a commit that referenced this issue Nov 25, 2024
@shyim shyim closed this as completed Nov 25, 2024
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants