Jump to content
MaxCheaters Official Group on X
MaxCheaters Official Group on Discord
--> Place your ad text here <--
  • 0

L2 Cached - Sql 42000 Error

GARAB

Asked by GARAB,

 Share

Question

GARAB Newbie

GARAB

Posted
Posted

Hi all!

 

 

Maybe I'm getting a little irritating wtih my questions, but I hope this will be one of the last ones.

So our CacheD server can't do it's job. It start and connects to log server, and the server itself can connect to it. The problem is that it can save the NPCbosses, or cant createlin attack time record.

 

Error sql: EXEC lin_DreateTimeAttackRecord 3, 2, 0, 0, 0, 0, 0, 0, N'', N'',0 ,0 (0)
Error 42000:[Microsoft][ODBC SQL Server Driver]
Could not find stored procedure 'lin_CreateTimeAttackRecord'.
 
and some korean stuff, with this:
[korean text][207] Cannot creat time attack info room_no[5], record_type=[2]
 
So, the ODBC is okay, it connects to the proper database, and the user has permissons in mssql, to execute, write, etc, etc, so full control and the stored procedures are there, so they exist.
 
Any ideas? Thanks!
 
08/10/2014 22:59:57.964, Error sql: UPDATE castle SET next_war_time = 1366552800 WHERE id = 7 (0)
08/10/2014 22:59:57.964, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle'.
08/10/2014 22:59:57.986, Error sql: EXEC lin_SaveCastleStatus 1, 3 (0)
08/10/2014 22:59:57.986, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:57.986, Error occurred in Saving Castle Status
08/10/2014 22:59:57.986, Error sql: UPDATE castle SET next_war_time = 1366552800 WHERE id = 3 (0)
08/10/2014 22:59:57.986, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle'.
08/10/2014 22:59:58.236, Error sql: DELETE FROM castle_war WHERE castle_id = 4 (0)
08/10/2014 22:59:58.236, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle_war'.
08/10/2014 22:59:58.242, Error sql: EXEC lin_SaveCastleStatus 0, 4 (0)
08/10/2014 22:59:58.242, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:58.242, Error occurred in Saving Castle Status
08/10/2014 22:59:58.243, Error sql: EXEC lin_LoadNpcBoss N'dr_chaos_gigantic_golem' (0)
08/10/2014 22:59:58.243, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_LoadNpcBoss'.
08/10/2014 22:59:58.243, [.\NpcDbSocket.cpp][1016] No record in table, npc dbname[dr_chaos_gigantic_golem]
08/10/2014 22:59:58.243, Error sql: EXEC lin_SaveNpcBoss N'dr_chaos_gigantic_golem',0,0,0,0,0,0,0,0 (0)
08/10/2014 22:59:58.243, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveNpcBoss'.
08/10/2014 22:59:58.243, [.\NpcDbSocket.cpp][1024] Save NpcBoss Failed! Npc DBName[dr_chaos_gigantic_golem]
08/10/2014 22:59:58.373, Error sql: DELETE FROM castle_war WHERE castle_id = 8 (0)
08/10/2014 22:59:58.373, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle_war'.
08/10/2014 22:59:58.381, Error sql: EXEC lin_SaveCastleStatus 0, 8 (0)
08/10/2014 22:59:58.381, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:58.381, Error occurred in Saving Castle Status
08/10/2014 22:59:58.425, Error sql: DELETE FROM castle_war WHERE castle_id = 9 (0)
08/10/2014 22:59:58.425, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle_war'.
08/10/2014 22:59:58.431, Error sql: EXEC lin_SaveCastleStatus 0, 9 (0)
08/10/2014 22:59:58.431, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:58.431, Error occurred in Saving Castle Status
08/10/2014 22:59:58.463, Error sql: DELETE FROM castle_war WHERE castle_id = 1 (0)
08/10/2014 22:59:58.463, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle_war'.
08/10/2014 22:59:58.474, Error sql: EXEC lin_SaveCastleStatus 0, 1 (0)
08/10/2014 22:59:58.474, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:58.474, Error occurred in Saving Castle Status
08/10/2014 22:59:58.621, Error sql: EXEC lin_LoadNpcBoss N'freya_royalguard' (0)
08/10/2014 22:59:58.621, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_LoadNpcBoss'.
08/10/2014 22:59:58.621, [.\NpcDbSocket.cpp][1016] No record in table, npc dbname[freya_royalguard]
08/10/2014 22:59:58.621, Error sql: EXEC lin_SaveNpcBoss N'freya_royalguard',0,0,0,0,0,0,0,0 (0)
08/10/2014 22:59:58.621, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveNpcBoss'.
08/10/2014 22:59:58.621, [.\NpcDbSocket.cpp][1024] Save NpcBoss Failed! Npc DBName[freya_royalguard]
08/10/2014 22:59:58.712, Error sql: DELETE FROM castle_war WHERE castle_id = 2 (0)
08/10/2014 22:59:58.713, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle_war'.
08/10/2014 22:59:58.722, Error sql: EXEC lin_SaveCastleStatus 0, 2 (0)
08/10/2014 22:59:58.722, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:58.722, Error occurred in Saving Castle Status
08/10/2014 22:59:58.809, Error sql: DELETE FROM castle_war WHERE castle_id = 6 (0)
08/10/2014 22:59:58.809, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle_war'.
08/10/2014 22:59:58.817, Error sql: EXEC lin_SaveCastleStatus 0, 6 (0)
08/10/2014 22:59:58.817, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:58.817, Error occurred in Saving Castle Status
08/10/2014 22:59:58.903, Error sql: DELETE FROM castle_war WHERE castle_id = 5 (0)
08/10/2014 22:59:58.903, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle_war'.
08/10/2014 22:59:58.913, Error sql: EXEC lin_SaveCastleStatus 0, 5 (0)
08/10/2014 22:59:58.913, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:58.913, Error occurred in Saving Castle Status
08/10/2014 22:59:58.973, Error sql: EXEC lin_SaveCastleStatus 2, 7 (0)
08/10/2014 22:59:58.973, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:58.973, Error occurred in Saving Castle Status
08/10/2014 22:59:58.978, Error sql: EXEC lin_SaveCastleStatus 2, 3 (0)
08/10/2014 22:59:58.978, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:58.978, Error occurred in Saving Castle Status
08/10/2014 22:59:59.231, Error sql: EXEC lin_SaveCastleStatus 1, 4 (0)
08/10/2014 22:59:59.231, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:59.231, Error occurred in Saving Castle Status
08/10/2014 22:59:59.241, Error sql: UPDATE castle SET next_war_time = 1367690400 WHERE id = 4 (0)
08/10/2014 22:59:59.241, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle'.
08/10/2014 22:59:59.370, Error sql: UPDATE castle SET next_war_time = 1367690400 WHERE id = 8 (0)
08/10/2014 22:59:59.370, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle'.
08/10/2014 22:59:59.371, Error sql: EXEC lin_SaveCastleStatus 1, 8 (0)
08/10/2014 22:59:59.371, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:59.371, Error occurred in Saving Castle Status
08/10/2014 22:59:59.427, Error sql: UPDATE castle SET next_war_time = 1367690400 WHERE id = 9 (0)
08/10/2014 22:59:59.427, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle'.
08/10/2014 22:59:59.427, Error sql: EXEC lin_SaveCastleStatus 1, 9 (0)
08/10/2014 22:59:59.427, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:59.427, Error occurred in Saving Castle Status
08/10/2014 22:59:59.462, Error sql: EXEC lin_SaveCastleStatus 1, 1 (0)
08/10/2014 22:59:59.462, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:59.462, Error occurred in Saving Castle Status
08/10/2014 22:59:59.463, Error sql: UPDATE castle SET next_war_time = 1367690400 WHERE id = 1 (0)
08/10/2014 22:59:59.463, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle'.
08/10/2014 22:59:59.711, Error sql: EXEC lin_SaveCastleStatus 1, 2 (0)
08/10/2014 22:59:59.711, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:59.711, Error occurred in Saving Castle Status
08/10/2014 22:59:59.721, Error sql: UPDATE castle SET next_war_time = 1367690400 WHERE id = 2 (0)
08/10/2014 22:59:59.721, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle'.
08/10/2014 22:59:59.744, Error sql: EXEC lin_LoadNpcBoss N'benom' (0)
08/10/2014 22:59:59.744, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_LoadNpcBoss'.
08/10/2014 22:59:59.744, [.\NpcDbSocket.cpp][1016] No record in table, npc dbname[benom]
08/10/2014 22:59:59.744, Error sql: EXEC lin_SaveNpcBoss N'benom',0,0,0,0,0,0,0,0 (0)
08/10/2014 22:59:59.744, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveNpcBoss'.
08/10/2014 22:59:59.745, [.\NpcDbSocket.cpp][1024] Save NpcBoss Failed! Npc DBName[benom]
08/10/2014 22:59:59.805, Error sql: EXEC lin_SaveCastleStatus 1, 6 (0)
08/10/2014 22:59:59.805, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:59.805, Error occurred in Saving Castle Status
08/10/2014 22:59:59.806, Error sql: UPDATE castle SET next_war_time = 1367762400 WHERE id = 6 (0)
08/10/2014 22:59:59.806, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle'.
08/10/2014 22:59:59.899, Error sql: EXEC lin_SaveCastleStatus 1, 5 (0)
08/10/2014 22:59:59.899, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:59.899, Error occurred in Saving Castle Status
08/10/2014 22:59:59.909, Error sql: UPDATE castle SET next_war_time = 1367762400 WHERE id = 5 (0)
08/10/2014 22:59:59.909, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle'.
08/10/2014 22:59:59.971, Error sql: DELETE FROM castle_war WHERE castle_id = 7 (0)
08/10/2014 22:59:59.971, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle_war'.
08/10/2014 22:59:59.971, Error sql: EXEC lin_SaveCastleStatus 0, 7 (0)
08/10/2014 22:59:59.971, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:59.971, Error occurred in Saving Castle Status
08/10/2014 22:59:59.986, Error sql: DELETE FROM castle_war WHERE castle_id = 3 (0)
08/10/2014 22:59:59.986, Error 42S02:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid object name 'castle_war'.
08/10/2014 22:59:59.989, Error sql: EXEC lin_SaveCastleStatus 0, 3 (0)
08/10/2014 22:59:59.989, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'lin_SaveCastleStatus'.
08/10/2014 22:59:59.989, Error occurred in Saving Castle Status
 

 

6 answers to this question

Recommended Posts

  • 0
xeL Apprentice

xeL

Posted
Posted

I use the Vanganth 1.2.3.6 pack, that was among the shared files on the forum.

Is shared by me and has all needed sql. Should run ok. For sure you didn't installed something.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to question listing


×
×
  • Create New...