EQEmulator Forums - ZAM_ZONE

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Development::GeorgeS's Tools (https://www.eqemulator.org/forums/forumdisplay.php?f=674)

- - ZAM_ZONE_PARSER failure (https://www.eqemulator.org/forums/showthread.php?t=36063)

Davood

11-30-2012 03:32 PM

ZAM_ZONE_PARSER failure

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

12-01-2012 02:25 PM

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.

Code:

host=localhost

user=root

password=eqemu

database=peq_2214

everquest_folder=c:\Underfoot_Steam

blackdragonsdg

12-01-2012 04:21 PM

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

Akkadius

12-01-2012 04:39 PM

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

12-02-2012 03:18 PM

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...qEmu_Files.rar

GeorgeS

blackdragonsdg

12-02-2012 04:15 PM

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

Code:

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

12-02-2012 07:31 PM

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

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

Just unrar and replace the exe

GeorgeS

blackdragonsdg

12-02-2012 09:50 PM

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

12-02-2012 10:35 PM

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

12-03-2012 01:33 AM

Problem solved. Thanks again GeorgeS.

All times are GMT -4. The time now is 12:04 AM.