You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 query: UPDATE notifications SET send_interval = 0 WHERE send_interval NOT IN () in /var/www/html/sites/all/modules/notifications/notifications.admin.inc on line 236.

When I click "Reset to defaults" on the intervals page (/admin/messaging/notifications/intervals) I get the above aforementioned error.

Comments

tajindersingh’s picture

tajindersingh commented

* subscribing

tajindersingh’s picture

tajindersingh commented

Steps to solve this:

  1. Edit notifications.admin.inc
  2. Find function 'notifications_send_intervals_form_submit'
  3. There is very first check condition ''
  4. Change that conditions code from
    variable_del('notifications_send_intervals');
variable_del('notifications_digest_methods');
variable_del('notifications_default_send_interval');

    to 

    variable_del('notifications_send_intervals');
variable_del('notifications_digest_methods');
variable_del('notifications_default_send_interval');
$intervals = notifications_send_intervals();
  5. The difference is addition of $intervals = notifications_send_intervals(); code line to load $intervals variable with default values from notifications module, which stays null in case of 'Reset to Default'

Someone needs to generate the patch for this.

tajindersingh’s picture

tajindersingh commented
Priority: Normal » Major