Invalid object name SR_CharAppoint FIX ?

01/01/2018 14:08 tvdynamo#1
I'm having an error from delete char, I use a clean database.

PHP Code:
Query Error!!! Query Result : -1, Query : exec _ManageShardCharName 0, 1207, 64, 'Dynamo', ''
SQL Error State:42S02, Native Error Code: D0, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'SR_CharAppoint'.
exec _ManageShardCharName 0, 1207, 64, 'Dynamo', '' 
01/01/2018 14:24 nex1993#2
Quote:
Originally Posted by tvdynamo View Post
I'm having an error from delete char, I use a clean database.

PHP Code:
Query Error!!! Query Result : -1, Query : exec _ManageShardCharName 0, 1207, 64, 'Dynamo', ''
SQL Error State:42S02, Native Error Code: D0, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'SR_CharAppoint'.
exec _ManageShardCharName 0, 1207, 64, 'Dynamo', '' 
Can you tell us what kind of files did you use ?
As i see for 99 % its something wrong on the _ManageShardCharName. Did you checked this procedure ?
01/01/2018 15:32 tvdynamo#3
Quote:
Originally Posted by nex1993 View Post
Can you tell us what kind of files did you use ?
As i see for 99 % its something wrong on the _ManageShardCharName. Did you checked this procedure ?
PHP Code:
USE [SRO_VT_ACCOUNT]
GO
/****** Object:  StoredProcedure [dbo].[_ManageShardCharName]    Script Date: 1/1/2018 9:31:04 PM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER procedure [dbo].[_ManageShardCharName]
 [MENTION=300085]JoB[/MENTION]        tinyint,
 [MENTION=292919]user[/MENTION]JID       int,
 [MENTION=4739374]Shardi[/MENTION]D       smallint,
 [MENTION=3898309]charname[/MENTION]     varchar(64),
 [MENTION=982728]Oldname[/MENTION]     varchar(64)
as
    -- add new char name
    if  [MENTION=300085]JoB[/MENTION] = 0)
    begin
        if (not exists(select * from SR_ShardCharNames where UserJID = [MENTION=292919]user[/MENTION]JID and ShardID = [MENTION=4739374]Shardi[/MENTION]D and CharName = [MENTION=3898309]charname[/MENTION]))
        begin
            insert SR_ShardCharNames values [MENTION=292919]user[/MENTION]JID, [MENTION=4739374]Shardi[/MENTION]D, [MENTION=3898309]charname[/MENTION])
        end
    end
    -- remove char name
    else if  [MENTION=300085]JoB[/MENTION] = 1)
    begin
        delete SR_ShardCharNames where UserJID = [MENTION=292919]user[/MENTION]JID and ShardID = [MENTION=4739374]Shardi[/MENTION]D and CharName = [MENTION=3898309]charname[/MENTION]
        delete SR_CharAppoint where UserJID = [MENTION=292919]user[/MENTION]JID and ShardID = [MENTION=4739374]Shardi[/MENTION]D and CharID = [MENTION=3898309]charname[/MENTION]
    end
    -- rename previous one
    else if  [MENTION=300085]JoB[/MENTION] = 2)
    begin
        update SR_ShardCharNames set CharName = [MENTION=3898309]charname[/MENTION] where UserJID = [MENTION=292919]user[/MENTION]JID and ShardID = [MENTION=4739374]Shardi[/MENTION]D and CharName = [MENTION=982728]Oldname[/MENTION]
        update SR_CharAppoint set CharID = [MENTION=3898309]charname[/MENTION] where UserJID = [MENTION=292919]user[/MENTION]JID and ShardID = [MENTION=4739374]Shardi[/MENTION]D and CharID = [MENTION=982728]Oldname[/MENTION]
    end