unicode problem with sqlbox Revision: 62
Konstantinos Liadakis <[email protected]> Wed, 3 Jul 2024 16:13:20 +0300
| Newsgroups | gmane.comp.mobile.kannel.user |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format.
--------------L2kITLPwlgNbWT0kjGHrZMub
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
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
--------------L2kITLPwlgNbWT0kjGHrZMub
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE html>
<html>
<head>
<meta http-equiv=3D"content-type" content=3D"text/html; charset=3DUTF=
-8">
</head>
<body>
Hello,
<div class=3D"moz-forward-container">
<p>I am trying to send unicode using sqlbox but i am unable. I am
getting the following error</p>
<p>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<br>
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<br>
2024-07-03 12:53:37 [46054] [1] ERROR: Could not charset process
message, dropping it!</p>
<p>I am using <br>
</p>
<p>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.</p>
<p>The sqlbox version below <b>does not work with unicode<br>
</b></p>
<p>Working Copy Root Path: /usr/local/src/kannel/sqlbox<br>
URL: <a class=3D"moz-txt-link-freetext"
href=3D"https://svn.kannel.org/sqlbox/trunk"
moz-do-not-send=3D"true">https://svn.kannel.org/sqlbox/trunk</a=
><br>
Relative URL: ^/trunk<br>
Repository Root: <a class=3D"moz-txt-link-freetext"
href=3D"https://svn.kannel.org/sqlbox" moz-do-not-send=3D"true"=
>https://svn.kannel.org/sqlbox</a><br>
Revision: 62<br>
Node Kind: directory<br>
Schedule: normal<br>
Last Changed Author: stolj<br>
Last Changed Rev: 62<br>
Last Changed Date: 2023-03-09 11:22:07 +0000 (Thu, 09 Mar 2023)</=
p>
<p><br>
</p>
<p>I am having an older instance where unicode from sqlbox <b>works=
</b>
with no problem</p>
<p>Path: .<br>
Working Copy Root Path: /usr/local/src/kannel/sqlbox<br>
URL: <a class=3D"moz-txt-link-freetext"
href=3D"https://svn.kannel.org/sqlbox/trunk"
moz-do-not-send=3D"true">https://svn.kannel.org/sqlbox/trunk</a=
><br>
Relative URL: ^/trunk<br>
Repository Root: <a class=3D"moz-txt-link-freetext"
href=3D"https://svn.kannel.org/sqlbox" moz-do-not-send=3D"true"=
>https://svn.kannel.org/sqlbox</a><br>
Revision: 58<br>
Node Kind: directory<br>
Schedule: normal<br>
Last Changed Author: rkluwen<br>
Last Changed Rev: 58<br>
Last Changed Date: 2017-07-12 23:38:55 +0300 (Wed, 12 Jul 2017)</=
p>
<p>I am using coding=3D2 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<br>
</p>
<p>I tried applying the sqlbox patch but nothing changed. Maybe i
am missing something? When should the patch be applied?<br>
</p>
<p>Thank you in advance for your help=C2=A0</p>
<p>regards<br>
</p>
<p>Dinos<br>
</p>
</div>
</body>
</html>
--------------L2kITLPwlgNbWT0kjGHrZMub--