I can not create a single character from a week of searching day and night.

[homester]

Hi

Please it's been a week since I try to create a single character and I still have the same error 3010

I tried every solution I found on google and I download more than 30GB of client and server and SQL instaler 2005 and 2008 data base.
I once spent over 30 hours at the computer and I was very angry.
please I lost all hope. I think I am the only one on this forum who can not create a character. if someone want to use team viewer I am ready.
amine4d@gmail.com



cleaned db: ko

If ( sec_primary = 1,sec_content = 1 ) and = Account GM then Creat new character : ko

set ur state to 0 : i dont inderstand :(


ERROR SR_Shardmanager

Query Error!!! Query Result : -1, Query : {?=CALL _AddNewChar (1420, 14875,'mmmm',34,26957,1466.000000,79.000000,1488.000000,19554,11620,11621,11622,10887,0,39,39,39,66,0,0)}

SQL Error State:23000, Native Error Code: 223, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK__User__AccountJID". The conflict occurred in database "SRO_VT_SHARD_INIT", table "dbo

{?=CALL _AddNewChar (1420, 14875,'mmmm',34,26957,1466.000000,79.000000,1488.000000,19554,11620,11621,11622,10887,0,39,39,39,66,0,0)}

SQL Error State:01000, Native Error Code: E25, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

{?=CALL _AddNewChar (1420, 14875,'mmmm',34,26957,1466.000000,79.000000,1488.000000,19554,11620,11621,11622,10887,0,39,39,39,66,0,0)}

Failed To execute _AddNewChar ! [jid: 1420, odbc err: -1]

[MentaL]

[sladlejrhfpq]

Hi

Please it's been a week since I try to create a single character and I still have the same error 3010

I tried every solution I found on google and I download more than 30GB of client and server and SQL instaler 2005 and 2008 data base.
I once spent over 30 hours at the computer and I was very angry.
please I lost all hope. I think I am the only one on this forum who can not create a character. if someone want to use team viewer I am ready.
amine4d@gmail.com



cleaned db: ko

If ( sec_primary = 1,sec_content = 1 ) and = Account GM then Creat new character : ko

set ur state to 0 : i dont inderstand :(


ERROR SR_Shardmanager

Query Error!!! Query Result : -1, Query : {?=CALL _AddNewChar (1420, 14875,'mmmm',34,26957,1466.000000,79.000000,1488.000000,19554,11620,11621,11622,10887,0,39,39,39,66,0,0)}

SQL Error State:23000, Native Error Code: 223, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK__User__AccountJID". The conflict occurred in database "SRO_VT_SHARD_INIT", table "dbo

{?=CALL _AddNewChar (1420, 14875,'mmmm',34,26957,1466.000000,79.000000,1488.000000,19554,11620,11621,11622,10887,0,39,39,39,66,0,0)}

SQL Error State:01000, Native Error Code: E25, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

{?=CALL _AddNewChar (1420, 14875,'mmmm',34,26957,1466.000000,79.000000,1488.000000,19554,11620,11621,11622,10887,0,39,39,39,66,0,0)}

Failed To execute _AddNewChar ! [jid: 1420, odbc err: -1]

are you sure your database is properly cleaned?

[K4bo]

First Clean your DB

then make new account and make the sec_premier and sec_content
0 0

then make new char after it change the sec_premier and sec_content
1 1


XD

[homester]

thank you for your reply

to clean the data base i use this
http://forum.ragezone.com/f723/clean-shard-db-787976/

i creat new account with 0 0 and the same error
i have 10 client installer, i use 2 of them version 188 ,the other version can't log
the only client work is silkroad _testin v1.188

plz give me a tutorial that you tried and if it does not work I'll reinstall windows

i have other question. on the table dbo_Guild it s normal that i found a guild named "dummy" with ID = 0 because i can't deleted and i found it on all data base i donload. the ID colone must be not null (look Columns)
ERROR :

[serend]

yes dummy guild is good we all have this

[homester]

what can i do?
if some one can use team viewer plz. I try all.

[homester]

6 hour lost

someone gives me his database with an account that contains character plz.
i give UP

[homester]

oooooooooooooooooooooooh
i fix it partialy, i can log in but disconnection after 2 s. good

[RevoLand]

oooooooooooooooooooooooh
i fix it partialy, i can log in but disconnection after 2 s. good

if you get D/C in 1-2sec check iis/DBConnect.asp

[homester]

yes don.Tnx

now i m happy and i can sleep :)