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

    • I had friends who played on Elegant and I can confirm it wasn't a bad server. I don't know about the AI bots running around, but in my opinion the price is simply too high. I don't think many people will spend that much money on Lineage 2 files when alternatives like L2Scripts already exist.   Of course it's all about personal preference, but for such an old chronicle the price seems ridiculously expensive. Modern chronicles usually offer more value.   Anyway, I wish you the best of luck with the sale. This is just my personal opinion. Whoever likes it, good for them, and whoever doesn't, that's fine too. Everyone has different preferences.
    • https://l2avokado.com/ Hello everyone,   After some time of development, we've decided to open L2Avokado to the public in its current development stage. We're looking for players who enjoy Interlude and would like to help shape the project before its official release.   This isn't a "launch" announcement. Instead, we're inviting the community to log in, explore the server, test the systems we've built, and provide honest feedback. Whether it's bug reports, balance suggestions, progression ideas, or quality-of-life improvements, we'd love to hear them.   Our goal has always been to create an Interlude server that feels familiar while offering a fresh progression experience. We've intentionally avoided custom weapons, armor, and client modifications. Instead, we've focused on redesigning progression through reworked hunting grounds, quests, crafting, and gameplay systems while remaining compatible with a clean Interlude client.   At this stage, the core progression path has been implemented, including the main hunting grounds, quests, custom systems, and events. However, as the project is still under active development, there will inevitably be bugs, balance issues, and areas that require further polishing.   This is exactly why we'd like your help.   We're looking for players who are willing to: Test gameplay and progression. Report bugs and exploits. Suggest balance improvements. Share ideas for new features or quality-of-life changes. Help us build a server that the community genuinely enjoys playing.   The Client and System downloads are already available on our website, so you can jump straight into the game. We're also working on a dedicated launcher that will simplify installation and future updates.   If you're interested in helping develop a unique Interlude project and want your feedback to genuinely influence the direction of the server, we'd love to have you with us.   We look forward to seeing you in-game and hearing your thoughts on Discord. https://l2avokado.com/
    • Mate your server used to play with full of bots, from where you find that revenue? 
  • 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..