Page 1 of 1

GameServer Starting problem

Posted: Fri Jul 27, 2012 12:01 pm
by KingSton
Server Files:
Lastest source from L2jServer, revision 9023.

Error when GameServer starting:
Unknown column 'obj_id' in 'field list'
I tried to reinstall my database, changed sql files, deleted everything and instaled another time, but nothing changed.

How to fix it? :?:

Re: GameServer Starting problem

Posted: Fri Jul 27, 2012 12:25 pm
by Asmodaius
How exactly, did you update your sql files?

Did your sql patch files from your older db, had the command DROP TABLE IF EXISTS <Table name>?

Because if they did, is most likely to have updated your sql files unproper..

Re: GameServer Starting problem

Posted: Fri Jul 27, 2012 12:32 pm
by KingSton
1) Firstly I downloaded server files from here: http://www.l2jserver.com/nightly/ ( interlude version )
2) Then I found source in the internet ( L2jserver revision 9023 ) and just added files to the folder. Then tried to instal database, this error.
3) Next, I cleaned all my database, sql files from server files and added sql files only from source. Then tried to instal, the same error.

I first time with this pack and I want to set up server for a first time.

Re: GameServer Starting problem

Posted: Fri Jul 27, 2012 1:06 pm
by Asmodaius
KingSton wrote: ....
2) Then I found source in the internet ( L2jserver revision 9023 ) and just added files to the folder. Then tried to instal database, this error.
...
Correct me if I am wrong : you have downloaded the login server from l2j and the game server from another source??

Re: GameServer Starting problem

Posted: Fri Jul 27, 2012 1:18 pm
by Asmodaius
Sorry, now I understood..

You have merged Interlude and High Five files..

Sorry but you mustn't expect this to work..

Re: GameServer Starting problem

Posted: Fri Jul 27, 2012 1:34 pm
by KingSton
Not from another source from :
http://trac.l2jdp.com/browser?order=nam ... J_DataPack
Maybe it is different datapack and then I made a mistace :D

Re: GameServer Starting problem

Posted: Fri Jul 27, 2012 1:50 pm
by KingSton
But wait, can you explain something?
I have downloaded older version from there: http://www.l2jserver.com/nightly/index. ... terlude%2F

Then source from there:
http://trac.l2jdp.com/browser?order=nam ... T_Datapack
branches - for interlude server.
trunk - for every server or only for HF version? If it is only for HF, there is my mistace, if it is not, problem is in somewhere else.


And Copy/Paste source files from source to older version will make any problems or not, if database is not instaled.

Re: GameServer Starting problem

Posted: Fri Jul 27, 2012 1:56 pm
by jurchiks
Obviously trunk is only for latest version.
Why did you download nightlies and copy over from source anyway? Just use the source. There's a Core/Server for it too, so just use both from svn and don't mix anything.

Re: GameServer Starting problem

Posted: Fri Jul 27, 2012 2:00 pm
by KingSton
So just Use Eclipse, that you are talking about? But I have some problems with it, my windows7 are 64bit and when I want to update my Eclipse for download I have some problems, becouse some tools packs are only for 32bit.
Or If I am wrong, I need to download only server from there:
http://www.l2jserver.com/nightly/index. ... terlude%2F ?

Re: GameServer Starting problem

Posted: Fri Jul 27, 2012 2:17 pm
by jurchiks
Yes, you'd better use Eclipse, it would make lots of things easier.
some tools packs are only for 32bit
what tools? For l2j, you only need Eclipse IDE for JAVA Developers, and subversive supports 64 bits.

Re: GameServer Starting problem

Posted: Fri Jul 27, 2012 2:21 pm
by KingSton
When you wrote I understood how to set it online. So, I just download files with Eclipse. And maybe last question:
Files which I will download with Eclipse are latest and I don't need to update something?

Re: GameServer Starting problem

Posted: Fri Jul 27, 2012 2:54 pm
by jurchiks
SVN is always the latest for branches.

Re: GameServer Starting problem

Posted: Fri Jul 27, 2012 3:19 pm
by KingSton
and there is another problem which I had in the past. SQL files (armor.sql...) are bad, so I can't instal database.

Re: GameServer Starting problem

Posted: Fri Jul 27, 2012 4:04 pm
by jurchiks
If you get errors, post them here, maybe someone will bother to fix them in SVN if they're actual errors.