L2J Server

» Find Revision

L2J Revision 1434:
L2JDP Revision the last revision:
Client: Interlude
Server: Interlude

C:\l2jserver\l2j-datapack\sql\etcitem.sql
mysql 5.6.14 return the follow error: too long data for the field item_type (table etcitem)
('5708','Lord of the Manor\'s Certificate of Approval','false','ticket_of_lord','0','normal','liquid','none','-1','0','0','true','true','true','true','the_lord_of_manor\'s_agreement','ch3type2'),

need fix too.. or increase the size of the field
('5708','Lord of the Manor\'s Certificate of Approval','false','ticket_of_lo','0','normal','liquid','none','-1','0','0','true','true','true','true','the_lord_of_manor\'s_agreement','ch3type2'),

bb

change "`item_type` varchar(12) default NULL,"
to "`item_type` VARCHAR(20) DEFAULT NULL," (14 should be enough, but just to be on the safe side)