Hallo alle zusammen,
wie bekomme ich den Wartungsmodus weg?
Es handelt sich dabei um die Version v6.3.4.1 Stable Version und ich wollte einen Update machen auf 6.3.5.2 ist und zack geht etwas mit der Datenbank wieder nicht.
Error
Received the following error message:
An exception occurred while executing 'CREATE TRIGGER customer_address_vat_id_insert AFTER INSERT ON customer_address FOR EACH ROW BEGIN IF NEW.vat_id IS NOT NULL THEN UPDATE customer SET vat_ids = JSON_ARRAY(NEW.vat_id) WHERE customer.default_billing_address_id = NEW.id AND (JSON_CONTAINS(vat_ids, '"$NEW.vat_id"') = 0 OR vat_ids IS NULL); END IF; END;': SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
Please try to fix this error and restart the update.
Response
{"valid":false,"errorMsg":"An exception occurred while executing 'CREATE TRIGGER customer_address_vat_id_insert AFTER INSERT ON customer_address\n FOR EACH ROW BEGIN\n IF NEW.vat_id IS NOT NULL THEN\n UPDATE customer SET vat_ids = JSON_ARRAY(NEW.vat_id)\n WHERE customer.default_billing_address_id = NEW.id\n AND (JSON_CONTAINS(vat_ids, '\"$NEW.vat_id\"') = 0 OR vat_ids IS NULL);\n END IF;\n END;':\n\nSQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)"}
Jetzt habe ich diesen Wartungsmodus.
ich habe in Erinnerung das etwas in der recovery Ordner gelöscht werden sollte, kann mich aber nicht erinnert was genau das war.