Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing
  • 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.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to question listing


  • Posts

    • prostsmm
      Boost Your SEO with Rankopti – Premium Backlinks, Keywords

      By prostsmm · Posted

      NEW UPDATES ! 
    • NeoPacket0041
      HQ Photoshop | Verify Accs KYC, AML | Antiban 100% | PSD Tem

      By NeoPacket0041 · Posted

      LIVE VERIFICATION? SUMSUB? “IMPOSSIBLE”? ▪ Spoiler: it is possible — if you know who to work with. A client came in with a task to pass **live verification** on **WantToPay**, a Telegram virtual card service. On the platform side — **Sumsub**: liveness check, SMS, manual review. “Fast” and “by eye” simply don’t work here. › What was done: → analyzed the verification scenario and Sumsub requirements → built the correct flow: phone number, email, timing → **completed live verification remotely, without account handover** → handled SMS and confirmation codes → brought the process to final approval ▪ Result: → verification passed → access granted → no flags or repeat requests ▪ Live verification is not luck. It’s scenario-based preparation — not hope. › TG: @mustang_service ( https:// t.me/ mustang_service ) › Channel: Mustang Service ( https:// t.me/ +6RAKokIn5ItmYjEx ) *All data is published with the client’s consent.* #verification #sumsub #livecheck #kyc #case
    • Ave
      ⚜ Custom UPDATER / LAUNCHER ⚜

      By Ave · Posted

      IMPORTANT INFO: In a few days, I will switch to completely new code, written from scratch with a new download system, patch building and management system. The Updater will become true 2026 code with "foolproof systems". I'm going to create a Discord server for customers to request new ideas and features. FIRST CUSTOMERS ARE ALREADY USING THE NEW UPDATER ON LIVE SERVERS! Watch this topic for upcoming info because the new updater is around the corner! Yes, you can still use self-update on the previous updater! No, the new updater won't be compatible with the old patch system! A new build is required, but players who already have game files won't have to download the entire patch again! New templates and updates to existing templates are coming soon! Sneak peek:  
    • Databay
      █ 7,000,000+ RESIDENTIAL PROXIES ✅ FROM 0.65$ / GB █

      By Databay · Posted

      This is a bump: https://databay.com/
    • sandeagle
      CliExt.dll from Guytis IL Projects problem!!!

      By sandeagle · Posted

      i used guytis IL project and source. i found in his project there are 3 Client version source... 1,CliExt_H5   --->this one cant be compiled in VS2005,i did know why..is it for H5 client? 2,CliExtNew  --->this one is IL version ,but when i compiled it and use it.player cant login game,MD5Checksum wrong.i check the source code,but not found any hints. 3,L2Server    --->this one for HB client?im not sure...   so my question is what are the differences between these three versions of cliext.dll?how can i fix the issue of the MD5Checksum not matching problem?   01/29/2026 21:04:11.366, [CCliExt::HandleCheckSum] Invalid Checksum[1130415144] vs [-721420287] packet[dd] len[29] sum[2698] key[30] HWID[] Account[]! 01/29/2026 21:04:11.366, SocketLimiter::UserSocketBadunknownprotocol 11111111111 01/29/2026 21:04:11.366, [usersocket]unknown protocol from ip[113.137.149.115]!      

  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..