Re: unicode problem with sqlbox Revision: 62
Mesbahuddin Malik <[email protected]> Wed, 3 Jul 2024 22:23:30 +0600
| Newsgroups | gmane.comp.mobile.kannel.user |
|---|---|
| Message-ID | <CAG=0pxw_BummpRWpVrqegRWPumQDukWJNukO7v1gCGe=gHt2Xw@mail.gmail.com> |
--000000000000015bf0061c5a41e7 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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=E2=80=AFPM Ruben Melikyan <[email protected]> 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=E2=80=99s sqlbox saving SMS message incliding unicode in enco= ded > format. > > *Best regards,* > > *Ruben Melikyan* > > > > *From:* users <[email protected]> *On Behalf Of *Konstantinos > Liadakis > *Sent:* 03.07.2024 17:13 > *To:* [email protected] > *Subject:* unicode problem with sqlbox Revision: 62 > > > > Hello, > > I am trying to send unicode using sqlbox but i am unable. I am getting th= e > 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=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 > > 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 > --000000000000015bf0061c5a41e7 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr">Hello=C2=A0 <b style=3D"font-family:"Times New Roman",serif;font-size:16px">R= uben Melikyan,</b><div><b style=3D"font-family:"Times New Roman",= serif;font-size:16px">Did u get his problem on unicode.Table creation is op= tional you can make modify on the table=C2=A0 keep charset table to default= utf-8=C2=A0 for unicode sms.</b></div><div><b style=3D"font-family:"T= imes New Roman",serif;font-size:16px"><br></b></div><div><b style=3D"f= ont-family:"Times New Roman",serif;font-size:16px">Regards</b></d= iv><div><b style=3D"font-family:"Times New Roman",serif;font-size= :16px">Mesbah</b></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr= " class=3D"gmail_attr">On Wed, Jul 3, 2024 at 10:07=E2=80=AFPM Ruben Meliky= an <<a href=3D"mailto:[email protected]">[email protected]</a>> wrote:<br></div= ><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border= -left:1px solid rgb(204,204,204);padding-left:1ex"><div class=3D"msg-318954= 4337545830681"> <div lang=3D"EN-US" style=3D"overflow-wrap: break-word;"> <div class=3D"m_-3189544337545830681WordSection1"> <p class=3D"MsoNormal"><a name=3D"m_-3189544337545830681__Hlk120024655"><sp= an lang=3D"EN-GB">Hi,<u></u><u></u></span></a></p> <p class=3D"MsoNormal"><span><span lang=3D"EN-GB">Obviously you have proble= m with your mysql database tables.<u></u><u></u></span></span></p> <p class=3D"MsoNormal"><span><span lang=3D"EN-GB">You can leave table creat= ion to sqlbox itself. This is the best way.<u></u><u></u></span></span></p> <p class=3D"MsoNormal"><span><span lang=3D"EN-GB"><u></u>=C2=A0<u></u></spa= n></span></p> <p class=3D"MsoNormal"><span><span lang=3D"EN-GB">Just leave database empty= and run kannel. If your kannel configured properly, sqlbox will create tab= les automatically.<u></u><u></u></span></span></p> <p class=3D"MsoNormal"><span><span lang=3D"EN-GB"><u></u>=C2=A0<u></u></spa= n></span></p> <p class=3D"MsoNormal"><span><span lang=3D"EN-GB">Referring to sqlbox docum= entation:<u></u><u></u></span></span></p> <p class=3D"MsoNormal" style=3D"background:white"> <span><a name=3D"m_-3189544337545830681_AEN473"><b><span style=3D"font-size= :13.5pt;font-family:"Times New Roman",serif;color:black">Database= Tables</span></b></a></span><span><b><span style=3D"font-size:13.5pt;font-= family:"Times New Roman",serif;color:black"><u></u><u></u></span>= </b></span></p> <p class=3D"MsoNormal" style=3D"background:white"> <span><span style=3D"font-size:13.5pt;font-family:"Times New Roman&quo= t;,serif;color:black">Sqlbox creates it's DB tables on the fly if the t= ables are not present at that moment.<u></u><u></u></span></span></p> <p class=3D"MsoNormal"><span><span lang=3D"EN-GB"><u></u>=C2=A0<u></u></spa= n></span></p> <p class=3D"MsoNormal"><span><span lang=3D"EN-GB">P.S. Kannel=E2=80=99s sql= box saving SMS message incliding unicode in encoded format.<u></u><u></u></= span></span></p> <span></span> <div> <p class=3D"MsoNormal"><b><span style=3D"font-size:12pt;font-family:"T= imes New Roman",serif">Best regards,</span></b><span style=3D"font-siz= e:12pt;font-family:"Times New Roman",serif"> <br> <br> <b>Ruben Melikyan<u></u><u></u></b></span></p> </div> <p class=3D"MsoNormal"><span lang=3D"EN-GB"><u></u>=C2=A0<u></u></span></p> <div> <div style=3D"border-right:none;border-bottom:none;border-left:none;border-= top:1pt solid rgb(225,225,225);padding:3pt 0in 0in"> <p class=3D"MsoNormal"><b>From:</b> users <<a href=3D"mailto:users-bounc= [email protected]" target=3D"_blank">[email protected]</a>> <b>On Beh= alf Of </b>Konstantinos Liadakis<br> <b>Sent:</b> 03.07.2024 17:13<br> <b>To:</b> <a href=3D"mailto:[email protected]" target=3D"_blank">users@kann= el.org</a><br> <b>Subject:</b> unicode problem with sqlbox Revision: 62<u></u><u></u></p> </div> </div> <p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p> <p class=3D"MsoNormal">Hello, <u></u><u></u></p> <div> <p>I am trying to send unicode using sqlbox but i am unable. I am getting t= he following error<u></u><u></u></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 versio= n 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 f= or the right syntax to use near ')' at line 1<br> 2024-07-03 12:53:37 [46054] [1] ERROR: Could not charset process message, d= ropping it!<u></u><u></u></p> <p>I am using <u></u><u></u></p> <p>Kannel bearerbox version `svn-r5335M'. Build `Apr 21 2024 15:23:40&#= 39;, compiler `11.4.0'. System Linux, release 5.15.0-113-generic, versi= on #123-Ubuntu SMP Mon Jun 10 08:16:17 UTC 2024, machine x86_64. Hostname <= a href=3D"http://kannel3.srv.example.com" target=3D"_blank">kannel3.srv.exa= mple.com</a>, 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.<u></u><u></u><= /p> <p>The sqlbox version below <b>does not work with unicode</b><u></u><u></u>= </p> <p>Working Copy Root Path: /usr/local/src/kannel/sqlbox<br> URL: <a href=3D"https://svn.kannel.org/sqlbox/trunk" target=3D"_blank">http= s://svn.kannel.org/sqlbox/trunk</a><br> Relative URL: ^/trunk<br> Repository Root: <a href=3D"https://svn.kannel.org/sqlbox" target=3D"_blank= ">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)<u></u><u></= u></p> <p><u></u>=C2=A0<u></u></p> <p>I am having an older instance where unicode from sqlbox <b>works</b> wit= h no problem<u></u><u></u></p> <p>Path: .<br> Working Copy Root Path: /usr/local/src/kannel/sqlbox<br> URL: <a href=3D"https://svn.kannel.org/sqlbox/trunk" target=3D"_blank">http= s://svn.kannel.org/sqlbox/trunk</a><br> Relative URL: ^/trunk<br> Repository Root: <a href=3D"https://svn.kannel.org/sqlbox" target=3D"_blank= ">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)<u></u><u></= u></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 gi= ving the charset error above<u></u><u></u></p> <p>I tried applying the sqlbox patch but nothing changed. Maybe i am missin= g something? When should the patch be applied?<u></u><u></u></p> <p>Thank you in advance for your help=C2=A0<u></u><u></u></p> <p>regards<u></u><u></u></p> <p>Dinos<u></u><u></u></p> </div> </div> </div> </div></blockquote></div> --000000000000015bf0061c5a41e7--