VSRO Server Files [v188]

[RevoLand]

Hey guys,
I got the following problem with my vSro Server setup.
Everything seems to work well on the server side, and on the client side too.

The only problem is, if I start my client i cant start playing with my char.

I do can succesfully log into my sro account, and of course i can create characters. I already tested with Chinese and europeans...

I can select the char, and the camera is moving to the char, but i cant press the start button...


Maybe somebody knows any solution?

Client version / which client did you using? any error on exes?

[DurtyFree]

Nope, no errors. And I use the cracked no xtrap client v188

I'll explain the problem again:
Everything works fine; BUT:
If I am logged into my account, I can't start a game with any of my characters. If I select a character the camera moves towards the char (normal...) and if I press "start" the game doesnt start... It just hangs in the screen, no error, no exe crashes. Nothing.

[RevoLand]

Nope, no errors. And I use the cracked no xtrap client v188

I'll explain the problem again:
Everything works fine; BUT:
If I am logged into my account, I can't start a game with any of my characters. If I select a character the camera moves towards the char (normal...) and if I press "start" the game doesnt start... It just hangs in the screen, no error, no exe crashes. Nothing.

Hmm, did you cleaned Shard-Account-Log DB?

[DurtyFree]

I used the cleaned database for mssql 2005 from here: http://forum.ragezone.com/f722/fully...-mssql-782657/

So it should be cleaned

[RevoLand]

I used the cleaned database for mssql 2005 from here: http://forum.ragezone.com/f722/fully...-mssql-782657/

So it should be cleaned

Can you try original database with cleaned by you?

How to CLEAN Databases
Link: http://forum.ragezone.com/f723/serio...f-vsro-780308/ (Account - Log)
Link: http://forum.ragezone.com/f723/clean-shard-db-787976/ (Shard)

[DurtyFree]

Ok I cleaned the cleaned database again and carefully looked for some errors appearing when i try to start playing with any char i got.

These are errors i got:
GlobalManager
unhandled msg received CGlobalManagerMainProcess : IP:5.116.53.25 Req:0x041A (0x0000) (MsgType:7), 41 - 41
execute query error : exec _AddCurrentUserCount 64, 0, '2012-7-15 13:46:57'
Query Error!!! Query Result : -1, Query : exec _AddCurrentUserCount 64, 0, '2012-7-15 13:46:57'
SQL Error State:42000, Native Error Code: 1FB2, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime.
exec _AddCurrentUserCount 64, 0, '2012-7-15 13:46:57'

SR_GameServer
Query Error!!! Query Result : -1, Query : {CALL _AddLogSchedule ('SR_GameServer', 713, 'SCHEDULE_DEF_BATTLE_ARENA_JOB_PARTICIPATION', 388, 'Start', '2012-07-15 13:46:06')}
SQL Error State:42000, Native Error Code: 1FB2, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime.
{CALL _AddLogSchedule ('SR_GameServer', 713, 'SCHEDULE_DEF_BATTLE_ARENA_JOB_PARTICIPATION', 388, 'Start', '2012-07-15 13:46:06')}
Query Error!!! Query Result : -1, Query : {?=CALL _DelExpiredRentItemInStorage (0, 7844,'2012-7-15 13:47:42')}
SQL Error State:42000, Native Error Code: 1FB2, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in smalldatetime.
{?=CALL _DelExpiredRentItemInStorage (0, 7844,'2012-7-15 13:47:42')}
CALL _DelExpiredRentItemInStorage failed!! StorageType[0],StorageID[7844]
LOADTARGET_CHARDATA_N_INVENTORY(PC Inventory) Failed (693)
Character Data Loading Failed[JID: 1419, CharID: 7844]
CharDataLoadingCompleted:: CharData loading failed![JID: 1419, CharID: 7844]


SR_ShardManager
SQL Error State:01000, Native Error Code: E25, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Die Anweisung wurde beendet.
INSERT INTO _LogSchedule VALUES( 'SR_ShardManager', 705, 'SCHEDULE_DEF_BATTLE_ARENA_JOB', 397, 'Start', '2012-07-15 13:50:01')
AQ_ScheduleInsertLog Query Failed!! Query : INSERT INTO _LogSchedule VALUES( 'SR_ShardManager', 705, 'SCHEDULE_DEF_BATTLE_ARENA_JOB', 397, 'Start', '2012-07-15 13:50:01')



//EDIT
I downloaded the blitzkrieg database and succesfully cleaned it + started the server.
I do can login, but after i created my char and try to select -> start playing with it, the same problem as before occures...

Here are the detailed fatal error msg thingys with the new database:
SR_ShardManager
OnSR_PREPARE_USER_ACK() - An error returned from GAMESERVER [DurtyFree >> error_code: 23]
msg is not completely used : IP:5.11.226.214 Ack:0x0002 (0x0000) (MsgType:11), 14 - 1

SR_GameServer
Query Error!!! Query Result : -1, Query : {?=CALL _DelExpiredRentItemInStorage (0, 6692,'2012-7-15 14:25:45')}
SQL Error State:42000, Native Error Code: 1FB2, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in smalldatetime.
{?=CALL _DelExpiredRentItemInStorage (0, 6692,'2012-7-15 14:25:45')}
CALL _DelExpiredRentItemInStorage failed!! StorageType[0],StorageID[6692]
LOADTARGET_CHARDATA_N_INVENTORY(PC Inventory) Failed (693)
Character Data Loading Failed[JID: 2, CharID: 6692]
CharDataLoadingCompleted:: CharData loading failed![JID: 2, CharID: 6692]

[RevoLand]

"Fehler beim Konvertieren des varchar-Datentyps in smalldatetime"
can you change your "Format" from Region and Language to another country like usa?

[DurtyFree]

Great, it finally works. Awesome! :)
Thx, i'll start playing around and testing stuff. But everything seems to work well :D

//Edit:
Okay, monsters dont seem to spawn, cauld that querry I used to get all regions working be the reason for that? http://forum.ragezone.com/f721/fix-s...1-game-795669/

[RevoLand]

Great, it finally works. Awesome! :)
Thx, i'll start playing around and testing stuff. But everything seems to work well :D

//Edit:
Okay, monsters dont seem to spawn, cauld that querry I used to get all regions working be the reason for that? http://forum.ragezone.com/f721/fix-s...1-game-795669/

Sure. Good luck

[DurtyFree]

//Edit
Fixed all bugs by myself ;)
Monsters didnt spawned because i screwed up my RefNest table, and I were invisible (Cause im GM), and that was the reason for my pets beeing invisible too.


But last question: How can i get CTF fixed? Cause everytime i teleport, i get the "10minutes blah, start ctf, blah register at..." message... I think its something with the schedule.

[RevoLand]

//Edit
Fixed all bugs by myself ;)
Monsters didnt spawned because i screwed up my RefNest table, and I were invisible (Cause im GM), and that was the reason for my pets beeing invisible too.


But last question: How can i get CTF fixed? Cause everytime i teleport, i get the "10minutes blah, start ctf, blah register at..." message... I think its something with the schedule.

b'coz 1 people not enough for CTF

[DurtyFree]

Of course... But i meant that everytime i teleport (teleporter, died, teleport to player or such) i get the CTF in 10 minutes information...

And is there a way to remove these annoying "0" messages?... They appear kinda random as a notice or something like that...

[misiek3510]

Hi. i have problem...

Can you help me ?

Take a look :

[Maliq]

There are two things this thread is missing: how to host server online from a router and an english patch/crack... I have looked online and found nothing but dead links so can someone please share some info?

[blacktronix]

i have a big problem
my friend can join to my server but i cant join :/
i get every time c9 error -.-
how i can fix them ?