Database

~~khemomo~~ · 05/25/2018, 05:26

I have a problem with my database it says that

Code:

2018/05/25	11:17:32
query:uspSaveDropFilter @idPlayer='0000006', [MENTION=2138478]serverin[/MENTION]dex='01' [MENTION=2599708]dwf[/MENTION]ilter0=5260639, [MENTION=2599708]dwf[/MENTION]ilter1=0, [MENTION=2599708]dwf[/MENTION]ilter2=0, [MENTION=2599708]dwf[/MENTION]ilter3=0
SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'uspSaveDropFilter'.

Code:

[2018- 5-25 11:17:32] (LOG) CDbManager::SaveDropFilter(694):	uspSaveDropFilter @idPlayer='0000006', [MENTION=2138478]serverin[/MENTION]dex='01' [MENTION=2599708]dwf[/MENTION]ilter0=5260639, [MENTION=2599708]dwf[/MENTION]ilter1=0, [MENTION=2599708]dwf[/MENTION]ilter2=0, [MENTION=2599708]dwf[/MENTION]ilter3=0

even I have a "m_dwDropFilter int and allow nulls" in my Character_TBL

can someone help me how to fix this because my pet filter is not saving as you relog. thank you

Flogolo · 05/25/2018, 05:31

Maybe try to change the value from int to varchar?

~~khemomo~~ · 05/25/2018, 07:11

Quote:

Originally Posted by Flogolo

Maybe try to change the value from int to varchar?

I already try that one but still

Code:

Could not find stored procedure 'uspSaveDropFilter'.

Flogolo · 05/25/2018, 07:17

Quote:
Originally Posted by khemomo
I already try that one but still
Code:
Could not find stored procedure 'uspSaveDropFilter'.

Is there a "uspDropFilter" in ur db?

~~khemomo~~ · 05/25/2018, 07:35

Quote:

Originally Posted by Flogolo

Is there a "uspDropFilter" in ur db?

I dont have uspdropfilter but does it mean m_dwDropFilter?
but where can i put that thing?

Flogolo · 05/25/2018, 07:55

Create it by urself in MSSQL, the content of the table u will find in ur first post in this thread here

~~khemomo~~ · 05/25/2018, 08:15

#CloseRequest

Now working adding addtional datatabase entry

KingKeesie · 05/25/2018, 08:37

Could not find stored procedure 'uspSaveDropFilter'. Try adding procedure again