Run-Time error

[WillowyLady]

Eq Item Viewer
Character Inventory Manager v14.3.2

When attempting to edit items (using New Edit), included in latest update Rev279, I am encountering a run-time error.

run-time 458

"Variable uses an Automation type not supported in Visual Basic"

[cavedude]

It's due to the new items table from 13th Floor I bet.

[GeorgeS]

I think that's correct. I've been working to find these errors in other tools, but I'll look into this for eqitems and Rev279

GeorgeS

[laxative]

Greets,

Yup I'm getting that error as well

Thanks for looking into this so quickly GeorgeS

Laxa

[GeorgeS]

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

[WillowyLady]

Ahh, I built new database as follows

peq_db
:pserver:anonymous@peq.cvs.sourceforge.net:/cvsroot/peq

peq_quests
:pserver:anonymous@eqemuquests.cvs.sourceforge.net :/cvsroot/eqemuquests

cd c:\peq_db

mysql -u root -p

\u peq

source peqdb_1129Rev279.sql

I think this just creates a new database, so may not be suitable for adding to an existing db, as it may overwrite / delete / alter existing data.

Looks like the error you are experiancing is generated when trying to load items table to an existing db.

Sadly, I am somewhat new to this and the answer as to why no data is loaded is beyond my knowledge :(

However, I am sure there are many helpful gurus here that can come up with a reason.