Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
I got this when installing with Drush:
WD php: PDOException: 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): CREATE TRIGGER [error]
`{settings_audit_log_variable_update_audit}` AFTER UPDATE ON `{variable}` FOR EACH ROW
BEGIN
DECLARE connection_uid INT;
IF (NEW.value != OLD.value ) THEN
SELECT COALESCE(uid, 0) INTO connection_uid FROM {settings_audit_log_user_db_connection} WHERE connection_id = CONNECTION_ID();
INSERT INTO `{settings_audit_log_variable_audit_log}` (`name`, `old_value`, `new_value`, `event_timestamp`, `uid`)
VALUES (NEW.name, OLD.value, NEW.value, UNIX_TIMESTAMP(), connection_uid);
END IF;
END;
CREATE TRIGGER `{settings_audit_log_variable_insert_audit}` AFTER INSERT ON `{variable}` FOR EACH ROW
BEGIN
DECLARE connection_uid INT;
SELECT COALESCE(uid, 0) INTO connection_uid FROM {settings_audit_log_user_db_connection} WHERE connection_id = CONNECTION_ID();
INSERT INTO `{settings_audit_log_variable_audit_log}` (`name`, `old_value`, `new_value`, `event_timestamp`, `uid`)
VALUES (NEW.name, NULL, NEW.value, UNIX_TIMESTAMP(), connection_uid);
END;; Array
(
)
in settings_audit_log_install_variable_trigger() (line 116 of /DRUPAL7/sites/all/modules/contrib/settings_audit_log/settings_audit_log.install).
Cannot modify header information - headers already sent by (output started at /usr/share/pear/drush/includes/output.inc:37) bootstrap.inc:1212 [warning]
PDOException: 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): CREATE TRIGGER `{settings_audit_log_variable_update_audit}` AFTER UPDATE ON `{variable}` FOR EACH ROW
BEGIN
DECLARE connection_uid INT;
IF (NEW.value != OLD.value ) THEN
SELECT COALESCE(uid, 0) INTO connection_uid FROM {settings_audit_log_user_db_connection} WHERE connection_id = CONNECTION_ID();
INSERT INTO `{settings_audit_log_variable_audit_log}` (`name`, `old_value`, `new_value`, `event_timestamp`, `uid`)
VALUES (NEW.name, OLD.value, NEW.value, UNIX_TIMESTAMP(), connection_uid);
END IF;
END;
CREATE TRIGGER `{settings_audit_log_variable_insert_audit}` AFTER INSERT ON `{variable}` FOR EACH ROW
BEGIN
DECLARE connection_uid INT;
SELECT COALESCE(uid, 0) INTO connection_uid FROM {settings_audit_log_user_db_connection} WHERE connection_id = CONNECTION_ID();
INSERT INTO `{settings_audit_log_variable_audit_log}` (`name`, `old_value`, `new_value`, `event_timestamp`, `uid`)
VALUES (NEW.name, NULL, NEW.value, UNIX_TIMESTAMP(), connection_uid);
END;; Array
(
)
in settings_audit_log_install_variable_trigger() (line 116 of /DRUPAL7/sites/all/modules/contrib/settings_audit_log/settings_audit_log.install).
Drush command terminated abnormally due to an unrecoverable error. [error]
Module could also use a README.txt file
Comments
Comment #1
NaliPL CreditAttribution: NaliPL commentedHave similar problem whe turn on off module and click "save button"
Solve this issue via mysql query:
grant super on *.* to user_name@localhost identified by "password here";
then
flush privileges;
previously I have the grant all added t othis user but it dosn't work, after add grant super the problem looks like solved to me.
PS. When the message was showed some modules don't install correctly even if they were checked as installed after refresh the page !
Comment #2
mgiffordThanks. I haven't tried this yet, but will try to do so.
Would be nice if the module spit out a nice error message explaining the MySQL permissions that are required for the Drupal user.