Re: unicode problem with sqlbox Revision: 62
Konstantinos Liadakis <[email protected]> Fri, 5 Jul 2024 11:20:49 +0300
| Newsgroups | gmane.comp.mobile.kannel.user |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format.
--------------UUit1xfTUnb43MOPYZ4MsJ7f
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: quoted-printable
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=20
SQL syntax; check the manual that corresponds to your MariaDB server=20
version for 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=20
SQL syntax; check the manual that corresponds to your MariaDB server=20
version for the right syntax to use near ')' at line 1
2024-07-05 08:18:57 [51778] [1] ERROR: Could not charset process=20
message, dropping it!
I dont believe there is something wrong with my query or database/table=20
setup as using exactly same query on old system everything works as expec=
ted
If i cannot find a solution i will compile to new system the code from=20
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
>
> (
>
> =C2=A0=C2=A0 `momt`,
>
> =C2=A0=C2=A0=C2=A0 `sender`,
>
> =C2=A0=C2=A0=C2=A0 `receiver`,
>
> =C2=A0=C2=A0=C2=A0 `msgdata`,
>
> =C2=A0=C2=A0=C2=A0 `time`,
>
> =C2=A0=C2=A0=C2=A0 `service`,
>
> =C2=A0=C2=A0=C2=A0 `sms_type`,
>
> =C2=A0=C2=A0=C2=A0 `coding`,
>
> =C2=A0=C2=A0=C2=A0 `charset`,
>
> =C2=A0=C2=A0=C2=A0 `dlr_mask`
>
> )
>
> VALUES (
>
> =C2=A0=C2=A0=C2=A0 'MT',
>
> 'UnicKlad',
>
> '306931234567',
>
> =C2=A0=C2=A0=C2=A0=C2=A0'%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%8=
5%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',
>
> =C2=A0=C2=A0=C2=A0 UNIX_TIMESTAMP(),
>
> =C2=A0=C2=A0=C2=A0 'sqlbox',
>
> =C2=A0=C2=A0=C2=A0 '2',
>
> =C2=A0=C2=A0=C2=A0 '2',
>
> =C2=A0=C2=A0=C2=A0 'utf-8',
>
> =C2=A0=C2=A0=C2=A0=C2=A0'19'
>
> );
>
--------------UUit1xfTUnb43MOPYZ4MsJ7f
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, 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 version 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 for the right syntax to use near ')' at line 1<br>
2024-07-05 08:18:57 [51778] [1] ERROR: Could not charset process
message, dropping 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 expected</p>
<p>If i cannot find a solution i will compile to new system the code
from the 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"moz-cite-prefix">On 4/7/24 13:57, Ruben Melikyan wrote:=
<br>
</div>
<blockquote type=3D"cite"
cite=3D"mid:[email protected].=
PROD.OUTLOOK.COM">
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">INSERT INTO
</span>send_sms</span><span style=3D"mso-bookmark:_Hlk120024655=
"><span
lang=3D"EN-GB"><o:p></o:p></span></span></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">(<o:p></o:p></span></span></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">=C2=A0=C2=A0 `momt`,<o:p></o:p></span></span><=
/p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">=C2=A0=C2=A0=C2=A0 `sender`,<o:p></o:p></span>=
</span></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">=C2=A0=C2=A0=C2=A0 `receiver`,<o:p></o:p></spa=
n></span></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">=C2=A0=C2=A0=C2=A0 `msgdata`,<o:p></o:p></span=
></span></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">=C2=A0=C2=A0=C2=A0 `time`,<o:p></o:p></span></=
span></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">=C2=A0=C2=A0=C2=A0 `service`,<o:p></o:p></span=
></span></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">=C2=A0=C2=A0=C2=A0 `sms_type`,<o:p></o:p></spa=
n></span></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">=C2=A0=C2=A0=C2=A0 `coding`,<o:p></o:p></span>=
</span></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">=C2=A0=C2=A0=C2=A0 `charset`,<o:p></o:p></span=
></span></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">=C2=A0=C2=A0=C2=A0 `dlr_mask`<o:p></o:p></span=
></span></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">)
<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">VALUES (<o:p></o:p></span></span></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">=C2=A0=C2=A0=C2=A0 'MT',<o:p></o:p></span></sp=
an></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">=C2=A0=C2=A0=C2=A0
</span>'UnicKlad'</span><span
style=3D"mso-bookmark:_Hlk120024655"><span lang=3D"EN-GB">,<o:p=
></o:p></span></span></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">=C2=A0=C2=A0=C2=A0
</span>'306931234567'</span><span
style=3D"mso-bookmark:_Hlk120024655"><span lang=3D"EN-GB">,
<o:p></o:p></span></span></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">=C2=A0=C2=A0=C2=A0=C2=A0'%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',<o:p><=
/o:p></span></span></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">=C2=A0=C2=A0=C2=A0 UNIX_TIMESTAMP(),<o:p></o:p=
></span></span></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">=C2=A0=C2=A0=C2=A0 'sqlbox',<o:p></o:p></span>=
</span></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">=C2=A0=C2=A0=C2=A0 '2',<o:p></o:p></span></spa=
n></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">=C2=A0=C2=A0=C2=A0 '2',<o:p></o:p></span></spa=
n></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">=C2=A0=C2=A0=C2=A0 'utf-8',
<o:p></o:p></span></span></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">=C2=A0=C2=A0=C2=A0=C2=A0'19'<o:p></o:p></span>=
</span></p>
<p class=3D"MsoNormal"><span style=3D"mso-bookmark:_Hlk120024655"><=
span
lang=3D"EN-GB">);</span></span></p>
</blockquote>
</body>
</html>
--------------UUit1xfTUnb43MOPYZ4MsJ7f--