fail to finalize queue creation, exit immediately - empty value in column unicode

[takenek]

Hey
Latest stable PlaySMS 1.4.5 version - i install fresh version and same efect.

OS: Raspbian 11
PHP version: PHP 7.4.33 (cli) (built: Jun 9 2023 16:51:37) ( NTS )
MariaDB: 10.5.19-0+deb11u2

LOG:

• • 2023-09-17 12:33:00 PID6506d5dbbb636 admin L2 sendsms # start uid:1 sender_id:[1234] smsc:[]
• • 2023-09-17 12:33:00 PID6506d5dbbb636 admin L2 sendsms_queue_create # saving queue_code:f8eddde0d805b3e03d30c4e2e9c631f1 src:1234 scheduled:2023-09-17 12:33:00
• • 2023-09-17 12:33:00 PID6506d5dbbb636 admin L2 sendsms # fail to finalize queue creation, exit immediately

DEUBUG LOG

• • 2023-09-17 12:36:00 PID6506d68f9c7b5 admin L2 sendsms # start uid:1 sender_id:[1234] smsc:[]
• • 2023-09-17 12:36:00 PID6506d68f9c7b5 admin L3 sendsms # maxlen:918 footerlen:0 footer:[] msglen:12 message:[POCZTA_TEST5]
• • 2023-09-17 12:36:00 PID6506d68f9c7b5 admin L2 sendsms_queue_create # saving queue_code:12aeba1b3c49d7b0cb31fd4269e593bd src:1234 scheduled:2023-09-17 12:36:00
• • 2023-09-17 12:36:00 PID6506d68f9c7b5 admin L4 dba__query # q:INSERT INTO playsms_tblSMSOutgoing_queue (queue_code,datetime_entry,datetime_scheduled,uid,gpid,sender_id,footer,message,sms_type,unicode,smsc,flag) VALUES ('12aeba1b3c49d7b0cb31fd4269e593bd','2023-09-17 11:36:00','2023-09-17 11:36:00','1','0','1234','','POCZTA_TEST5','','','','2')
• • 2023-09-17 12:36:00 PID6506d68f9c7b5 admin L4 dba__query # q:SELECT @@IDENTITY
• • 2023-09-17 12:36:00 PID6506d68f9c7b5 admin L2 sendsms # fail to finalize queue creation, exit immediately

Like you see he is unable to create queue.

I try from hand this and:

MariaDB [playsms]> INSERT INTO playsms_tblSMSOutgoing_queue (queue_code,datetime_entry,datetime_scheduled,uid,gpid,sender_id,footer,message,sms_type,unicode,smsc,flag) VALUES ('12aeba1b3c49d7b0cb31fd4269e593bd','2023-09-17 11:36:00','2023-09-17 11:36:00','1','0','1234','','POCZTA_TEST5','','','','2');
and get:
ERROR 1366 (22007): Incorrect integer value: '' for column `playsms`.`playsms_tblSMSOutgoing_queue`.`unicode` at row 1

Like You see there is empty value in column unicode.

[antonraharja]

Hi, try to edit like this:
10feab5

make sure $unicode in an int, it should be not empty but quick check I haven't found anywhere why its empty, so lets just try by making it sure its an int

[takenek]

Hey,
Before upgrade to Raspbian 11 everything was working good looks like this is PHP issue.

I find in google this and working good:

"basically you need to insert below codes starts in line 698 in web/plugin/core/sendsms/fn.php:
// default values
$sms_type = strtolower(trim($sms_type));
if ($sms_type != 'text') {
$sms_type = 'text';
}
$unicode = ( (int) $unicode ? 1 : 0 );
"