Submit Button is not showing

Support › Submit Button is not showing
0 Vote Up Vote Down
stevegayler Staff asked 6 years 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
0 Vote Up Vote Down
Nikola Loncar Staff answered 6 years ago
Hi Steve, can you please tell me do you have any error inside PHP log file on your server? Best regards, Nikola
stevegayler Staff replied 6 years ago

Does this help?

…

0 Vote Up Vote Down
Nikola Loncar Staff answered 6 years 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
0 Vote Up Vote Down
stevegayler Staff answered 6 years 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
0 Vote Up Vote Down
stevegayler Staff answered 6 years 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

0 Vote Up Vote Down
stevegayler Staff answered 6 years ago
I could really do with an answer on this as this is now causing problems.  Thanks.  Steve
0 Vote Up Vote Down
Nikola Loncar Staff answered 6 years ago
Hi Steve, can you please alter that table and add reminder column. Best regards, Nikola
stevegayler Staff replied 6 years ago

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