Couple of Issues
 

I had a computer crash recently, im out on a deployment (Navy) and my personal computer doesnt have access to the internet. Now, my problem is two fold.

First of all... When I was setting up the server again, I installed pear as per the set up wikki, and did install dbd-mysql and the other two, and it basically tells me that it cant find the website to look for those packages (Considering im not on the internet, I can see why). My question is, is there a way I can DL those seperately and then load them in pearl offline?

2nd of all... When I load the world, I load up Minilogin first, and thats fine, then I do the start batch file which loads world.exe and the zones.. It would pop up for a split second and then disapear. So I loaded world.exe in the command prompt, and i found this error:

the file is there, and in the right place, i tried to open it in IE and It wouldnt open it, said something like it couldnt read the xml, yet when I open it in Notepad, its fine... I can see all of it... anythign I can do to fix this?

From my unserstanding the perl items are no longer necessary. For example, in Linux I have never run them and all of the quests work.

The issuse with the xml file is syntax. XML is very sensitive to nodes. If there is "<xxx>" there must be "</xxx>" .
Make sure you have a beginning and a ending for each sub item, items can have items for example server has world and database (world has shortname, longname loginserver.... ).
Another solution is to extract the file again and make the modifications needed.
If not here is a copy...

ok so I got the server up and running again, but now i have a new set of issues... Now when I create a new character and log in with him, I only get a backpack and a starting note, no weapon or food... here's the error in the logs..

The next problem I have is with the character backup i made... the table loads in alright. But when i log in, I have no characters, and the world log indicates something like

Account is trying to load Bogus Characters (Name of character)
and it repeats for all my characters.. it also says something like pp=0 when it should be 12345 or some number, and I looked in the account table, character table, character backup table... and inventory and I found no field named pp.

You installed MySQL in strict mode. Run this query to correct it and you'll be fine:

As for the toons, you probably lost your pp data which means those toons are done for, sadly.

Thank you CD, you're thoughts are always appreciated. Its a shame, I had about 2000 fixes give or take for ya to add to peq, and one little worm took care of 2 terrabytes of info on my computer... :(

Ok, so Ive come to accept the character loss... But now I would really like to get past some of the other errors I got. Here's the lastest one. (Note that the server still runs normally, and I can log in and such, this is just a picky error solving tendancy... plus I would love to get the rule sets to work) Anyways, My rules in the rule sets table dont seem to be properly loading, or recognized... Here's what I got in my world.exe for errors...

Any advice on how to fix this?

It looks like you are using an older version of EQEmu that didn't support those rules. Make sure you are using 1102 from the downloads page and try it again.

That Definately worked, thank you cave dude.... Now on to the next problem ( I know im full of em!!!) Anyways, whenever I create a guild with #guild it gives me an error saying "unable to set guild leader's guild into database. You're going to have to use #guild set" (It does infact create the guild however, when I look into the database...) Then it tells me to use #guild set so I do that, #guild set kenji 1, that is the correct code, I checked. And it gives me an error again saying "Error: Unable to set kenji to guild 1". Now, Maybe Im way off but is the guild table in the database supposed to be called "guilds" or "guild" or is that not even the issue....

Fixed my own problem, Didnt have the public notes field in the guild_members table set to null.