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'll give you my wallet if you want, haha
    • To make up for some of the waiting time we’re hosting a 3v3 Tournament on open Beta, and this time we’re raising the stakes with a $1,300 prize pool 💰   🏆 PRIZE POOL BREAKDOWN (Over 2000$ Worth of prices total)   🥇 1st Place — $700 🥈 2nd Place —$300 🥉 3rd Place — $200 🏅 4th Place — $100  5th -6th Place - $100 in Gold Coins each    All Participating Teams: $50 in Gold!   All Prices will be Paid out instantly after the tour, no waiting time and conditions. This is not simply a marketing move, we want to give back to the community.   📅 Date: Wednesday 06.05.2026 ⏰ Time: 20:00 Central European Timezone (Berlin) 📍Format: 3v3   ⚔️Why join? Cash Prices for top 4 and rewards for all participants Payments to winners sent out straight after the tournament - No waiting time or rules that you have to play live server to obtain the reward. Clean format, smooth matches, and solid prize pool and a chance to experience our brand new files   📝How to join: Form your 3-player team Group Leader Sign up here: ⁠📍・3v3-tour-registration (Include Name of Group, Name of Group Leader)   Be ready on match day!     A separate post with rules for the tournament and class setups will follow shortly.   Tag your teammates, lock in your roster, and get ready to compete. We'll be happy to see you on the OBT!   💬 Questions? Ask in ⁠🎫・ticket or send us a message   See you on L2Dark! 😏   Discord: https://discord.gg/FAJwnFpb8M
    • You should check if that condition is supported by your current sources. You can find this in  DocumentBase#parsePlayerCondition If it isnt there and you want to follow the same pattern of the other item conditions, create a custom condition to parse the classId (or multiple class ids) (there are examples to copy the code). Alternatively, you can create your own condition handler. Your condition should look like this: <cond msgId="1518"> <player classId="ADVENTURER,PALADIN" /> </cond> or <cond msgId="1518"> <player classId="93,5" /> </cond>  
    • it's Interlude client forgot to mention
    • idk if acis have this option, but you can put inside item smth like that atleast on H5         <cond msgId="1518">             <player class_id_restriction="93, 101, 108, 117" /> <!-- Dagger Masters -->         </cond>
  • 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..