Re: unicode problem with sqlbox Revision: 62
Ruben Melikyan <[email protected]> Fri, 5 Jul 2024 08:32:21 +0000
| Newsgroups | gmane.comp.mobile.kannel.user |
|---|---|
| Message-ID | <PAVP195MB22338A94CD246941E33B787EDFDF2@PAVP195MB2233.EURP195.PROD.OUTLOOK.COM> |
--_000_PAVP195MB22338A94CD246941E33B787EDFDF2PAVP195MB2233EURP_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi Dinos, I haven=92t any additional idea. Probably it=92s bug. Request should work a= s expected. I think using old version is the best decision in this situation. Best regards, Ruben Melikyan ________________________________ From: Konstantinos Liadakis <[email protected]> Sent: Friday, July 5, 2024 12:20:49 PM To: Ruben Melikyan <[email protected]>; [email protected] <[email protected]> Subject: Re: unicode problem with sqlbox Revision: 62 Hello, i tried your query and get exactly the same error 2024-07-05 08:18:57 [51778] [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 2024-07-05 08:18:57 [51778] [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 2024-07-05 08:18:57 [51778] [1] ERROR: Could not charset process message, d= ropping it! I dont believe there is something wrong with my query or database/table set= up as using exactly same query on old system everything works as expected If i cannot find a solution i will compile to new system the code from the = old system to make sure it works Something has changed in revision 62, this is what i am guessing On 4/7/24 13:57, Ruben Melikyan wrote: INSERT INTO send_sms ( `momt`, `sender`, `receiver`, `msgdata`, `time`, `service`, `sms_type`, `coding`, `charset`, `dlr_mask` ) VALUES ( 'MT', 'UnicKlad', '306931234567', '%ce%b1%ce%b2%ce%b3%ce%b4%ce%b5%ce%b6%ce%b7%ce%b8%ce%b9%ce%ba%ce%bb%ce%= bc%ce%bd%ce%be%ce%bf%cf%80%cf%81%cf%83%cf%84%cf%85%cf%86%cf%87%cf%88%cf%89%= 0a%40%23!%24%25%5e%26*()+%5b%5d+%7b%7d+%27%3b+%3f+%3c%3e+%2f+%5c+%7c%3d+%2b= +-+%e2%82%ac', UNIX_TIMESTAMP(), 'sqlbox', '2', '2', 'utf-8', '19' ); --_000_PAVP195MB22338A94CD246941E33B787EDFDF2PAVP195MB2233EURP_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable <html> <head> <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DWindows-1= 252"> </head> <body> <div> <div dir=3D"ltr"> <div dir=3D"ltr">Hi Dinos,</div> <div dir=3D"ltr">I haven=92t any additional idea. Probably it=92s bug. Requ= est should work as expected.<span></span><span></span></div> <div dir=3D"ltr"><br> </div> <div dir=3D"ltr">I think using old version is the best decision in this sit= uation.</div> </div> </div> <div id=3D"ms-outlook-mobile-signature"> <div><br> </div> <div dir=3D"ltr"> <div dir=3D"ltr">Best regards,</div> <div dir=3D"ltr">Ruben Melikyan</div> </div> </div> <hr style=3D"display:inline-block;width:98%" tabindex=3D"-1"> <div id=3D"divRplyFwdMsg" dir=3D"ltr"><font face=3D"Calibri, sans-serif" st= yle=3D"font-size:11pt" color=3D"#000000"><b>From:</b> Konstantinos Liadakis= <[email protected]><br> <b>Sent:</b> Friday, July 5, 2024 12:20:49 PM<br> <b>To:</b> Ruben Melikyan <[email protected]>; [email protected] <users@= kannel.org><br> <b>Subject:</b> Re: unicode problem with sqlbox Revision: 62</font> <div> </div> </div> <div> <p>Hello, i tried your query and get exactly the same error</p> <p>2024-07-05 08:18:57 [51778] [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-05 08:18:57 [51778] [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-05 08:18:57 [51778] [1] ERROR: Could not charset process message, d= ropping it!<br> </p> <p>I dont believe there is something wrong with my query or database/table = setup as using exactly same query on old system everything works as expecte= d</p> <p>If i cannot find a solution i will compile to new system the code from t= he old system to make sure it works</p> <p>Something has changed in revision 62, this is what i am guessing</p> <p><br> </p> <div class=3D"x_moz-cite-prefix">On 4/7/24 13:57, Ruben Melikyan wrote:<br> </div> <blockquote type=3D"cite"> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB">INSERT INTO = </span>send_sms</span><span style=3D""><span lang=3D"EN-GB"></span></span><= /p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB">(</span></sp= an></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> = `momt`,</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> = `sender`,</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> = `receiver`,</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> = `msgdata`,</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> = `time`,</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> = `service`,</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> = `sms_type`,</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> = `coding`,</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> = `charset`,</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> = `dlr_mask`</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB">) </span></s= pan></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> </span= ></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB">VALUES (</sp= an></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> = 'MT',</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> = </span>'UnicKlad'</span><span style=3D""><span lang=3D"EN-GB">,</spa= n></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> = </span>'306931234567'</span><span style=3D""><span lang=3D"EN-GB">, </span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> = '%ce%b1%ce%b2%ce%b3%ce%b4%ce%b5%ce%b6%ce%b7%ce%b8%ce%b9%ce%ba%c= e%bb%ce%bc%ce%bd%ce%be%ce%bf%cf%80%cf%81%cf%83%cf%84%cf%85%cf%86%cf%87%cf%8= 8%cf%89%0a%40%23!%24%25%5e%26*()+%5b%5d+%7b%7d+%27%3b+%3f+%3c%3e+%2f+%5c+%7= c%3d+%2b+-+%e2%82%ac',</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> = UNIX_TIMESTAMP(),</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> = 'sqlbox',</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> = '2',</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> = '2',</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> = 'utf-8', </span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB"> = '19'</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB">);</span></s= pan></p> </blockquote> </div> </body> </html> --_000_PAVP195MB22338A94CD246941E33B787EDFDF2PAVP195MB2233EURP_--