Mass SMS recipients count

Question

Wordpress 5.5.3, CiviCRM 5.31.0. While testing Mass SMS with new Twilio account we've discovered it does not quite work. Searching for a solution here and across lab.civicrm.org haven't helped much. Logs are empty so it is not an error or is not considered as an error by CiviCRM. The most popular related solution ( replace "is_deceased" from NULl to 0 in the database ) hasn't helped. Mass mailing works fine and the number of recipiens counted is correct. Individual SMS sending works also. The only clues we have are:

• "Send SMS" action is not visible for individual contacts.
• Attempt to create Mass SMS for all contacts in the database ( around 10 000 ) displays only 5 contacts on "Total Recipients: 5" counter. Probably it is something with data in the database. We were having big updates for both wordpress and civi past weeks on a decent hosting so things might have been a little messy. The question is, where to start with debugging. Perhaps, if we saw which exactly contacts were counted, we would be able to find what all these 5 have in common and figure out the next steps. Any clue will be helpful.

Answer 1

The only logical explanation to the above was that someone had overwritten Phone to Mobile and Mobile to Phone which was why you were seeing perverse results.

Checking in log_civicrm_option_value table for option_group_id = 35 (which is phone type) and seeing if it has changed and if so when/who may confirm this

Answer 2

Kudos to Demerit and petednz-fuzion for helpful pointers, see below:

• Demerit: Dummy SMS extension
• petednz-fuzion: check your log_civicrm_option_value table for option_group_id = 35 to see who changed it

---

It is possible to find recipients of each mailing (even scheduled/not sent) via MySQL following these steps:

1. Table log_civicrm_mailing gives us our Mass SMS id
2. Table civicrm_mailing_recipients contains all recipients of all mailings (mass sms included) in the format: mailing_id/contact_id/email_id/phone_id
3. From here we can explore each "phone_id" record in civicrm_phone table, where we can see "phone_type_id".

And this is a funny part: all my 5 recipients have phone_type_id=2 ("Phone") while "Mobile" phone type has phone_type_id=1. So, it seems Mass SMS in my case checks if phone type is Phone, not Mobile.

Advanced Search by "Phone type=Phone" returns only 3 numbers, but it seems to be another story. Perhaps, it worth checking what exactly happens on line 227 of \CRM\Mailing\BAO\Mailing.php in this regards:

'location_filter' => CRM_Utils_SQL_Select::fragment()->where("$entityTable.phone_type_id = " . CRM_Core_PseudoConstant::getKey('CRM_Core_DAO_Phone', 'phone_type_id', 'Mobile')),