Re: unicode problem with sqlbox Revision: 62
Konstantinos Liadakis <[email protected]> Thu, 4 Jul 2024 01:20:58 +0300
| Newsgroups | gmane.comp.mobile.kannel.user |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --------------rugkbL1eaekiZXPiK9ef2i4W Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable Hello Ruben, and thank you for your reply. The tables were created automatically from sqlbox like you propose. In=20 fact i have dropped the tables a few times but no change Regards Dinos On 3/7/24 19:06, Ruben Melikyan 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=20 > 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=20 > at that moment. > > P.S. Kannel=E2=80=99s sqlbox saving SMS message incliding unicode in en= coded=20 > format. > > *Best regards,* > > *Ruben Melikyan* > > *From:* users <[email protected]> *On Behalf Of *Konstantinos=20 > 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=20 > the following error > > 2024-07-03 12:53:37 [46054] [1] ERROR: MYSQL: You have an error in=20 > your SQL syntax; check the manual that corresponds to your MariaDB=20 > 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=20 > your SQL syntax; check the manual that corresponds to your MariaDB=20 > 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=20 > message, dropping it! > > I am using > > Kannel bearerbox version `svn-r5335M'. Build `Apr 21 2024 15:23:40',=20 > compiler `11.4.0'. System Linux, release 5.15.0-113-generic, version=20 > #123-Ubuntu SMP Mon Jun 10 08:16:17 UTC 2024, machine x86_64. Hostname=20 > kannel3.srv.example.com, IP 1.1.1.1 Libxml version 2.9.13. Using=20 > OpenSSL 3.0.2 15 Mar 2022. Compiled with MySQL 8.0.36, using MySQL=20 > 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=20 > 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. I= n=20 > fact same query that works on old sqlbox does not work on the newer=20 > one giving the charset error above > > I tried applying the sqlbox patch but nothing changed. Maybe i am=20 > missing something? When should the patch be applied? > > Thank you in advance for your help > > regards > > Dinos > --------------rugkbL1eaekiZXPiK9ef2i4W 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> <p>Hello Ruben, and thank you for your reply.</p> <p>The tables were created automatically from sqlbox like you propose. In fact i have dropped the tables a few times but no change</p> <p>Regards</p> <p>Dinos<br> </p> <div class=3D"moz-cite-prefix">On 3/7/24 19:06, Ruben Melikyan wrote:= <br> </div> <blockquote type=3D"cite" cite=3D"mid:[email protected].= PROD.OUTLOOK.COM"> <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DU= TF-8"> <meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)"> <style>@font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; font-size:11.0pt; font-family:"Calibri",sans-serif;}a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;}span.EmailStyle21 {mso-style-type:personal-compose; font-family:"Calibri",sans-serif; color:windowtext;}.MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;}div.WordSection1 {page:WordSection1;}</style><!--[if gte mso 9]><xml> <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext=3D"edit"> <o:idmap v:ext=3D"edit" data=3D"1" /> </o:shapelayout></xml><![endif]--> <div class=3D"WordSection1"> <p class=3D"MsoNormal"><a name=3D"_Hlk120024655" moz-do-not-send=3D"true"><span lang=3D"EN-GB">Hi,<o:p></o:p><= /span></a></p> <p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"= ><span lang=3D"EN-GB">Obviously you have problem with your mysql database tables.<o:p></o:p></span></span></p> <p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"= ><span lang=3D"EN-GB">You can leave table creation to sqlbox itself. This is the best way.<o:p></o:p></span></span></p> <p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"= ><span lang=3D"EN-GB"><o:p>=C2=A0</o:p></span></span></p> <p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"= ><span lang=3D"EN-GB">Just leave database empty and run kannel. If your kannel configured properly, sqlbox will create tables automatically.<o:p></o:p></span></span></p> <p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"= ><span lang=3D"EN-GB"><o:p>=C2=A0</o:p></span></span></p> <p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"= ><span lang=3D"EN-GB">Referring to sqlbox documentation:<o:p></o:p= ></span></span></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:wh= ite"> <span style=3D"mso-bookmark:_Hlk120024655"><a name=3D"AEN473" moz-do-not-send=3D"true"><b><span style=3D"font-size:13.5pt;font-family:"Times New Roman",serif;c= olor:black">Database Tables</span></b></a></span><span style=3D"mso-bookmark:_Hlk120024655"><b><span style=3D"font-size:13.5pt;font-family:"Times New Roman",serif;c= olor:black"><o:p></o:p></span></b></span></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:wh= ite"> <span style=3D"mso-bookmark:_Hlk120024655"><span style=3D"font-size:13.5pt;font-family:"Times New Roman",serif;c= olor:black">Sqlbox creates it's DB tables on the fly if the tables are not present at that moment.<o:p></o:p></span></span></p> <p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"= ><span lang=3D"EN-GB"><o:p>=C2=A0</o:p></span></span></p> <p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"= ><span lang=3D"EN-GB">P.S. Kannel=E2=80=99s sqlbox saving SMS mess= age incliding unicode in encoded format.<o:p></o:p></span></spa= n></p> <span style=3D"mso-bookmark:_Hlk120024655"></span> <div> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto"><b><sp= an style=3D"font-size:12.0pt;font-family:"Times New Roman",serif">= Best regards,</span></b><span style=3D"font-size:12.0pt;font-family:"Times New Roman",serif"> <br> <br> <b>Ruben Melikyan<o:p></o:p></b></span></p> </div> <p class=3D"MsoNormal"><span lang=3D"EN-GB"><o:p>=C2=A0</o:p></sp= an></p> <div> <div style=3D"border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in= 0in"> <p class=3D"MsoNormal"><b>From:</b> users <a class=3D"moz-txt-link-rfc2396E" href=3D"mailto:users-bou= [email protected]"><[email protected]></a> <b>On Behalf Of </b>Konstantinos Liadakis<br> <b>Sent:</b> 03.07.2024 17:13<br> <b>To:</b> <a class=3D"moz-txt-link-abbreviated" href=3D"ma= ilto:[email protected]">[email protected]</a><br> <b>Subject:</b> unicode problem with sqlbox Revision: 62<o:= p></o:p></p> </div> </div> <p class=3D"MsoNormal"><o:p>=C2=A0</o:p></p> <p class=3D"MsoNormal">Hello, <o:p></o:p></p> <div> <p>I am trying to send unicode using sqlbox but i am unable. I am getting the following error<o:p></o:p></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!<o:p></o:p></p> <p>I am using <o:p></o:p></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.<o:p></o:p></p> <p>The sqlbox version below <b>does not work with unicode</b><o= :p></o:p></p> <p>Working Copy Root Path: /usr/local/src/kannel/sqlbox<br> URL: <a href=3D"https://svn.kannel.org/sqlbox/trunk" moz-do-not-send=3D"true" class=3D"moz-txt-link-freetext">ht= tps://svn.kannel.org/sqlbox/trunk</a><br> Relative URL: ^/trunk<br> Repository Root: <a href=3D"https://svn.kannel.org/sqlbox" moz-do-not-send=3D"true" class=3D"moz-txt-link-freetext">ht= tps://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)<o:p></o:p></p> <p><o:p>=C2=A0</o:p></p> <p>I am having an older instance where unicode from sqlbox <b>w= orks</b> with no problem<o:p></o:p></p> <p>Path: .<br> Working Copy Root Path: /usr/local/src/kannel/sqlbox<br> URL: <a href=3D"https://svn.kannel.org/sqlbox/trunk" moz-do-not-send=3D"true" class=3D"moz-txt-link-freetext">ht= tps://svn.kannel.org/sqlbox/trunk</a><br> Relative URL: ^/trunk<br> Repository Root: <a href=3D"https://svn.kannel.org/sqlbox" moz-do-not-send=3D"true" class=3D"moz-txt-link-freetext">ht= tps://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)<o:p></o:p></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<o:p>= </o:p></p> <p>I tried applying the sqlbox patch but nothing changed. Maybe i am missing something? When should the patch be applied?<o:p></o:p></p> <p>Thank you in advance for your help=C2=A0<o:p></o:p></p> <p>regards<o:p></o:p></p> <p>Dinos<o:p></o:p></p> </div> </div> </blockquote> </body> </html> --------------rugkbL1eaekiZXPiK9ef2i4W--