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

    • Constellation
      JewStor Service ➤ Verified Accounts, Drop Service etc.

      By Constellation · Posted

      Inventory restock: Premium business accounts are now available.   ✔ Wallester Business EU 🇪🇺|💳 Unlimited virtual cards, physical cards, 🏦 multi-currency IBAN, ₿ crypto & stablecoin deposits. ✔ Stripe Business UK 🇬🇧|💳 Instant virtual cards (Visa/Mastercard), high-conversion checkout, multi-currency payouts, ₿ crypto payments, no-code payment links. ✔ Mercury Business US 🇺🇸|🏦 US checking & savings, 💳 unlimited virtual cards, domestic & International wires, native stablecoin settlement. ✔ Payset Business EU 🇪🇺|🏦 Multiple IBANs, UK sort code, SEPA Instant, 💳 unlimited virtual cards, multi-currency accounts. ✔ Novo Business US 🇺🇸|🏦 Business checking account, ACH payments & invoicing, 💳 virtual & physical cards, novo boost.
    • THEFINK
      🧵 [FREE RELEASE] L2Updater + AntiCheat + Build System + Ful

      By THEFINK · Posted

      Let me see if I understand correctly, older gentlemen, when a newcomer shows up to create modern things with the help of AI, doing what you charge them to do, you point the finger and laugh. I believe that's why everything is stagnant. The product isn't for programming experts, it's for newcomers. Don't buy from you if they can do it themselves using this base. You're going to deliver a similar product, maybe even worse than this one, so why are you complaining? PowerShell, as you well know, started with it, then came new platforms and new apps, new creation models, all with different languages; I chose the simplest one for my taste. This is about being organized and knowing how to choose the right words for each situation. It's not 100%, but it already gives a good impression. Nothing is 100%, so a topic written by AI, and all the code that you charge an absurd amount for to prohibit and sell hacks, could be open source so that everyone can create new practices, new models, new information for passing packets, prohibiting the use of cheats that cause server owners to break so much. Let's remember that the Admin doesn't always shut down the server; it's the players who find problems and take advantage by buying and reselling items, and they say that the GM shuts down the server every week, but that's a lie. What they do is duplicate items with packages and sell them, but perhaps this could give some future developers a starting point to create their own protection following the model in the initial documentation. Because none of you answer a question from a newbie, you think you're superior because you have knowledge, but with AI, people like that can have the same knowledge as you, but with less practice. And if they practice a lot, 10,000 hours, they can be as good as all of you older developers in the L2J field.
    • 911reg
      🧵 [FREE RELEASE] L2Updater + AntiCheat + Build System + Ful

      By 911reg · Posted

      even the fucking post is AI, insane
    • BoostLike
      Boost-Like Store>GitHub Services: Followers, Stars, Forks

      By BoostLike · Posted

      ✨ Exclusive Offer for Marketplace Growth 🔥 Elevate your performance with a premium bonus. 💲 Top up your balance with $100 or more and receive an additional $5 credit — seamlessly added to your account. ⭐️ Designed for those who value efficiency, scale, and results. ⚡️ Effortless. Refined. Effective. 💥 Enhance your strategy today 💥
    • `Sanctus
      🧵 [FREE RELEASE] L2Updater + AntiCheat + Build System + Ful

      By `Sanctus · Posted

      Common AI Brazilian Slop

  • 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..