Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server
You last visited: Today at 01:53

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Creat chars/change name buged

Discussion on Creat chars/change name buged within the Shaiya Private Server forum part of the Shaiya category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jun 2011
Posts: 18
Received Thanks: 4
Creat chars/change name buged

Heya all guys

We got a problem, our database is doing tricks. A "bug" appened, people couldn't change the names of their toons or creat new ones. The server is running from almost 10mounths now, and that never appened before. Even like that, we tried the quiry that was around to "fix the name already in use problem", didn't work.
This is what appening

Logs;PS_DBAGENT__system.log

2011-10-20 14:45:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-10-20 14:45:20 ::CreateCharacter 42446 tatu retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'israel',12851,'tatu', 3,0,3,3,0,2,5,1, 1,0,0, 8,9,10,12,12,14, 290,295,160, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-10-20 14:45:20 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-10-20 14:45:21 VerifyReConnect : The Connection has been lost, SQLHDBC=dada68

2011-10-20 14:45:21 SDatabasePool::Reconnect:: success...

2011-10-20 14:45:27 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-10-20 14:45:27 ::CreateCharacter 39059 DEF_TANATOS_ retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'alessandro',12853,'DEF_TANATO S_', 1,3,3,2,2,4,1,0, 1,0,0, 12,9,14,10,10,10, 455,147,142, 2,0, 0,0, 1838.930054,129.330002,443.429993, 0,200,0,0,0)}

2011-10-20 14:45:27 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

Sorry for the big text but i tried to explain as much as i could. Apreciate for reading

Rayden
RaydenRey is offline  
Old 10/20/2011, 21:10   #2
 
eQuiNoX.'s Avatar
 
elite*gold: 0
Join Date: Jan 2011
Posts: 160
Received Thanks: 253
Try to execute:

Code:
DBCC DBReIndex ('PS_GameData.dbo.Chars')
eQuiNoX. is offline  
Thanks
4 Users
Old 10/22/2011, 23:40   #3
 
elite*gold: 0
Join Date: Jun 2011
Posts: 18
Received Thanks: 4
can't believe that was something so "easy"...tyvm

well a type for ADM's with same problems, i executed it on the old ps_gamedata ^^ might help . Once again tyvm Equinox
RaydenRey is offline  
Reply


Similar Threads Similar Threads
Avati bot buged
07/24/2011 - Archlord - 0 Replies
HIHO all hab ma ne kleine frage was den bot von avati angeht. der hatte bei mir die ganze zeit gut gefunkt ob es WIN 7 (x86/x64) wahr. nur jezze hab ich das prob ich wollte den BOT auf meinem lappi laufen lassen und habe alles so eingestellt wie sonns auch immer. naja nur jezze kommt egal an welchen system ich ihn teste das der bot keine x/y coords mehr findet ich habe soviel rumprobiert was grafik einstellung angeht und so mit und ohne fenster modus aber nicht geht kann mir da bitte vieleciht...
how can i change the names of the chars in the db?
06/30/2011 - Shaiya Private Server - 5 Replies
hello, i have a question. i want to know how i can edit the name of my GM char on my private server, but i dont know how. can anyone help me?
HELP ME 1 CHAR buged
05/31/2010 - SRO Private Server - 4 Replies
what i have to do.. When i login i have to choose char and i choose 117 and i got crash.. no error. but in that acc 95 lv glavier work perfeclty :) YouTube - Swsro error
Is there anyway to change a chars email w/o info
11/24/2006 - Conquer Online 2 - 1 Replies
<is there anyway to change a chars email without knowing info?> I was told there was some way to do with with ArtMoney i have tried a few times but i wasent sure so i thought i would try to ask someone who would knowtext2schild.php?smilienummer=1&text=Lol. Please help' border='0' alt='Lol. Please help' />
i wanna change my chars body type
10/01/2005 - Conquer Online 2 - 5 Replies
is there anyway to change my trojan from a small build to a big build im 130 reborn and im tired of lookin at the small bodyed male char, can anyone plz help me?



All times are GMT +1. The time now is 01:58.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.