Jump to content

Recommended Posts

Posted

ok..ive got it...no i have another problem..when i relog, i lose my buffs..this is what CacheD say:

 

 

6/16/2017 17: 20: 22.625, Error sql: SELECT augmentation, ST_hair_deco, effective_mana0, effective_mana1, effective_mana2, effective_mana3 FROM user_data where char_id = 30 (0)
06/16/2017 17: 20: 22.625, Error 42S22: [Microsoft] [ODBC SQL Server Driver]

 Invalid column name 'augmentation'.
06/16/2017 17: 20: 27.269, Error sql: select [augmentation], [mana_left], [life_time] from [user_item] where [item_id] = 57 (0)
06/16/2017 17: 20: 27.269, Error 42S22: [Microsoft] [ODBC SQL Server Driver] [sql Server] Invalid column name 'augmentation'.
06/16/2017 17: 20: 27,270, Error sql: select [augmentation], [mana_left], [life_time] from [user_item] where [item_id] = 58 (0)
06/16/2017 17: 20: 27,270, Error 42S22: [Microsoft] [ODBC SQL Server Driver] [sql Server] Invalid column name 'augmentation'.
06/16/2017 17: 20: 27.271, Error sql: select [augmentation], [mana_left], [life_time] from [user_item] where [item_id] = 59 (0)
06/16/2017 17: 20: 27.271, Error 42S22: [Microsoft] [ODBC SQL Server Driver] [sql Server] Invalid column name 'augmentation'.
06/16/2017 17: 20: 27,271, Error sql: select [augmentation], [mana_left], [life_time] from [user_item] where [item_id] = 60 (0)
06/16/2017 17: 20: 27.271, Error 42S22: [Microsoft] [ODBC SQL Server Driver] [sql Server] Invalid column name 'augmentation'.
06/16/2017 17: 20: 27.272, Error sql: select [augmentation], [mana_left], [life_time] from [user_item] where [item_id] = 61 (0)
06/16/2017 17: 20: 27.272, Error 42S22: [Microsoft] [ODBC SQL Server Driver] [sql Server] Invalid column name 'augmentation'.
06/16/2017 17:20:27,274, Error sql: EXEC lin_GetActiveSkills 30 (0)
[sql] The stored procedure 'lin_GetActiveSkills' was not found.
(B3), [b4], [b5], [b6], [b7], [b8] , [b15], [b16], [b17], [b18], [b19], [b20], [b9], [b10] B31], [b24], [b25], [b26], [b27], [b28], [b29], [b30], [b31], [b32], [b33], [ , [b34], [b35], [b36], [b35], [b38] FROM [buffList] WHERE char_id = 30 AND summon = 1 AND subjob_idx = 0 (0)
06/16/2017 17: 20: 27.274, Error 42S02: [Microsoft] [ODBC SQL Server Driver] [sql Server] Invalid object name 'BuffList'.
06/16/2017 17: 20: 27.274, Error sql: SELECT aio_data FROM user_data WHERE char_id = 30 (0)
06/16/2017 17: 20: 27.274, Error 42S22: [Microsoft] [ODBC SQL Server Driver] [sql Server] Invalid column name 'aio_data'.
(B2), [b3], [b4], [b5], [b6], [b7], [b8] , [b15], [b16], [b17], [b18], [b19], [b20], [b9], [b10] B31], [b24], [b25], [b26], [b27], [b28], [b29], [b30], [b31], [b32], [b33], [ , [b34], [b35], [b36], [b37], [b38], [bL] WHERE char_id = 30 AND summon = 0 AND subjob_idx = 0 (0)
06/16/2017 17: 20: 27.275, Error 42S02: [Microsoft] [ODBC SQL Server Driver] [sql Server] Invalid object name 'BuffList'.

 

ive tryed every sql file i have but i always get this error

Pleas Help me

Posted

ok..ive got it...no i have another problem..when i relog, i lose my buffs..this is what CacheD say:

 

 

ive tryed every sql file i have but i always get this error

Pleas Help me

Broken database. One from this packs include correct one. I don't remember which one ;(.

Read logs, search for broken names in sql files shipped with packs, make new query (copy & paste missing objects)

Posted

Oh damn, i have been a bit away guys sorry.

Have you sorted your issue out ? If not drop me a message with your skype and i can attempt to sort it out.

Posted

Oh damn, i have been a bit away guys sorry.

Have you sorted your issue out ? If not drop me a message with your skype and i can attempt to sort it out.

i still wait xD

  • 2 weeks later...
  • 3 weeks later...
Posted

Hi Outlaw, fantastic thread mate.. Keep up the great work.

 

I don't suppose you could advise on what High Five server files I would need, and if there are any packs available.

 

I've been out of the server side a few years but feel like getting back into it again :)

 

Also there is no good tutorials out there, your knowledge would be an asset in either YouTube, or text based version... Just a thought :)

  • 2 weeks later...
Posted

Hi can you please fix the links some of them seems to be broken (example the first one) :) 

Do you or anyone else here have l2server_l2off_gracia_final_83 files? Thanks

Posted

seems alll links broken...

Author of topic, Outlaw is banned from forum, dunno why.  He seems for me as a nice man. He helped me a lot on PM with all my noob questions.

I really want to know reason behind the ban....

Guest
This topic is now closed to further replies.



  • Posts

    • Only 3 days left and we'll start with some events, you can check our Discord for more info!
    • Tired of frantically switching between windows trying to find that specific Warlock who should be casting saves? Forgot which server you left your Warsmith on? This mod solves these problems! What it does: Turns the boring window title into an information panel: Server Name - Character Name [Class] Real-life examples: - ServerName - HardcoreFarm [Spoilerr] (who's been spoiling for 3 months already) - ServerName - ClericHelper [Buffer] (eternal buffer on standby) - ServerName - MainChar [Gladiator] (main character who's always AFK) Why you need this: For multiboxers - to avoid confusing where the DD is and where the healer is For the forgetful - if your memory is like a goldfish For streamers - viewers immediately see who's on screen For adults - when playing at work and need to quickly hide the window DLL only - no Interface files needed Installation (more complicated than making tea): 1. Download the DLL 2. Drop it into the System folder 3. Launch the client 4. Be amazed how you lived without this before! Purchase Conditions: Price: 100$ Payment Method: USDT. How to Buy: Contact me on Telegram: @kiselevwv for a quick response. I will answer all your questions and provide additional information if needed. I guarantee functionality at the moment of sale and prompt assistance with setup after purchase.
    • I agree, l2damage crap to compare to l2java which was the father of pvp servers and till this days people playing there for good time.
    • 📝 Registration — Account Registration Creating a new player account. Usually includes: login password password confirmation email Result: a new record is created in the accounts table (loginserver). 🔑 Change Password — Password Change The player changes the password knowing the current one. Required: current password new password new password confirmation Result: the password field is updated in the accounts table. ♻️ Password Recovery — Password Reset If the player forgot the password. Implementation only via email: the player enters their login, email the system sends an email with a link or code the player opens the link / enters the code sets a new password Result: the password is updated in the accounts table.   All fields are validated (required, format, length, uniqueness, security checks).   Price: 80$   and i can rewrite script for PTS server.   Contacts:   Telegram Discord
  • 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..