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

Printable View

22-07-12
homester

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

:*::*::*::*:
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

http://c1109.hizliresim.com/11/9/16/6942.jpg

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]
22-07-12
sladlejrhfpq

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

Quote:

Originally Posted by 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

http://c1109.hizliresim.com/11/9/16/6942.jpg

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?
22-07-12
K4bo

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

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
22-07-12
homester

1 Attachment(s)

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

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 : Attachment 109586
23-07-12
serend

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

yes dummy guild is good we all have this
23-07-12
homester

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

what can i do?
if some one can use team viewer plz. I try all.
23-07-12
homester

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

:grr::grr::grr::grr::grr::grr::grr::grr::grr::grr::grr::grr::grr::grr::grr::grr::grr::grr:

6 hour lost

someone gives me his database with an account that contains character plz.
i give UP
23-07-12
homester

1 Attachment(s)

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

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

Attachment 109624
23-07-12
RevoLand

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

Quote:

Originally Posted by homester

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

Attachment 109624

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

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

yes don.Tnx :laugh:

now i m happy and i can sleep :)