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

    • Thanks for the collection and the free advertising! These files have been in the public domain for a long time — you just saved people the trouble of searching. A true fan. 😄 Just to clarify for everyone reading: these files have nothing to do with this topic. They are 10+ year old builds, and since various third-party modifications exist in the wild, we cannot guarantee what may have been added or changed in those versions. Use them at your own risk. We have absolutely no judgment toward those who are on a tight budget and can't afford our current builds — these old shared files might genuinely help you get started. Just use them carefully and at your own risk. And please don't judge developers for the mistakes they made early in their careers — every developer goes through stages of growth, and what you see in those old builds is simply a snapshot of where we were back then. We've come a long way since. If you're interested in our older builds, we have a dedicated thread for that with significantly reduced prices — very accessible for any budget. We have also recently resumed full technical support for legacy builds, handled by a separate team that doesn't interfere with our private development direction for larger projects. You can find our legacy builds here: Our OLd L2-scripts Packs Actual revisions Our current private sources are a completely different story — which is exactly what this thread is about. Too bad all your time goes into collecting other people's old code instead of developing your own project. Though judging by "L2MID is currently offline, we will come back soon in 2026" — you clearly have plenty of time on your hands. 😉
    • SHARED alreaxy! Are these files yours? https://fex.net/ru/s/kdop2z4
    • You asked for examples of coping projects, we provided them, you asked for feedback from our clients, some of them wrote their reviews on the same mmodev, what else can I prove to you? you just asked your friends from mmodev to write nasty things, they have never been our customers and never will be, because they are used to downloading only free products and hacking it. You just don't respect the work of others, this is the conclusion that can be drawn from your inflammatory topic on mmodev, where there are many people who once could not buy our assemblies or whom we kicked out of work or for some other reason. But you are completely wrong and you are behaving very lowly. But let it be on your conscience. Good luck, keep busy with your project, and don't interfere with others.
    • I will never use L2J as the basis for my project but what i saw in MMODEV was enough for me. GL    
  • 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..