Issue information

Issue ID
#30
Status
Fixed
Severity
Medium
Started
Hercules Elf Bot
Sep 10, 2007 3:10
Last Post
Hercules Elf Bot
Sep 10, 2007 3:10
Confirmation
N/A

Hercules Elf Bot - Sep 10, 2007 3:10

Originally posted by [b]taicomjp[/b]
http://www.eathena.ws/board/index.php?autocom=bugtracker&showbug=30

I use mysql 5.0.38

here is my setting

char_athena.conf
char_name_option: 0

inter_athena.conf
default_codepage: big5

I couldnt create name like 許許許,but I could create name like 許許.
I think this is eathena sql version bug because I could create it on txt version on that I could create char name 許許 or 許許許.

ps 許 is Escaped characters

here is error show
[SQL]: DB error - You have an error in your SQL syntax; check the manual that c
rresponds to your MySQL server version for the right syntax to use near '5', '5
, '5', '5', '5', '5', '1', '0')' at line 1
[Debug]: at ..\src\char_sql\char.c:1290 - INSERT INTO `charlog`(`time`, `char_ms
`,`account_id`,`char_num`,`name`,`str`,`agi`,`vit`,`int`,`dex`,`luk`,`hair`,`ha
r_color`)VALUES (NOW(), 'make new char', '2000000', '5', '許\許\許\', '5', '5',
'5', '5', '5', '5', '1', '0')
[SQL]: DB error - You have an error in your SQL syntax; check the manual that c
rresponds to your MySQL server version for the right syntax to use near ''許\許
許\'' at line 1
[Debug]: at ..\src\char_sql\char.c:1300 - SELECT 1 FROM `char` WHERE `name` = '許
\許\許\'

This post has been edited by taicomjp: Sep 10 2007, 10:59 AM
Attached thumbnail(s)
Attached Image
Attached Image
Attached Image
Attached Image