Support forumCategory: BugsSubmit Button is not showing
stevegayler asked 1 week 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?

4 Answers
Nikola Loncar Staff answered 5 days 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 4 days ago

Does this help?

Nikola Loncar Staff answered 4 days 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 3 days 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 3 days 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