Thread: Run-Time error
View Single Post
  #5  
Old 01-22-2009, 11:39 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

I Dl v.279 and it won't load the items table in - says an error like

(tried with mysql.exe and mysql-front)

data truncated for column 'augslot1unk' at row 1
`augslot1type` tinyint(3) unsigned NOT NULL default '0',
sql that breaks this is -
INSERT INTO items VALUES (1001,0,'Cloth Cap',0,2,0,0,0,0,'0',0,0,0,0,7,'' ....
should read
INSERT INTO items VALUES (1001,0,'Cloth Cap',0,2,0,0,0,0,'0',0,0,0,0,7,'0' ....

then it works. A "Null" is not allowed in this field.


no data is therefore loaded. How did you load this file in?

GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//

Last edited by GeorgeS; 01-23-2009 at 07:46 AM..
Reply With Quote