Skip to content

L2 Cached - Sql 42000 Error

Featured Replies

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
 

 

Not all lin2world updates are installed. Install all

  • Author

Not all lin2world updates are installed. Install all

I installed all, that was in the pack. I don't have more.

Is not all instaled. You use the pack posted by me?

  • Author

Is not all instaled. You use the pack posted by me?

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

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.

Create an account or sign in to comment

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.