[SQL]: DB error - Data too long for column

[Eyhra]

Hello, I have problems with my script when I add it, it gives me the following error

 

[SQL]: DB error - Data too long for column 'name_card' at row 1
[Debug]: at C:\rathena\src\map\script.cpp:17729 - INSERT INTO `item_log_mvps_cards` (id_card,name_card,localizacion,account_id) VALUES (4241,'Arc Angeling Card','[Storage]Academy Completion Hat[5407]',2000000)
[Warning]: Script command 'query_sql' returned failure.
[Debug]: Source (NPC): MVPCARDLOG2 (invisible/not on a map)
[Debug]: Source (NPC): MVPCARDLOG2 is located in: npc/eyhra/MvpLog.txt

 

Edited May 23, 2023 by Eyhra

[pajodex]

10 hours ago, Eyhra said:

Hello, I have problems with my script when I add it, it gives me the following error

 

[SQL]: DB error - Data too long for column 'name_card' at row 1
[Debug]: at C:\rathena\src\map\script.cpp:17729 - INSERT INTO `item_log_mvps_cards` (id_card,name_card,localizacion,account_id) VALUES (4241,'Arc Angeling Card','[Storage]Academy Completion Hat[5407]',2000000)
[Warning]: Script command 'query_sql' returned failure.
[Debug]: Source (NPC): MVPCARDLOG2 (invisible/not on a map)
[Debug]: Source (NPC): MVPCARDLOG2 is located in: npc/eyhra/MvpLog.txt

MvpLog.txt 4.71 kB · 2 downloads

change the sql data value of `name_card` to something longer like VARCHAR(30) so it can store 30 characters... may be you accidentally set it to 11 or less

[Eyhra]

thx @pajodex fix