SQL Tips & Tricks

Version

6.1.0 or newer

Table of contents

It is strongly advised that these statements should only be made with the necessary expertise.
The information provided here was tested at the time of publication of this article, but may have changed in the meantime. The execution of this tutorial is at your own risk

Before you start, make a backup so that you can restore it if you run into trouble. Please note that these are adjustments of shopware and therefore the content of this tutorial is not officially supported!

 

System / Settings

Disable non-standard plug-ins

With the following queries you can deactivate the plug-ins that are not already present when installing Shopware. This is especially useful for debugging errors, as you can quickly eliminate the influence of plug-ins.

If you use your own theme that is integrated via a plug-in, you should make sure in advance that the theme is not assigned to a sales channel. Alternatively, you may encounter problems when calling the appropriate sales channels.

First we create a temporary backup table. The current status of the plug-ins is saved in this table.


CREATE TABLE plugin_tmp LIKE plugin;
INSERT INTO `plugin_tmp` SELECT * FROM `plugin`;

Then you can deactivate the plug-ins


UPDATE `plugin` SET `active`= 0 WHERE (author <> 'shopware AG') OR (author IS NULL);

The original state of the plug-ins can be restored later as follows


UPDATE plugin AS p JOIN plugin_tmp AS pt ON p.id = pt.id SET p.active = pt.active;

Finally, you can delete the temporary backup table


DROP TABLE plugin_tmp;

 

Was this article helpful?