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