Support forumCategory: BugsSubmit Button is not showing
stevegayler asked 6 months ago

The plugin works perfectly with sending an SMS to confirm a booking, however, not a single reminder SMS has been sent from 150 bookings that have been made.
Twilio cannot see any data being sent to them for reminders and say it is the plugin at fault.
Secondly, can we have a reminder option by email as well please?

6 Answers
Nikola Loncar Staff answered 6 months ago

Hi Steve, can you please tell me do you have any error inside PHP log file on your server?

Best regards,
Nikola

stevegayler replied 6 months ago

Does this help?

Nikola Loncar Staff answered 6 months ago

Hi, yes. Thanks for log. Looks like there are some things missing inside database. Can you please try to disable and then enable extension plugin.

Best regards,
Nikola

stevegayler answered 6 months ago

Hi Nikola, I have done that, it doesnt look like any reminders should send now until next week, so will check back shortly.   Steve

stevegayler answered 6 months ago

Ive booked a test appointment for tomorrow and then waited to see if I got the reminder:  I have taken some screen shots of the php tables that may help you.
 
rosiesrainbowfishes.co.uk [Tue Apr 16 10:36:07 2019] [error] [client 185.151.30.175:0] WordPress database error Unknown column ‘t.reminder’ in ‘where clause’ for query SELECT a.id
rosiesrainbowfishes.co.uk [Tue Apr 16 10:36:07 2019] [error] [client 185.151.30.175:0] FROM wp_ea_appointments a
rosiesrainbowfishes.co.uk [Tue Apr 16 10:36:07 2019] [error] [client 185.151.30.175:0] LEFT JOIN wp_ea_twilio_reminder t ON (a.id = t.app_id)
rosiesrainbowfishes.co.uk [Tue Apr 16 10:36:07 2019] [error] [client 185.151.30.175:0] WHERE
rosiesrainbowfishes.co.uk [Tue Apr 16 10:36:07 2019] [error] [client 185.151.30.175:0] a.`date` >= ‘2019-04-16’ AND
rosiesrainbowfishes.co.uk [Tue Apr 16 10:36:07 2019] [error] [client 185.151.30.175:0] TIMESTAMPDIFF(MINUTE,CONCAT(a.`date`,’ ‘, a.`start`),’2019-04-16 10:41:07’) > 0 AND
rosiesrainbowfishes.co.uk [Tue Apr 16 10:36:07 2019] [error] [client 185.151.30.175:0] t.id IS NULL AND
rosiesrainbowfishes.co.uk [Tue Apr 16 10:36:07 2019] [error] [client 185.151.30.175:0] t.reminder IS NOT NULL made by do_action_ref_array(‘eac_twilio_sync’), WP_Hook->do_action, WP_Hook->apply_filters, EasyAppointmentsConnect->twilio_sync, EAC_Twilio_Cron->send_reminder, EAC_Twilio_Cron->get_app_ids
rosiesrainbowfishes.co.uk [Tue Apr 16 11:26:28 2019] [error] [client 185.151.30.175:0] WordPress database error Unknown column ‘t.reminder’ in ‘where clause’ for query SELECT a.id
rosiesrainbowfishes.co.uk [Tue Apr 16 11:26:28 2019] [error] [client 185.151.30.175:0] FROM wp_ea_appointments a
rosiesrainbowfishes.co.uk [Tue Apr 16 11:26:28 2019] [error] [client 185.151.30.175:0] LEFT JOIN wp_ea_twilio_reminder t ON (a.id = t.app_id)
rosiesrainbowfishes.co.uk [Tue Apr 16 11:26:28 2019] [error] [client 185.151.30.175:0] WHERE
rosiesrainbowfishes.co.uk [Tue Apr 16 11:26:28 2019] [error] [client 185.151.30.175:0] a.`date` >= ‘2019-04-16’ AND
rosiesrainbowfishes.co.uk [Tue Apr 16 11:26:28 2019] [error] [client 185.151.30.175:0] TIMESTAMPDIFF(MINUTE,CONCAT(a.`date`,’ ‘, a.`start`),’2019-04-16 11:31:28’) > 0 AND
rosiesrainbowfishes.co.uk [Tue Apr 16 11:26:28 2019] [error] [client 185.151.30.175:0] t.id IS NULL AND
rosiesrainbowfishes.co.uk [Tue Apr 16 11:26:28 2019] [error] [client 185.151.30.175:0] t.reminder IS NOT NULL made by do_action_ref_array(‘eac_twilio_sync’), WP_Hook->do_action, WP_Hook->apply_filters, EasyAppointmentsConnect->twilio_sync, EAC_Twilio_Cron->send_reminder, EAC_Twilio_Cron->get_app_ids

stevegayler answered 6 months ago

I could really do with an answer on this as this is now causing problems.  Thanks.  Steve

Nikola Loncar Staff answered 6 months ago

Hi Steve, can you please alter that table and add reminder column.

Best regards,
Nikola

stevegayler replied 6 months ago

I have done this now, what do we do next?