Getting the newest CVS 6.1 to work with your database!

[mikeGreen]

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

[Belfedia]

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

[Darktanion]

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

[Sarepean]

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.

[Darktanion]

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

[Sarepean]

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.

[Darktanion]

here is my error page shown....

[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....

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

[Shadow-Wolf]

nevermind on that

[Tevarian]

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

[rojadruid]

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

[Sarepean]

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

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

[rojadruid]

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.