EQEmulator Forums - Getting the newest CVS 6.1 to work with your database!

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

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Getting the newest CVS 6.1 to work with your database! (https://www.eqemulator.org/forums/showthread.php?t=18503)

Getting the newest CVS 6.1 to work with your database!

(This is a guide for people upgrading from 6.0DR2 to 6.1DR1)

First of all, you will need to have a compiled 6.1DR1 from the CVS. (Sunday, May 08, 2005)

Projecteq.net is down currently, but you will need their Velious database release.

EDIT:: There are some incompatibilities column wise with the kunark database. Until I figure out exactly what they are and how to resolve them, you will have to go with the velious database. Sorry.

1. In the mysql command line, type source load_system.sql and wait for that to finish.

2. Now source load_empty_users.sql and wait for that.

Okay, now most of the hard stuff is done. Here is where it gets a little strange because this is what I did and it may not exactly be right.

Now, get these files:
http://cvs.sourceforge.net/viewcvs.p...rt.sql?rev=1.2
http://cvs.sourceforge.net/viewcvs.p...ems.pl?rev=1.2
http://cvs.sourceforge.net/viewcvs.p...ql?rev=1.1.2.1
http://cvs.sourceforge.net/viewcvs.p...FG.SQL?rev=1.2
http://eqitems.13th-floor.org/download/items.zip

type these exactly:
source items-0.6.0-DR2-0.6.1-DR1-convert.sql;
source 0.6.1-upgrade.sql
source ZONECFG.SQL
delete from items;

This is where it gets a little weird. I did this for Windows XP and the way I did it is a little hazy.

Go to Start -> Run --- ppm

install dbi
install dbd-mysql

Now, from command prompt in the same directory as the loading script from earlier (should also have the item.txt file unzipped in the directory)

perl load_13thfloor_items.pl -d db -u user -p password <items.txt

And that should do it.

If there are any problems, drop a message.

Yep!.. a problem

The install itself went perfectly..but, on loading world.exe it reports too many items.. says to increase the max in items.. C++ is an alien language to me :(( so if anyone could help here it would be nice :)

SR

Are you sure, you don't forget the delete from items; before use perl script ?

am i getting this ok

from what i can tell you are changeing the items from mysql to perl

what directory does the load_13thfloor_items.pl have to be in for it to work???

I put it here...

Quote:

Originally Posted by rmcgraw1

from what i can tell you are changeing the items from mysql to perl

what directory does the load_13thfloor_items.pl have to be in for it to work???

I put it into the Perl directory, it worked from there..:)

SR

nope.. didn't forget )

Quote:

Originally Posted by Belfedia

Are you sure, you don't forget the delete from items; before use perl script ?

No, Bel.. I did the delete from items; thing.
and once I ran the items.txt it unpacked fine, it's just on running world.exe I get the "too many items" crash

SR

Strange i follow the guide and i have no problem :(
Perhaps same thing than DR3, bug are random ?
Hopping a Stable release for few time :) (go go go Devs :p)

ok i got everything write except for the last line....

i am presuming on

perl load_13thfloor_items.pl -d db -u user -p password <items.txt

where it says db and user and password i put mine in there, Right? so i do and i get a mysql syntax error"check your manuel blah blah"
I am puting this in the mysql cmd.

if i put in
perl load_13thfloor_items.pl -d db -u user -p password <items.txt
as is i get alittle arrow thingie so i add a ;
then i get error. If i am doing something wrong please tell me

Quote:

Originally Posted by mikeGreen

open a cmd.. cd to your perl dir.. then run command

thanks i got it missed a step started over with a backup works fine now

yep going right now thanks somehow i forgot to save that file and was thinking item.txt was that file.......

ok well it worked except now world crashes everytime it starts loading items....

anyone else have this problem or now how to fix it?

ok just got my problem......Item editor messed it up

Don't forget than many program may be, not working with the last DB release and last EQEMU release. If you aren't skilled in EQEMU, wait for the Stable release who come in few time i hope :)
If you follow (and understanding) step by step instruction of this thread for make your DB that work !
If don't work, search your error :)

K I did everything that was asked and I click on my minilogin and then my world.exe and it comes up and disappears I know that way back when peeps had this problem too. I cannot seem to find the original files about this problem so if you can refresh my memmory a bit on y the world comes up and then goes away really fast (Flashes on then off)
Thanks alot :)

Try this--- Start -> Run and type 'CMD'

Then, let's say your Emulator directory was at C:\Eqemu

Type:

CD c:\eqemu

and then type 'world.exe' and it should tell you what error it's encountering that's causing it to close down.

Yes i am just a dip#$%^ at times lol it was the opcode.cfg I didnt have one in my folder and I already got the full cvs downloaded on my cpu but I dont know how to compile but at least I could grab that opcode and pull it over and drop it in my folder....

K just thought I would throw this one in and make sure before I go sourcing cvs tributes in if this is something that you had an error on also and that this was one of those problems you had with compiling. If not then can I just re-source in the tributes table???
[status loading tributes] I got 4 errors saying:
loading error tributes unknown tribute 0 in tribute_levels.....
any ideas what I should tamper with lol :)

ok didnt fix that log file error I keep gettin either thought I did but all I did was fixed the opcode errors i was getting. anymore help is very appreciated thanks :)

I'd try sourcing in anything that says tributes in it. Also, you might source in AA's. I know my database was missing them.

here is my error page shown....

Code:

[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.1-DR1

[Status] Loading opcodes..

[Status] Mapping Opcodes

[Status] Loading Variables

[Status] Loading zone names

[Status] Loading items

[Status] EMuShareMem loaded

22187184

16695306

[Status] Loading npcs

[Status] Loading npc faction lists

[Status] EMuShareMem loaded

[Status] Loading loot tables

[Status] Loading doors

[Status] EMuShareMem loaded

[Status] Loading Doors from database...

[Status] EMuShareMem loaded

[Status] FileLoadSPDat() Loading spells from ./spells_us.txt

[Status] FileLoadSPDat() spells loaded: 6677

[Status] Loading guilds

[Status] Loading factions

[Status] Loading titles

[Status] Loading AA effects

[Status] Loading swarm spells

[Status] Loading tributes

[Error] Error in LoadTributes first query 'SELECT id,name,descr,unknown,isguild

FROM tributes': #1054: Unknown column 'isguild' in 'field list'[Status] Loading corpse timers

[Status] Loading what ever is left

[Status] Loading commands

[Status] 182 commands loaded

[Status] Loading embedded perl XS

[Quest] Loading perlemb plugins.

[Quest] Loading perl commands...

[Quest] Loading perlemb plugins.

[Quest] Loading perl commands...

[Status] Starting EQ Network server.

Starting factory Reader

Starting factory Writer

[Status] Entering sleep mode

Connected to worldserver: 169.254.xx.xxx:9000

here is that log file on the world.exe file....

Code:

Failed to open log file: logs/eqemu_world_3016.log

[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.1-DR1

[Status] Loading opcodes..

[Status] EMuShareMem loaded

[Status] Loading variables..

[Status] Loading zones..

[Status] Clearing groups..

[Status] Loading items..

[Status] EMuShareMem loaded

22187184

16695306

[Status] Loading items from database: count=43228

[Status] ./LoginServer.ini read.

[Status] Loading guild ranks..

[Status] Loading ./addon.ini..

[Status] Loading EQ time of day..

[Status] Deleted 0 stale player corpses from database

[Status] Deleted 0 stale player backups from database

Warning: You need to get laid...

TCP listening on: 169.254.xx.xxx:9000

Starting factory Reader

Starting factory Writer

World server listening on: 169.254.xx.xxx:9000

Setting World to MiniLogin Server type

Connected to LoginServer: 169.254.xx.xxx:5999

55000 New TCP connection: 169.254.xx.xxx:3459120809

New zoneserver: #1 169.254.xx.xxx:4336

Zoneserver SetConnectInfo: 169.254.xx.xxx:4336: 169.254.xx.xxx:8782

55671 New TCP connection: 169.254.xx.xxx:3459120809

55671 New TCP connection: 169.254.xx.xxx:3459120809

55671 New TCP connection: 169.254.xx.xxx:3459120809

New zoneserver: #2 169.254.xx.xxx:4339

New zoneserver: #3 169.254.xx.xxx:4338

New zoneserver: #4 169.254.xx.xxx:4337

Zoneserver SetConnectInfo: 169.254.xx.xxx:4338: 169.254.xx.xxx:8784

Zoneserver SetConnectInfo: 169.254.xx.xxx:4337: 169.254.xx.xxx:8780

Zoneserver SetConnectInfo: 169.254.xx.xxx:4339: 169.254.xx.xxx:8781

55968 New TCP connection: 169.254.xx.xxx:3459120809

New zoneserver: #5 169.254.xx.xxx:4340

Zoneserver SetConnectInfo: 169.254.xx.xxx:4340: 169.254.xx.xxx:8783

so any clues on the error of tributes and tribute_levels I dropped the tables then added the new ones in from cvs because I kept getting errors of unkown table but what do I know lol I am no programmer yet :)

Weird. I have no idea.

Darktanion !
eqemu 0.6.1 DR1 DON'T WORK with minilogin :)

Well dont I feel stupid lol. Can I ask Y NOT lol I want the same benefits you all have :) and I want to stay current with you all too :) Can someone tell me what I can start doing in order to make it run with the minilogin p-p-p-p-please hahaha :)

Sorry if you make another thing than minilogin, i just see a question about that here :p
The time is not happy, Patch break another time EQEMU :( :( :(

I just removed mysql/emu/perl from my whole system, Not happy about having to do that but since I just did that ppm thing and followed the setup I realized I have no idea where all that stuff went so just starting over, however I was going to have to start over at some point down the road, was just hoping before I needed to restart over I would have had more experience with all of the programming stuff. I guess this was one of those oooops DO OVER :) hahahaha

Noooo !!! Darktanion
You must try, try, try, and win skill !!!
I'm not C++, mysql and perl programmer, and i learn !!
Make your EQserver is the best way !!! you are RIGHT.

Item.txt goes in same directory as load_13thfloor_items.pl correct? c:\perl?

World.exe can't open database config file (db.ini)

I tried using search but every time i open world.exe it crashes. so then i open using cmd prompt and it says "Couldn't open database config file './db.ini'.". My db.ini is setup right and in the correct folder too... Anyone know anything about this? thanks

When I source the first file into my database it will source fine for the first 15 minutes or so then it will spam line after line of this:

ERROR 1146 (42S02): Table 'eq1.lootdrop_entries' doesn't exist
ERROR 1146 (42S02): Table 'eq1.lootdrop_entries' doesn't exist
ERROR 1146 (42S02): Table 'eq1.lootdrop_entries' doesn't exist
ERROR 1146 (42S02): Table 'eq1.lootdrop_entries' doesn't exist
ERROR 1146 (42S02): Table 'eq1.lootdrop_entries' doesn't exist
ERROR 1146 (42S02): Table 'eq1.lootdrop_entries' doesn't exist
ERROR 1146 (42S02): Table 'eq1.lootdrop_entries' doesn't exist
ERROR 1146 (42S02): Table 'eq1.lootdrop_entries' doesn't exist
ERROR 1146 (42S02): Table 'eq1.lootdrop_entries' doesn't exist
ERROR 1146 (42S02): Table 'eq1.lootdrop_entries' doesn't exist
ERROR 1146 (42S02): Table 'eq1.lootdrop_entries' doesn't exist
ERROR 1146 (42S02): Table 'eq1.lootdrop_entries' doesn't exist
ERROR 1146 (42S02): Table 'eq1.lootdrop_entries' doesn't exist
ERROR 1146 (42S02): Table 'eq1.lootdrop_entries' doesn't exist
ERROR 1146 (42S02): Table 'eq1.lootdrop_entries' doesn't exist
ERROR 1146 (42S02): Table 'eq1.lootdrop_entries' doesn't exist
ERROR 1146 (42S02): Table 'eq1.lootdrop_entries' doesn't exist
ERROR 1146 (42S02): Table 'eq1.lootdrop_entries' doesn't exist
ERROR 1146 (42S02): Table 'eq1.lootdrop_entries' doesn't exist

I assume that is not normal

Means you are missing a pretty good chunk of your database.

Did you source drop_system.sql and then load_system.sql?

Nope I followed the steps at the top of this post.

*************************
1. In the mysql command line, type source load_system.sql and wait for that to finish.

2. Now source load_empty_users.sql and wait for that.
*************************
From the first post in this.

I will try it with drop_system.sql first then load_system.sql and see what happens.