NPC editor fail =\
 

After completely starting over with everything for a new install on Win7 32bit. I got everything redownloaded and updated. Running the Repack on your main page. And everything installed correctly. I log in to play without a hitch. I go to DL the server admin tools so I can edit Npcs and loot tables. I ran into a small issue installing the ocx files, but research the problem and do the manual install and everything installs fine and it loads up just fine. ODBC files installed without a issue as well. I fire up the NPC editor and it connects just fine.

But when I go to select any npc on the list once a zone is loaded. I get the

Run-time error '-2147217900 (80040e14)':

[MySQL] [ODBC 3.51 Driver] [mysql-5.0.41-community-nt] Unknown column 'lootdrop_entired.minilevel' in 'field list'.



Before I wiped everything (because I couldnt get quests to work in EMU) I had the tools loaded and configured and they were working as intended. I even logged in to check that the npc loot was just as I set it with the editor and it was. So it was working before. But since I reinstalled everything and started over, I dont know why im getting this error. Any clues? =(

The repack is pre 2214 database, and the tool only works with current 2214+ schema. You must update to current schema. I can post the database as a zip if you need.

Georges

oh, yeah that would be great!
How would I go aboot swaping the updated DB using the repack configurations?

basically, you don't

So the db can't be updated, or replaced with a different folder containing a newer DB?

If you updated the database it would no longer be compatible with the executables you're using. That's why it is better to compile your own so you can keep both up to date.

You could always use an older version of the editor that is compatible with the database you're using.

I just updated the database and made a rar(Dl from my website). The binaries are +Bots enabled and are compatible with this version of DB. Also the binaries are recent as of 10/3/12 and that database is current with it.Overwrite the repack binaries with mine.
Also,if running the repack, dl the perl.rar (Dl from my website) and overwrite the original 5.10 perl with my newer one here.
C:\PEQ_Repack\udrive\perl <<<<where perl is located on my machine
database access is root/eqemu
mysql is installed to -- C:\PEQ_Repack\udrive\usr\local\mysql

First install the repack.
Install my database r.2214 (you can keep the your older one)
point eqemu_config.xml to currect db
mysql access = root/eqemu
overwrite perl folder with my perl.rar
install peq_2214_bots binaries over older binaries


also note, my login tables/database are also included in the database rar and comment /delete these tables out if you want to keep yours. If you use mine,then use leslamarch/password to play the game


Also,to install the database you can use the MySQL GUI Tools 5.0.rar and run MySQLAdministrator.exe. DL these from my site too.

That should be it

GeorgeS


GeorgeS

Thanks GeorgeS! I understand most of this. I'll brew up some coffee when I get off work and make these adjustments and hopefully get it workin! Thanks for all your hard work and awesome tools! It was very fun while it worked. Now just hope I can get this fix correctly done. Heh.

ok...im A litte confused as to how one installs the new database, I unzipped the file from your site and it only has one file in it. I looked for similar files in PEQ file on my c:drive so I could replace it, but didnt see anything similar. Or is installing the Database a more complex process with this repack?
Then I saw the bottom of your post...so I installed the 2 files and ran mysql admin program, and it keeps giving me errors. it wont connect to the localhost. Even if i were to connect I dont know how Im suppose to install the new Database with that program. Sorry to be such a beginner at all this, im trying to make sense of it all.

Ok,try this.

start mysql by starting file EQEmuGUI.exe in C:\PEQ_Repack
click on start mysql
next,

Load MySQLAdministrator.exe
server host=127.0.0.1
user=root
pass=eqemu

hit enter, ignore the settings error
click on restore
click on open backp file (peq_2214.sql)
start restore

that should be it.

That all seemed to work! V=)

So I hate to do this but after reading around and trying to follow your instructions, it seems that one would have to know more than I do when it comes to these programs and codings. =\

So might I be sold bold (falls to knees) to beg for more of a step by step on your instruction list?
I dont only want to just get a server and your tools up and running, but I want to learn more of all these methods.
So here are the steps you listed:

1-First install the repack. Done!
2-Install my database r.2214 (you can keep the your older one) Done! the method above was successful thanks!


-Incomplete-
3-point eqemu_config.xml to currect db I thought these values remained the same?
4-mysql access = root/eqemu Is this just information?
5-overwrite perl folder with my perl.rar Do you mean unzip the new version and swap out perl folders in server folder?
6-install peq_2214_bots binaries over older binaries I actually have no clue how to do this one, is it even manditory? Im not planning on running bots...doesnt matter if they are in or not to me.

I really dont like appearing like I am helpless, but I just dont want to mess anything up and I want to learn the right way to do these things.
thanks George!

3. attempt to launch the server and log in. if it works, everything should be fine.
4. attempt to connect to the database with mysqladministrator. if it works, everything is fine (likely if the previous step went ok, you shouldn't have to worry with this at all).
5. overwriting and swapping out the folder with a new perl will have the same effect, except for the fact that you'll still have the old perl on your drive if you don't overwrite it. in short... yes.
6. same as with perl, but it looks like the only compiled version he has up includes bots. if you don't want to use bots, don't use bot commands them. it won't change anything in the game.

-Incomplete-
3-point eqemu_config.xml to currect db - the new database you just installed is called peq_2214 or similar. The config file needs this or else it will use the older database b default

4-mysql access = root/eqemu - simply info for you

5-overwrite perl folder with my perl.rar - yes, unzip the new version and swap out perl folders in server folder

6-install peq_2214_bots binaries over older binaries - again ,yes, the older repack comes with older code pre 2214, and won't work with the new database.Ths the new binaries require this database, which the tools work off

GeorgeS

World.exe system error
The program cant start because perl512.dll is missing from your computer.

ok....so I redl your perlpack and unzip, replace perl folder in eqrepack folder.

Same message.

I do a search in C for perl512.dll, perl510.dll and no results. So Dl this file and install it in the perl folder I assume?

Oh sorry forgot to update, the NPC editor seems to be working fine now, but now...Starting the game to check live progress of updates using NPC editor, gives me this error. So would DL the perl512.dll and placing it in work like that?