[solved] Can't send Emoji

Hamidreza_Mahmoudi · February 17, 2021, 8:52pm

Hello.
Im using playsms with Generic Gateway and I can not sending emoji and all of text after emoji will be cut.
how can I fix it ?
thank you.

Hamidreza_Mahmoudi · February 20, 2021, 11:20pm

I installed clean playsms, and still have this problem.

anton · February 21, 2021, 9:02am

How to reproduce the issue so I can try it.

I dont need to know which gateway you’re submitting to, but I need to know how the URL be when sending that emoji. Thus I need to know how you send the emoji, which emoji.

Anton

Hamidreza_Mahmoudi · February 28, 2021, 7:50pm

Hello.
I can not send most of Emoji.
and the outgoing URL from server is without emoji. ( I think playsms prevent to put it to DB or something like this)
for example I can send these emoji as successfully without any problem
But when I put these emoji to message. emoji and all text after emoji will be cut.
you can try it.
thank you.

anton · March 1, 2021, 7:50am

I dont see anything out of ordinary in Generic plugin, perhaps you can try to send it to other gateway, for example to Twilio/Nexmo for tests.

anton

Hamidreza_Mahmoudi · March 4, 2021, 10:36am

hi Mr anton.
its not gateway problem.
I think its mysql problem.
becasue I can not save emoji in message template too and all text after emoji will be cut.
see this video. https://filebin.net/28fhsf4pr3g1j3lt/problem.mp4?t=sgvu6hho

anton · March 5, 2021, 11:28am

What device do you use to type emoji ? LIke I asked earlier, how to reproduce this issue exactly ? As far as I know, emoji, may be different from apps to apps.

I tested from Firefox on my android, see screenshots:

Message template:

Compose message:

My sent messages:

anton

Hamidreza_Mahmoudi · March 7, 2021, 6:26pm

thank you
I think this problem for Collation in mysql. because I can not insert Emoji in mysql p_msg manually.

Hamidreza_Mahmoudi · March 7, 2021, 7:02pm

I change colleation in mysql from utf8_general_ci to utf8mb4_unicode_ci.
I can insert emoji manually on mysql now.
but when I try to insert with playsms every emoji convert to three question marks

Hamidreza_Mahmoudi · April 5, 2021, 12:43pm

hello.
I tried to create new standalone php/mysql file to insert emoji to db. and it was success without any problem.
after that I put insert code to /playsms/plugin/core/sendsms/sendsms.php file and emojies convert to question mark after inserting.

so every emoji inserting with playsms engine will be convert to question mark.
what do you think about this problem ? thank you.

            // SMS message
            $message = $_REQUEST['message'];
            $db_query2 = "INSERT INTO test (name, last, id , id2) VALUES ('$message', 'test', '1', '1' )";
            $db_result = dba_query($db_query2);

Hamidreza_Mahmoudi · April 11, 2021, 11:05am

no any suggestion ???

anton · April 11, 2021, 9:08pm

Hi, so far I don’t know what happened.

anton

Hamidreza_Mahmoudi · April 11, 2021, 10:24pm

Which file or section I must will check ?
because every emoji inject with playsms to DB will be question mark.
everything is ok if I insert emoji to playsms DB directly.

pleas help me.
thank you in advance.

anton · April 12, 2021, 2:32am

try comment or edit this line:

github.com

playsms/playsms/blob/1.4.3/web/init.php#L209


// connect to database
if (!($dba_object = dba_connect(_DB_USER_, _DB_PASS_, _DB_NAME_, _DB_HOST_, _DB_PORT_))) {
	
	// _log('Fail to connect to database', 4, 'init');
	ob_end_clean();
	die(_('FATAL ERROR') . ' : ' . _('Fail to connect to database'));
}
// set charset to UTF-8
dba_query('SET NAMES utf8');
// get main config from registry and load it to $core_config['main']
$result = registry_search(1, 'core', 'main_config');
foreach ($result['core']['main_config'] as $key => $val) {
	$ {
		$key
	} = $val;
	$core_config['main'][$key] = $val;
}

anton

Hamidreza_Mahmoudi · April 12, 2021, 10:02am

Wow. it worked.
thank you in advane.
you help me so much nowadays.

thank again.

anton · April 12, 2021, 1:36pm

So what did you do? Remove/comment it or change it to another charset ?

Anton

Hamidreza_Mahmoudi · April 12, 2021, 1:38pm

I changed it to utf8mb4
and change all msg/text sql collation to utf8mb4_general

Nabil_Bo · May 7, 2021, 8:16pm

Hello Hamidreza I have exactly the same issue when sending text with emoji I receive question mark in the destination phone. Thanks to Anton I changed the init.php and I changed DB and tables collation and characterset but still same issue. When I look in the playsms interface the text sent I can see the emojis.
So when you say “and change all msg/text sql collation to utf8mb4_general” what do you mean exactly? Maybe I missed something.

Thanks in advance for your help

Hamidreza_Mahmoudi · May 15, 2021, 9:22am

hello my friend.
I changed to lation to utf8mb4_general in text field in outgoing and outgoin_queue table and p_text in msgTemplate table.

Nabil_Bo · May 21, 2021, 9:24pm

Hello my friend,
Thank you very much for your help. I was able to do the changes.
Unfortunately I can see in playsms the emojis but not in the destination phone we still receive a ? character instead of the emoji. Maybe a limitation with smstools3.
Sorry for maybe this stupid question but what is the generic gateway? how do use it? can I use it with a USB GSM modem?

Thanks in advance

Topic		Replies	Views
Can’t send Emoji Help	2	556	August 15, 2022
Generic Gateway unicode SMS problem Help	1	805	January 23, 2019
[solved] Is playsms support read Japanese/other languages message? Help	9	2431	April 8, 2016
Send Sms not complet with playsms help please Help	0	737	September 16, 2016
Sent Messages showing empty Help	2	245	May 5, 2023

[solved] Can't send Emoji

Related topics