dev rev 4 Char Server and World Server Fatal Error.

[Khris Xhan]

i try to build a private server using dev rev4, but i came up to this problem in char server: FATAL ERROR could not execute query: Table 'roseon.items_newchar doesn't exist and in world server: FATAL ERROR could not execute query: Unknown column 'davertise active' in 'field list'. can you tell me which file im missing? Any help is highly appreciated. Thank you in advance and more power.

here are some screenshot of the servers:

[MentaL]

[WarKeyGFX]

there are no tables on your database :)

[Purpleyouko]

Well there must be some tables there. It started loading the config table. just couldn't find the field named "advertize_active"

The problem is that the tables listed in the errors (and possibly more) are completely missing from the server installation.
Try looking in the "database/new_tables" folder and you will find a file called "items_newchar.sql"
Run this sql query file into your database to build the missing table.

As for that advertize entry, that was dropped from the roseZA source code before general release so I don't know where the heck that came from. It certainly isn't in my version of the code.

you could delete the reference to it in function LoadConfig() in startup.cpp but that could cause a bunch of problems as all the following fields would be offset.
Easiest thing to do is just edit the database table "list_config" and simply add a field by the name of "advertize_active" then set its value to zero. Doesn't matter where the filed goes in the table. You can add it at the start, the end or the middle. Whichever is easiest for you.

[Khris Xhan]

Well there must be some tables there. It started loading the config table. just couldn't find the field named "advertize_active"

The problem is that the tables listed in the errors (and possibly more) are completely missing from the server installation.
Try looking in the "database/new_tables" folder and you will find a file called "items_newchar.sql"
Run this sql query file into your database to build the missing table.

As for that advertize entry, that was dropped from the roseZA source code before general release so I don't know where the heck that came from. It certainly isn't in my version of the code.

you could delete the reference to it in function LoadConfig() in startup.cpp but that could cause a bunch of problems as all the following fields would be offset.
Easiest thing to do is just edit the database table "list_config" and simply add a field by the name of "advertize_active" then set its value to zero. Doesn't matter where the filed goes in the table. You can add it at the start, the end or the middle. Whichever is easiest for you.

Thank you so much Purpleyouko. its a big help that there are people like you in this forum. Also thanks to WarKeyGFX for responding its nice to know that there are active members in this forum. Thank you and more power to you!

[Khris Xhan]

another error in world server couldnt locate where is this XD



i gave up in dev rev4 couldnt locate the database/new_tables" folder in my files so i try dev rev 3 and i cought up in this.

[Purpleyouko]

The only table that uses "accesslevel" is "accounts".

The error is almost certainly being generated in function bool CWorldServer::pakDoIdentify( CPlayer *thisclient, CPacket *P ) in Worldpackets.cpp

If your "accounts" table is missing this field then I wonder what else is wrong with the installation

[Khris Xhan]

i have already find a way to avoid it i created a table called lotto_config and warning_system:

but the problem is when i connect with my character it will load forever

and when i exit the client the world server goes like this

[WarKeyGFX]

bro your telling us that you are using DEV REV 4 right? but the thing is the one that i observed. your client is pretty wrong

[Purpleyouko]

As pointed out by WarKeyGFX That does not appear to be client 437 which is the one that works with dev rev 4

the tree house entry screen was dropped long before 437

[Khris Xhan]

i have already find a way to avoid it i created a table called lotto_config and warning_system:

but the problem is when i connect with my character it will load forever

and when i exit the client the world server goes like this

im sorry for some misunderstandings i have already given up with dev rev 4 cause i couldnt locate the " database/new_tables folder" from the files i downloaded so i move back to dev rev 3, i have succesfully setup dev rev and dev rev 2. so this server files is of dev rev 3.

[WarKeyGFX]

alright, better get dev rev 2 than rev 3 IMO because you cant really play in Dev rev III

[Purpleyouko]

try KTRose pre-evo source.
At least that way there's no confusion over the client.
It only works with client 112 and we include a fully patched version of it for you.

Also works pretty well compared to all the others.

[Khris Xhan]

try KTRose pre-evo source.
At least that way there's no confusion over the client.
It only works with client 112 and we include a fully patched version of it for you.

Also works pretty well compared to all the others.

where can i download it? Thanks for the advice =D thank you so much WarKeyGFX and Purpleyouko for helping me XD

[WarKeyGFX]

here is the link

osROSE Forums • View topic - KTRose Source code release

[Khris Xhan]

here is the link

osROSE Forums • View topic - KTRose Source code release

Thank you so much WarKeyGFX for the link. and more power to you!

BTW i have already made dev rev 3 working, i only forgot to execute the database.sql XD thank you so much for the guidance guys =)