Database

05/25/2018 05:26 khemomo#1
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 :)
05/25/2018 05:31 Flogolo#2
Maybe try to change the value from int to varchar?
05/25/2018 07:11 khemomo#3
Quote:
Originally Posted by Flogolo View Post
Maybe try to change the value from int to varchar?
I already try that one but still
Code:
Could not find stored procedure 'uspSaveDropFilter'.
05/25/2018 07:17 Flogolo#4
Quote:
Originally Posted by khemomo View Post
I already try that one but still
Code:
Could not find stored procedure 'uspSaveDropFilter'.
Is there a "uspDropFilter" in ur db? :confused:
05/25/2018 07:35 khemomo#5
Quote:
Originally Posted by Flogolo View Post
Is there a "uspDropFilter" in ur db? :confused:

I dont have uspdropfilter but does it mean m_dwDropFilter?
but where can i put that thing?
05/25/2018 07:55 Flogolo#6
Create it by urself in MSSQL, the content of the table u will find in ur first post in this thread here
05/25/2018 08:15 khemomo#7
#CloseRequest

Now working adding addtional datatabase entry
05/25/2018 08:37 KingKeesie#8
Could not find stored procedure 'uspSaveDropFilter'. Try adding procedure again