- Posts: 58
- Thank you received: 0
Remove reminders using phpMyAdmin
- Petter
-
Topic Author
- Offline
- Senior Member
-
Less
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
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.
- Tuan Pham Ngoc
- Offline
- Administrator
-
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
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
Support
Documentation
Information
Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.