Remove reminders using phpMyAdmin

  • Petter
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
1 year 9 months ago #159474 by Petter
Remove reminders using phpMyAdmin was created by Petter
I have a lot of parent/children events where I set one reminder 4 days before and another 1 day before each event; the idea was to send a reminder one day before the cancel_before_date and one with last minute updates the day before the event. This results in too many e-mails with info the thanks_message can handle just fine. So I'm looking for a way to use UPDATE in phpMyAdmin to bulk change this, but not sure which column to address as there are several.related to remind

enable_auto_reminder has "1"
both remind_before_x_days and send_first_reminder has "4" 

I'm thinking this:
UPDATE `myDb_eb_events` SET `insert_correct_coloumn_here` = '0' WHERE `id` BETWEEN '1206' AND '1402'

Anyone done something like this?


Rgds,

Petter

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #159477 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Remove reminders using phpMyAdmin
Hi Petter

Something like:

UPDATE jos_eb_events SET send_first_reminder = 0, send_second_reminder = 0, send_third_reminder = 0 WHERE id >= 1206 AND id <= 1402

Regards,

Tuan
The following user(s) said Thank You: Petter

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc