Bug #22386 You have an error in your SQL syntax near 'ｓ set closed= 1　WHERE login='navi' an
Submitted: 15 Sep 2006 10:43 Modified: 15 Sep 2006 11:51
Reporter: yutaka kawate Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:MySQL: 3.23.58 OS:Linux (fedora)
Assigned to: CPU Architecture:Any

[15 Sep 2006 10:43] yutaka kawate 
Description:
phpMyadmin report

---RAW 開始----

ERROR: C1 C2 LEN: 14 15 108
STR: ｓ

CVS: $Id: sqlparser.lib.php,v 2.42.2.1 2005/11/28 18:23:42 nijel Exp $
MySQL: 4.0.13-nt
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 2.7.0-pl2
PHP VER,OS: 4.4.1 WINNT
LANG: ja-euc
SQL: UPDATE versionｓ set closed= 1　WHERE login='navi' and process_name='CPS' and timestamp ='2006-09-07 14:50:02'

----RAW 終了----
eNolkMFugkAYhO/7FP/BhAusuytUuwkHQjdqgkBZlKSXhuqmxeCyZalpH8f4iL5Asb3OTObLjCiK
rOAQU4gZJCLlQH2gAVCyQLIcnesNoXgnOUzWBw72szV1b1WP2+YNmw/jnoFhn2GGKTBCgimlU7YA
uuBsxn0GujmqFsS3gQna/MjnhIOPCaYzTw9oKwvIpAvRUqSlCzsx8qpGwyZ7WSdJBAEmKN9EfETM
MfFMy1C+yu85N5P3In+kVus0LVESpUsOx9pTX3v0h9nmT1Ep4Kx623T6egOrBti3nVWHEOjlUq1E
IaDt3hsdOro+Nw7U+gCm7/bK2lddn1ToxLn8l4fmpOxQnwyEzrjzwSOPHpmPZ/GAcMKcX32UW44=

How to repeat:
always

Suggested fix:
non
[15 Sep 2006 11:30] Valeriy Kravchuk 
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Note, there should be white space between 1 and WHERE keyword in "1　WHERE", like that: "1 WHERE".
[15 Sep 2006 11:51] yutaka kawate 
I tried as much as you said, but still being.

----切り取り開始----
eNodjktuwjAABfc+xVuwDMZ27H4ssYhSC5CcD04AqTtKLDVVGtKkIHocxBG5QNOu32jmGecypxFz
xALWpBpcgitIQYpyHG53QuJtoTFZVRrDV9Pt+8H3tKnfaPfeBWcIKh4hGJMzzmdMgTEtuVYKjf98
hrl0mJDkp1hbjZCKkKonsikcsiJAtDBpGWBrxtCubpFkrytrIyjKSJ5EenQ/UD7tmpDky/yPC7Lx
iqQh5Qy2bk8XYqN0ofGxn/rTgfxXNvlLVBqcfT/Ux/Z2x+C/cWiOg6/m4NfrbmmcQV1hDvELLutF
eg==
----切り取り終了----
----RAW 開始----

ERROR: C1 C2 LEN: 14 15 42
STR: ｓ

CVS: $Id: sqlparser.lib.php,v 2.27 2004/11/05 00:41:55 lem9 Exp $
MySQL: 3.23.58
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 2.6.1-pl3
PHP VER,OS: 4.3.10 Linux
LANG: ja-euc
SQL: UPDATE versionｓ set closed= 1　WHERE id = 2

----RAW 終了----

executed SQL :

UPDATE versionｓ set closed= 1　WHERE id = 2