Item-Character inventory editor error

[blackdragonsdg]

GeorgeS, I sent you an email with my items table attached.

[GeorgeS]

Also, I have created a beta version with the music deleted. unrar and replace and see if this works

http://georgestools.eqemulator.net/eqitems.rar


George

Thanks for the table. I'm on it now

[blackdragonsdg]

GeorgeS, thanks for trying to fix the connection problem.....the beta version with no music still gives the same connection error.

[Expletus]

Same connection error no matter what I do.

[GeorgeS]

Ok that's real bad. So far nothing I tried works. Schema that blackdragonsdg gave me is identical to mine, so it therefore has to be something with the version of mysql or the odbc connection/drivers.

Also, just realized this - the only version of the ODBC drivers that I know work 100% are the ones from my site. Make sure you're using that one.

Next, just to be sure, this beta version has a new splash screen with a connection status. I am guessing it states connection is a sucess?
-- Does the main program load ok but when you hit search, does it crash right there or just after the grid populates first with items?

So the last resort is to make a test version for you guys that logs every code branch to a log file. I will work on that tonight.

GeorgeS

[blackdragonsdg]

Both the normal version and beta version of the items editor give the connection error right after the program is launched and stops right there. There is no splash screen or anything else displayed.

The npc loot editor will give the connection error then once i click ok it will load the splash screen. Splash screen displays the graphics fine and in the top right hand corner says Music DLL Failed. Error Not Fatal! and afterwards I can load into the program and hit search and it says the failed connection stuff again and then Run-time error '91': Object variable or With Block variable not set.

[GeorgeS]

Another very similar program with a similar startup is the merchant editor. Does it run ok?
I think if it does, then I have a solution to fix the program tonight.

George

[blackdragonsdg]

Are you talking about the merchant editor inside the npc_loot_editor or is there another one I am not aware of?
The merchant editor that is launched from within the npc_loot_editor gives the same connection error as the other tools and crashes with the same run-time error 91 that is mentioned above.

[GeorgeS]

Sorry, the old version of the tool - try this
http://georgestools.eqemulator.net/Merchant_Editor.zip

If this does not work, then this pretty much makes all tools that access the DB not working.
Can you zip up your db.ini or paste it here - just modify the password, but otherwise I would like to check it.

GeorgeS

[Akkadius]

They all don't work now on latest releases.

Had to use old version for someone else who uses them (Ashes) .

[GeorgeS]

I uploaded a full beta with error logging

http://georgestools.eqemulator.net/eqitems.rar

Updated the db.ini -- please use this and only this in the file, and modify the credentials to yours.

host=localhost
user=root
password=eqemu
database=peq_2022
everquest_folder=c:\Underfoot_Steam

What I need if for each of you to paste the contents of the logfile.txt in root folder of this tool. Also, what version does work?

Thanks -GeorgeS

[blackdragonsdg]

Originally Posted by GeorgeS

I uploaded a full beta with error logging

http://georgestools.eqemulator.net/eqitems.rar

Updated the db.ini -- please use this and only this in the file, and modify the credentials to yours.

host=localhost
user=root
password=eqemu
database=peq_2022
everquest_folder=c:\Underfoot_Steam

What I need if for each of you to paste the contents of the logfile.txt in root folder of this tool. Also, what version does work?

Thanks -GeorgeS

This won't even launch. I get Run-time error '53': File not found. It doesn't even specify which file it can't find.

[blackdragonsdg]

Originally Posted by GeorgeS

Sorry, the old version of the tool - try this
http://georgestools.eqemulator.net/Merchant_Editor.zip

If this does not work, then this pretty much makes all tools that access the DB not working.
Can you zip up your db.ini or paste it here - just modify the password, but otherwise I would like to check it.

GeorgeS

This worked perfectly.

[GeorgeS]

Oh, I think it needs an empty text file called logfile.txt in root folder where the exe runs from.

GeorgeS

[Psiodon]

creating log entry
Identified user:root
Identified database:peq
Identified host:localhost
Identified everquest_folder:c:\EverQuest\
Completed getting user info
credential output to screen ok
Call to ODBC open connection started
Call to ODBC open connection failed