too long data for the field item_type (table etcitem)

Find the proper support area, Saga-Version.
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
primeiro
Posts: 23
Joined: Sun Jan 23, 2011 7:22 pm

too long data for the field item_type (table etcitem)

Post by primeiro »

» 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
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: too long data for the field item_type (table etcitem)

Post by jurchiks »

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)
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
Post Reply