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> 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> *On Behalf Of *Konstantinos > Liadakis > *Sent:* 03.07.2024 17:13 > *To:* 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, 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 >
