Server issue after booting it..

[Dayhawk]

I finally got my server up and running.. But here are a few issues I am having..

1) I can't seem to set my account to GM status..

2) Characters are starting in the correct places but can't move, they also are starting with no items.

I would really appreciate any help I can get on this. Thank you.

[Dayhawk]

Anyone please help me out.. Very annoying that I can't move after logging in and that I can get this status set = (

[Caryatis]

You have 2 options, wait and bitch until somebody helps you or search. One way is faster and makes you look less douchey than the other.

[Dayhawk]

lol i love that response

[lerxst2112]

As always, look in your logs. They are likely filled with information you need to fix the problem.

Make sure you have applied any required SQL updates and perhaps the recommended SQL updates if your source code is newer than the database you are using. The change logs generally call these updates out.

[pfyon]

Also, check that your maps are in the right place.

[Dayhawk]

lerxst2112

Your suggestion worked.. I did that exactly and I am able to walk.. But after setting my account through the DB to 250 status, it will no longer allow that account to even login to the server. I can still login with other accounts... Any idea on that?

[lerxst2112]

If you change it back are you able to login? I haven't updated anything in a few weeks, but my accounts work with a status of 255.

[Dayhawk]

How did you make your account status 255? what method?

[lerxst2112]

Using SQLyog I typed 255 into the status field.

[Dayhawk]

Im using HeidiSQL and still new to it.. Trying to figure out how to pull up accounts that have logged into server and items so that I can edit certain things... Any idea?

[Akkadius]

Im using HeidiSQL and still new to it.. Trying to figure out how to pull up accounts that have logged into server and items so that I can edit certain things... Any idea?

Use Navicat on your new machine, if you are using it like you said you were.

[Dayhawk]

I am not, I am using the old machine that you connected to and I have everything working correctly besides just a few things.

[Akkadius]

I am not, I am using the old machine that you connected to and I have everything working correctly besides just a few things.

Your main thing is getting all the correct .SQL's sourced from the SVN. Your loading in underneath the world could be issues with your zone table being loaded incorrectly.

http://code.google.com/p/projecteqemu/source/browse/#svn/trunk/EQEmuServer/utils/sql/svn

[Dayhawk]

I fixed that issue just by updating manually the SVN coding.. I just cant figure out how to set this GM status because when I try to look at direct files such as item files or anything of the sort I cant seem to find them.

[Dayhawk]

Figured it out.

[Scylly]

Your main thing is getting all the correct .SQL's sourced from the SVN. Your loading in underneath the world could be issues with your zone table being loaded incorrectly.

http://code.google.com/p/projecteqemu/source/browse/#svn/trunk/EQEmuServer/utils/sql/svn

I'm completely green to svn. I've used tortoise to grab the sql files from the url above but dont know what to do with them. Just continually load them one by one "source xxx_xxxxx_xxx.sql" through the command line?

[lerxst2112]

Yes, one by one in order for any of them that are newer than your database version.