World server Fatal error

[loveplays]

Hello
im running a dev2 server which i found in the released section
after setting up everything
im able to log in and when i create a character everything is working perfectly fine
then when i try to enter the game i get an error from the worldserver saying

Fatal Error: Could not execute query: Unknown column ' nb_reborn' in 'field list'

how to fix this?

[MentaL]

[Purpleyouko]

go into your database and add a field called nb_reborn to the character table. My guess is that it should be set as an INT with a default value of zero

[loveplays]

go into your database and add a field called nb_reborn to the character table. My guess is that it should be set as an INT with a default value of zero

alright ive done that
now the worldserver just crashes

[Purpleyouko]

how does it crash?

All crashes leave evidence of some kind behind.... except possibly those ones where the thing just disappears without warning.

Try running the server in debug mode directly from codeblocks

[loveplays]

how does it crash?

All crashes leave evidence of some kind behind.... except possibly those ones where the thing just disappears without warning.

Try running the server in debug mode directly from codeblocks

can you connect with me through teamviewer to check it out?
because the world server just crashes instantly

- - - Updated - - -

can you connect with me through teamviewer to check it out?
because the world server just crashes instantly

the worldserver log is too large for me to copy it to here
so im just uploading it
here it isworldserverlog.txtworldserverlog.txt

[Purpleyouko]

That log shows a successful login.

It also shows that you are not loading in any of the data related to NPCs, items and pretty much everything else.
Did you extract all the STBs from your client and put them in the binary\3ddata\STB folder of your server?
Same for QSD and AIP.

[loveplays]

That log shows a successful login.

It also shows that you are not loading in any of the data related to NPCs, items and pretty much everything else.
Did you extract all the STBs from your client and put them in the binary\3ddata\STB folder of your server?
Same for QSD and AIP.

yes i did all of the files are extracted

[Razzrage]

you should use the database that animalcrackerz gived you.

[loveplays]

That log shows a successful login.

It also shows that you are not loading in any of the data related to NPCs, items and pretty much everything else.
Did you extract all the STBs from your client and put them in the binary\3ddata\STB folder of your server?
Same for QSD and AIP.

here is a video that i just made that shows the problem
http://www.youtube.com/watch?v=IkIBavkqsec

[Purpleyouko]

From the inoutpackets file that you uploaded

Tue Aug 05 21:51:56 2014 - STB Data             
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_NPC.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_SKILL.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_STATUS.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_FACEITEM.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_CAP.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_BODY.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_ARMS.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_FOOT.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_BACK.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_JEWEL.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_WEAPON.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_SUBWPN.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_USEITEM.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_JEMITEM.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_NATURAL.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_QUESTITEM.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_PAT.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_PRODUCT.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_SELL.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\ITEM_DROP.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_BREAK.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_ZONE.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_CLASS.STB'
Tue Aug 05 21:51:56 2014 - Could not load STB '3DDataPeg\STB\LIST_GRADE.STB'
Tue Aug 05 21:51:56 2014 - STL Data             
Tue Aug 05 21:51:56 2014 - Could not load STL '3DDataPeg\STB\LIST_FACEITEM_S.STL'
Tue Aug 05 21:51:56 2014 - Could not load STL '3DDataPeg\STB\LIST_CAP_S.STL'
Tue Aug 05 21:51:56 2014 - Could not load STL '3DDataPeg\STB\LIST_BODY_S.STL'
Tue Aug 05 21:51:56 2014 - Could not load STL '3DDataPeg\STB\LIST_ARMS_S.STL'
Tue Aug 05 21:51:56 2014 - Could not load STL '3DDataPeg\STB\LIST_FOOT_S.STL'
Tue Aug 05 21:51:56 2014 - Could not load STL '3DDataPeg\STB\LIST_BACK_S.STL'
Tue Aug 05 21:51:56 2014 - Could not load STL '3DDataPeg\STB\LIST_JEWEL_S.STL'
Tue Aug 05 21:51:56 2014 - Could not load STL '3DDataPeg\STB\LIST_WEAPON_S.STL'
Tue Aug 05 21:51:56 2014 - Could not load STL '3DDataPeg\STB\LIST_SUBWPN_S.STL'
Tue Aug 05 21:51:56 2014 - Could not load STL '3DDataPeg\STB\LIST_USEITEM_S.STL'
Tue Aug 05 21:51:56 2014 - Could not load STL '3DDataPeg\STB\LIST_JEMITEM_S.STL'
Tue Aug 05 21:51:56 2014 - Could not load STL '3DDataPeg\STB\LIST_NATURAL_S.STL'
Tue Aug 05 21:51:56 2014 - Could not load STL '3DDataPeg\STB\LIST_QUESTITEM_S.STL'
Tue Aug 05 21:51:56 2014 - Could not load STL '3DDataPeg\STB\LIST_PAT_S.STL'
Tue Aug 05 21:51:56 2014 - Could not load STL '3DDataPeg\STB\LIST_NPC_S.STL'
Tue Aug 05 21:51:56 2014 - Could not load STL '3DDataPeg\STB\STR_ITEMPREFIX.STL'
Tue Aug 05 21:51:56 2014 - Could not load STL '3DDataPeg\STB\LIST_SKILL_S.STL'
Tue Aug 05 21:51:56 2014 - Could not load STL '3DDataPeg\STB\LIST_QUEST_S.STL'
Tue Aug 05 21:51:56 2014 - Could not load STL '3DDataPeg\STB\LIST_ZONE_S.STL'

For some reason it isn't loading in any of your STBs and that means that is is also not loading in QSD and AIP files either since the STB points to their location.
Note that it is attempting to load from 3DDataPeg\STB and NOT 3DData\STB. That is your main problem.
I saw in your video that is_pegasus (table list_config) is set to 1.
Set it to 0 and try again. You should not be loading any data from 3DDataPeg. A lot of stuff in there is incompatible with a normal rose server.

Also; Why are you using the KTRose launcher to run your EVO client? Doesn't really matter i suppose but it is always going to give you a patching error since I'm not running teh patch server any more. Good job too otherwise it would completely destroy your EVO installation by patching most of the files with versions that can't run under an evo client.

[loveplays]

okay :)
i fixed it :D
thank you :D

[AnimalCrackerz]

Sorry about swiping your launcher PY but i use a different launcher and couldnt find a standard neoncube to include with the client so i borrowed yours and set everything in the neoncube.ini to 127.0.0.1, and in the Binary/3DData folder I included the Ai, Questdata, STB folders in a .rar that are from the client...I left the folders blank incase anyone wanted to use a different client...included read me files with directions...dont use the database file in the sql table files in the Data folder use the single database.sql file provided in same folder. I retested this again after so many posts about errors but when i install it myself if get no errors....

[Garnet]

Hi AnimalCrackerz,

Are you talking about this thread? http://forum.ragezone.com/showthread.php?t=1018170

There is no problem with your release, maybe people didn't read the README.txt.

Maybe if you include the readme at the root of the server people will read it more :)