Jump to content

Incorrect string value - Problem


Recommended Posts

Hi Dev.

When i improve the item, or i enter the command: /item "with Polish characters", my sysser show error:

Spoiler

SYSERR: Jun 26 12:34:56 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xB3m"' for column 'command' at row 1 (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(1, 999, '123.123.123', 1, 'Virus', 'i \"Pradawny Hełm\"', NOW())  errno: 1366)

SYSERR: Jun 26 12:34:57 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xB3m I' for column 'item_name' at row 1 (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(1, 'Pradawny Hełm I', 2100001691, 0, NOW(), 1, 'SCROLL') errno: 1366)

Can anyone help me? Thank you in advance.

ps. Sorry for my English ;/

Link to comment
Share on other sites

Design Table - Set "item_name" field to character set = "cp1250"->"cp1250_polish_ci" or "utf-8"-> "utf8_polish_ci" (but I recommend the first option) and save
cp1250.png

Same goes with "command" in table "command_log"

Edited by Metin2 Dev
Core X - External 2 Internal
  • Love 1

I completely abandoned working on the files for this game. I do not respond to private messages.

.png

Link to comment
Share on other sites

7 godzin temu, Nirray napisał:

Design Table - Set "item_name" field to character set = "cp1250"->"cp1250_polish_ci" or "utf-8"-> "utf8_polish_ci" (but I recommend the first option) and save
cp1250.png

Same goes with "command" in table "command_log"

Thaaanks a lot!

Edited by Metin2 Dev
Core X - External 2 Internal
Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.