Jump to content
  • 0

[HELP!]SQL Error


Question

Posted

Hey, I got a pretty stupid problem...

 

I added an extra column to the "characters" table (for an X purpose....) and now

im getting an error that it loads only 54 values for the character while I have added 55 which results in

the character being unable to be created so he spawns in the middle of a lake with 0 HP and totally frozen...

 

How do I fix this? ;/

4 answers to this question

Recommended Posts

  • 0
Posted

Remove the column, and learn how to add it properly if you don't know what to do with.

 

Check how others mods add columns in characters table (their core support...).

 

It's only related to L2PcInstance, and adding a column without core support will end to frozen character. It's not Mickey Mouse paradise.

  • 0
Posted

I'm trying to add the faction engine by Stefoulis15 and I've added EVERYTHING there is to add,

that's why I'm confused ;/

 

thanks for your help, if you have any suggestions pls let me know...

  • 0
Posted

Check CAREFULLY those variables (L2PcInstance):

 

UPDATE_CHARACTER

RESTORE_CHARACTER

 

Count numbers of columns and of ",?" if necessary.

 

Than check where those 2 variables are used. Basically, you have to add things here too. On IL, it's storeCharBase() && restore(int objectId)

 

Give full error aswell to analyze it.

 

More and less, use Laikeriz faction engine, it's far more advanced.

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


  • Posts

    • Hello everyone, we are one of the top gaming currency stores. We work exclusively with top projects. If you are interested in anything like Adena, Coins, Equip, write to us Discord - pchelacoin Telegram - https://t.me/ipchelacoin BOHPTS, KETRAWARS, EURO-PVP, L2REBORN, E-GLOBAL, LA2DREAM TOP PRICE !!!!!!!
    • L2Elixir – Patch 4 Is Live!   We’re working non-stop, day and night, to deliver the best possible quality and bring back what made L2Elixir special. This project is built with passion, not shortcuts — for the old-school players who remember, and the new ones who want to experience it properly. Thank you for being part of the journey. Together, we’re making L2Elixir great again ❤️ The legends never fade.    ⚙️ General Enabled Class Change service (same class type only) ALT + B → Services → Character Development Enabled Shift + Click on Treasure Chests Players can now identify real chests (Adena, scroll drops) and use Key / Unlock Event deaths now cancel only debuffs, All self buffs are preserved, fixes issues with Root and similar effects Bladedancer class can now log in even when Max Clients (2) is reached. Since an active Bladedancer is not available for every damage dealer and some players tried to abuse this via VPN or a second PC, this feature was added to keep things fair. protections applies, requires testing!    🎒 Items Crystallizing enchanted items now gives the correct increased crystal amount (retail-like behavior) Removed Agathion Seal Bracelet: Rudolph from Santa rewards (Gracia Final item) Added Dualsword Craft Stamp into Milestone Exchange list    🧙 Skills Fixed Banish Undead lethal chance Hot Springs Malaria and similar effects now level up faster while being attacked
    • thats new SEO level tricks you know nothing of noob - bottom line: exposed.
    • Warning: This guy is a big scammer, trying to sell everything, advertising for servers etc. That's his mail address evgesha.nrnr@gmail.com , stay away!   @Atom @Celestine
  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock