Problem with loading server

[maya6man24]

thanks will try that again. Just found this people have had the same problem.
http://www.eqemulator.org/forums/showthread.php?t=29784

Before you sourced the load_player.sql did you open the file and set the correct file paths?

By default it will look something like this:

source player_tables/aa_timers.sql;
source player_tables/account.sql;
source player_tables/account_ip.sql;
source player_tables/account_rewards.sql;


But in order for it to work it should look similar to this:

source C:/Temp/player_tables/aa_timers.sql;
source C:/Temp/player_tables/account.sql;
source C:/Temp/player_tables/account_ip.sql;
source C:/Temp/player_tables/account_rewards.sql;

and i did this but still will not work for me.

[maya6man24]

I changed load_player back to source/player_tables and did the shift right click thing and it worked, thanks, but gave an error on loading the bots but thats ok, more worried about getting the server up and running first. Now to try to run it and see what happens.

[chrismed0]

Nope with the most resent rev of the peqdb I didn't have to change anything. I don't know about the bots sql, didn't use it.

But the players sql and the actual rev I never had a prob on at all. I have tweeked my db so many time in the last week getting the way I want it or tring different things that I have had to source / back it up several times. never with any problems.

very important to be in the same directory as your sql files when you open your command prompt and start mysql.

[maya6man24]

getting zone: dynamic_01 reported state start then stopped over and over again. wont go past that first zone, I used 2214 db.

[chrismed0]

Don't know what to tell you then. I did tweek my stuff once and had to redo parts of it. I forgot to do something but I can't remember and I kept getting the stop / start state over and over....
It had to do witht he DB to.. sorry, just can't remember what it was but I did figure it out.. and it was a DOH moment. Palm to forehead. I just wish I knoew what to tell ya.

[maya6man24]

Thank you for your help you have been very helpful, going to fiddle with it some more maybe start over and try that. Thank you.

[maya6man24]

C:\EQEmu>zone.exe
[Debug] Starting Log: logs/eqemu_debug_zone_101788.log
[Debug] [ZONE__INIT] Loading server configuration..
[Debug] [ZONE__INIT] Log settings loaded from log.ini
[Debug] [ZONE__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_zone_101788.log
[Status] Using database 'peq' at localhost:3306
[Debug] [ZONE__INIT] CURRENT_ZONE_VERSION: EQEmulator 0.8.0
[Debug] [ZONE__INIT] Log settings loaded from ./log.ini
[Debug] [ZONE__INIT] Mapping Incoming Opcodes
[Debug] [ZONE__INIT] Loading Variables
[Debug] [ZONE__INIT] Loading zone names
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #1146: Table '
peq.zone' doesn't exist
[Debug] [ZONE__INIT] Loading items
[Status] EMuShareMem loaded
Error in GetItemsCount query 'SELECT MAX(id),count(*) FROM items' #1146: Table '
peq.items' doesn't exist
Error: SharedDatabase::LoadItems() (sharemem): GetItemsCount() returned -1
[Debug] [ZONE__INIT_ERR] Loading items FAILED!
Got this after opening command prompt in my server folder and typing zone.exe. Anybody have any ideas I have no idea what it means.



[Debug] [ZONE__INIT] Failed. But ignoring error and going on...
Error in LoadItemStatus query: 'Select id, minstatus from items where minstatus
> 0'
[Debug] [ZONE__INIT] Loading npc faction lists
Error in GetNPCFactionListsCount query 'SELECT MAX(id), count(*) FROM npc_factio
n' #1146: Table 'peq.npc_faction' doesn't exist
Error: SharedDatabase::LoadNPCFactionLists-ShareMem: GetNPCFactionListsCount() r
eturned < 0
[Debug] [ZONE__INIT_ERR] Loading npcs faction lists FAILED!

C:\EQEmu>