ZAM_ZONE_PARSER failure

[Davood]

Hello George..

Your tools are excellent, and this ZAM business looks promising.


however I have the following problem

i am using 2215 version of DB
I have setup my ini properly (npc loot and tradeskill recipes load and let me edit properly)

However..

I followed the video instructions

I get this

I load ZAM_ZONE_PARSER.EXE

i click on "custom_zone" and chance it to "moors_zone" (as per video example)
then I click on "1" that loads the names
I click on "special" and turn off row mode
then i click on "2" and it gives me two errors in succession.

"MYSQL Connection FAILED - Check DB.INI OR MyODBC Drievrs Not Installed" uhmm bs i have those working because the other tools work
I click ok and then get this:

"Rune-time error '91'": "Object Variable or With block variable not set"
So what does that mean? I dunno... what i can tell you is once I click ok on that window, it closes ZAM_ZONE_PARSER.EXE

[GeorgeS]

That's very odd. The only thing that can make that error is an error in your db.ini file. I cannot think of any other reason for it breaking like that. Let's start with that.


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

[blackdragonsdg]

I would be interested in knowing the cause of this problem as well cause I get the same error.

[Akkadius]

If you wait a little bit we will be dumping live loot into the PEQ database here shortly, as well as merchantlists through VoA

[GeorgeS]

After looking at this more I added two things. One is closing a recordset after polling the database, and logging to file logfile.txt.

If it crashes dump the log file here, and that will help resolve it.

DLlink
http://www.georgestools.chrsschb.com//GeorgeS_EqEmu_Files.rar

GeorgeS

[blackdragonsdg]

Using the new program version it still failed multiple times. Here are the log file contents.

clicked on button 2
FINDING -- 1/166
FINDING alternate name
sql - select name from npc_types where name = "a_baleful_briar"
Reading DB.INI
Reading DB.INI -OK
OPEN_ODBC_rs, conn OK

I am using peqdb_rev2214 updated to version 2271 to match the emulator revision. It is running on Vista Ultimate x64 with ActivePerl-5.12.4.1205-MSWin32-x86-294981 and mysql-essential-5.1.66-winx64. Everything else is working fine and that includes the item editor and npc_loot editor. Let me know if you need anymore information.

[GeorgeS]

Ok got that. I rewrote that section and changes are in this version

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

Just unrar and replace the exe

GeorgeS

[blackdragonsdg]

I hate to say it but nothing changed I still get the same error. Is it possible that this is another one of those odd issues that is the result of a minor change in some part of the OS going from one version to the next?

Thanks for trying to fix the problem GeorgeS.

[GeorgeS]

I just re-read your previous post and you mentioned you use Vista. I realized that my tools use a backward compat DLL for vista, but not the Alla loot tool. I thus recompiled the source and the previous link should now work for you.

Let me know
GeorgeS

[blackdragonsdg]

Problem solved. Thanks again GeorgeS.