Hi Mesbah, According to Dinos’ logs something messed in table itself. 2024-07-03 12:53:37 [46054] [1] ERROR: MYSQL: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 2024-07-03 12:53:37 [46054] [1] ERROR: MYSQL: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1 2024-07-03 12:53:37 [46054] [1] ERROR: Could not charset process message, dropping it!
Of course someone who knows table scheme, sqlbox working logic and of course what he is doing, he can change/add columns to table. But if anybody using kannel first time it’s better to leave sqlbox to create tables. Below you can see screen how kannel encodes and saves Unicode message in mysql table called SentTable(default name) [cid:image001.png@01DACD8C.3F255E20] Best regards, Ruben Melikyan From: Mesbahuddin Malik <mesbah.ma...@gmail.com> Sent: 03.07.2024 20:24 To: Ruben Melikyan <r...@mobbis.am> Cc: Konstantinos Liadakis <kliada...@yuboto.com>; users@kannel.org Subject: Re: unicode problem with sqlbox Revision: 62 Hello Ruben Melikyan, Did u get his problem on unicode.Table creation is optional you can make modify on the table keep charset table to default utf-8 for unicode sms. Regards Mesbah On Wed, Jul 3, 2024 at 10:07 PM Ruben Melikyan <r...@mobbis.am<mailto:r...@mobbis.am>> wrote: Hi, Obviously you have problem with your mysql database tables. You can leave table creation to sqlbox itself. This is the best way. Just leave database empty and run kannel. If your kannel configured properly, sqlbox will create tables automatically. Referring to sqlbox documentation: Database Tables Sqlbox creates it's DB tables on the fly if the tables are not present at that moment. P.S. Kannel’s sqlbox saving SMS message incliding unicode in encoded format. Best regards, Ruben Melikyan From: users <users-boun...@kannel.org<mailto:users-boun...@kannel.org>> On Behalf Of Konstantinos Liadakis Sent: 03.07.2024 17:13 To: users@kannel.org<mailto:users@kannel.org> Subject: unicode problem with sqlbox Revision: 62 Hello, I am trying to send unicode using sqlbox but i am unable. I am getting the following error 2024-07-03 12:53:37 [46054] [1] ERROR: MYSQL: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 2024-07-03 12:53:37 [46054] [1] ERROR: MYSQL: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1 2024-07-03 12:53:37 [46054] [1] ERROR: Could not charset process message, dropping it! I am using Kannel bearerbox version `svn-r5335M'. Build `Apr 21 2024 15:23:40', compiler `11.4.0'. System Linux, release 5.15.0-113-generic, version #123-Ubuntu SMP Mon Jun 10 08:16:17 UTC 2024, machine x86_64. Hostname kannel3.srv.example.com<http://kannel3.srv.example.com>, IP 1.1.1.1 Libxml version 2.9.13. Using OpenSSL 3.0.2 15 Mar 2022. Compiled with MySQL 8.0.36, using MySQL 8.0.37. Using hiredis API 0.14.1 Using native malloc. The sqlbox version below does not work with unicode Working Copy Root Path: /usr/local/src/kannel/sqlbox URL: https://svn.kannel.org/sqlbox/trunk Relative URL: ^/trunk Repository Root: https://svn.kannel.org/sqlbox Revision: 62 Node Kind: directory Schedule: normal Last Changed Author: stolj Last Changed Rev: 62 Last Changed Date: 2023-03-09 11:22:07 +0000 (Thu, 09 Mar 2023) I am having an older instance where unicode from sqlbox works with no problem Path: . Working Copy Root Path: /usr/local/src/kannel/sqlbox URL: https://svn.kannel.org/sqlbox/trunk Relative URL: ^/trunk Repository Root: https://svn.kannel.org/sqlbox Revision: 58 Node Kind: directory Schedule: normal Last Changed Author: rkluwen Last Changed Rev: 58 Last Changed Date: 2017-07-12 23:38:55 +0300 (Wed, 12 Jul 2017) I am using coding=2 and charset utf-8 and messages are url encoded. In fact same query that works on old sqlbox does not work on the newer one giving the charset error above I tried applying the sqlbox patch but nothing changed. Maybe i am missing something? When should the patch be applied? Thank you in advance for your help regards Dinos
