SMS works but I get an error message

Support › SMS works but I get an error message
0 Vote Up Vote Down
stephan Staff asked 3 years ago
I'm using the SMS feature and it's working - Messages are sent via Twilio and are delivered. However, I get an error message each time via email from my server. It says: [HTTP 400] Unable to create record: The 'To' number 0222222222 is not a valid phone number. (but with a real phone number).   In the settings, I've got +64 set as the country code, where it says "you can allow customer to enter numbers without country part. This part will be added before number that customer entered. NOTE: leading 0 will be removed. If you don't want to use it leave it blank."   The "to" phone number it is complaining about is always the number of the person who owns the website, not the customer that we are sending the SMS to. Originally when I set up the plugin, I did not put in the +64 country code option. The messages still send successfully.   Thanks for your help!
3 Answers
0 Vote Up Vote Down
Nikola Loncar Staff answered 3 years ago
Hi Stephan, do you have access to database? There should be table named ea_twilio_reminder. Can you please check that? Best regards, Nikola
stephan Staff replied 3 years ago

Does this help?

MariaDB [ldg]> select * from wp_ldgea_twilio_reminder;
+—-+——–+———————+———-+
| id | app_id | created_at | reminder |
+—-+——–+———————+———-+
| 1 | 35 | 2021-10-22 07:55:03 | 1 |
| 2 | 29 | 2021-10-22 08:00:05 | 1 |
| 3 | 42 | 2021-10-22 18:05:03 | 1 |
| 4 | 43 | 2021-10-25 18:05:04 | 1 |
| 5 | 46 | 2021-10-28 18:05:03 | 1 |
| 6 | 47 | 2021-10-28 21:35:02 | 1 |
| 7 | 44 | 2021-10-29 18:05:03 | 1 |
| 8 | 50 | 2021-11-01 18:05:03 | 1 |
| 9 | 52 | 2021-11-01 21:35:03 | 1 |
| 10 | 53 | 2021-11-02 18:05:03 | 1 |
| 11 | 51 | 2021-11-02 21:35:03 | 1 |
+—-+——–+———————+———-+
11 rows in set (0.000 sec)

I’ve got access so can look at whatever is needed but need expert guidance, I think 🙂 My SQL is quite rusty.

Thanks.

0 Vote Up Vote Down
stephan Staff answered 3 years ago
This went away by itself.
0 Vote Up Vote Down
Nikola Loncar Staff answered 3 years ago
Hi Stephan, can you please confirm this is working now without error logs? Best regards, Nikola
stephan Staff replied 3 years ago

Yes it’s all fine now, thanks. I think when I initially set everything up, perhaps I didn’t put the country code in, then changed it later. There must have been bookings in the database that were coming up, which didn’t have the right format and now, they must all be using the correct format.
Thanks for asking.