My server shows up. yet I cannot connect

[xxarthurxx]

download navicat and install it and get it to load you db then i would look into the zone type tables for you BD... i remember encountering this problem when i removed the zoneline table (the table that tells each zone where there is a zone line) check through navi cat and open up each table and make sure all the right stuff is in there... if all the zone tables are not in there then it will say zone unavaliable when trying to load your character in.

In the event that the zone tables are not all in I would re source the DB completly or from an older working backup

[bazz701]

Ok, so I got navicat working, and went into the zone table... but one column is completely blank... the "file_name" column for all zones is blank... does that mean that the server doesnt know what to lead for each zone?


Or is that supposed to be that way as "short_name" and "long_name" are filled in...???

Thanks for the help.

[xxarthurxx]

whats inside the tables doesnt really matter as far as loading the zone... it matters if the tables themselves are right. so there has to be a Zone_flag table i wish i could see all the needed tables so i could make sure they are all there but i cant right now im at work :/ something you could try in the meantime is to re-source a new database with a diffrent database name and then cross referance them and make sure there are all the right tables... if you original is missing some of them what you can do is just copy over the missing ones from the new db.

having an active backup is always nice so you can backup any table mistakes right away

[bazz701]

SOmething I never really thought of is... do I need a copy of EQ T Edition installed on the host computer(server)... or just the other files... it never occured to me that I may have forgotten that vital step.

[trevius]

You don't need Titanium on the server PC. But, you DO need to copy the spells files to the eqemu directory as stated in the server setup guide wiki.

It looks like you are running a current version of the databases that include the newer rules, but you don't have the correct eqemu code version to use the newer rules. You might want to try using emu version 1108 which is the most recent listed on the downloads page.

Also, make sure you sourced all of the database files needed. If you are running PEQ database, you need to have both load_player.sql and the peqdb_XXXXx.sql sourced in. It is all there in the wiki here:

http://www.eqemulator.net/wiki/wikka...ka=ws992mysql5

Oh, and the zone table doesn't need anything filled in on the filename column. That is probably the old way it used to lookup zone .map files, but I think it just does them by shortname now.

[bazz701]

Trev,
I am currently running 1108 on my server machine, with the spells_**.txt files both imported form a working Titanium Edition.

I followed the guide to the letter, but must have mieed something...

would restarting the guide from scratch(i.e. restarting the server, not including perl and such) be my only other option??

Also, I am using Angelox DB, and sourced it in correctly as the guide told me.. so otherwise im unsure of what to do now.

[bazz701]

The Zone_Flags tables only show 2 things.... first column has charID with 241 only row, and zoneID with 89..... thats it, is that my issue?