Getting a login server account

[bigsol81]

I just checked the logs. They show two major errors:

Error loading NPC from Database. Bad Query: #1054: Unknown Column 'npc_types.ATK' in 'field list'

Then some "Unknown OpCode" errors, and some bitching about not sourcing the ZONECFG.SQL file, which I have no idea where to obtain...

[trevius]

Did you update the version to match the changelog you are getting the SQL entries from? You don't want changes from later than the version you are running, they need to match. You should try running 1129 which is the latest official release and just get the required SQL in there to make it all work.

[bigsol81]

Aw, crap!

Okay, so wait....

I currently have Version 1129 running on my server. The database I downloaded says it's for "Emu Version 1061+"

I tried to source every SQL change from 1062 all the way up to 1129. I wasn't supposed to do that?

So, just gimmie in a nutshell what I do.

1. Drop my current database.
2. Source in PEQ's 'complete' database files, located here under "Release: Final".
3. Add ONLY the SQL changes noted as necessary in 1129.

Correct?

[trevius]

No, you need all of the versions from whatever version it is that your database was made for on up to the version you are currently running. So, if the database was for 1061, then you would need everything from 1062 to 1129. But, make sure you don't miss any as some are harder to find than others.

[bigsol81]

Hmm. That's what I did, and the zone server won't load, giving me the errors I described. I'll give it another shot later. Hopefully it'll work.