Jump to content
  • 0

L2-Scripts Lindvior Error Column 'account_Name' Cannot Be Null


Question

Posted

Upload please database backup.

I install db and give this error in GS after character creating  :(

ERROR com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'account_name' cannot be null

8 answers to this question

Recommended Posts

  • 0
Posted (edited)
Column 'account_name' cannot be null

This means that you can't left the column account_name empty.

The reasons can be more then 1 this error to appear but here i will give you few clues:

1: Or source problem and doesn't fill correctly database.

2: Incorrect installed database.

3: Wrong edited database column.

And so on...

 

Does this error occurs before you restore the backup from your database?

Or when it start occurs....

Edited by Stewie
  • 0
Posted
Column 'account_name' cannot be null

This means that you can't left the column account_name empty.

The reasons can be more then 1 this error to appear but here i will give you few clues:

1: Or source problem and doesn't fill correctly database.

2: Incorrect installed database.

3: Wrong edited database column.

And so on...

 

Does this error occurs before you restore the backup from your database?

Or when it start occurs....

 

i think is something from source something code is wrong..you have change something from database tables? or you have add any code before this error?

  • 0
Posted (edited)

 

Upload please database backup.

I install db and give this error in GS after character creating  :(

ERROR com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'account_name' cannot be null

i think is something from source something code is wrong..you have change something from database tables? or you have add any code before this error? source work normal and after you change something you got this error? explain better for your problem

Edited by nikosdevil20
  • 0
Posted

i have same problem. character table in db is ok i think. same like in others

man you have clean pack? you use preconf pack? you add new codes in your pack? when show this error? you change something and after show you this error? explain for understund from where is the problem im not in your pc for help you

  • 0
Posted

because in this pack are 2 different databases to install login and game are in different DBs u should open login.bat (file witch install .sql tables and change) and change DB and same step do with game.bat and i say again not starting script .bat but install script witch installing .sql tables to DB :)

 

(sry for my english :/ )

  • 0
Posted (edited)

because in this pack are 2 different databases to install login and game are in different DBs u should open login.bat (file witch install .sql tables and change) and change DB and same step do with game.bat and i say again not starting script .bat but install script witch installing .sql tables to DB :)

 

(sry for my english :/ )

i have 2 different databases. login separate with game server. db was install correctly. if i change account_name value on "can be null" character create correctly but i must set account to character  manually in database

Edited by karolczuk
Guest
This topic is now closed to further replies.


  • Posts

    • Hey MaxCheaters! 👋 Introducing L2Soon.com — a free international platform for Lineage 2 server announcements.   Why L2Soon? No more searching through dozens of forums and Discord servers. All new L2 server openings are in one place — updated daily, with real player online counts so you always know where people actually play.   Features: 🔔 Telegram Bot (@l2Soon_bot) — alerts 24h & 1h before server launch 📅 Accurate launch times — in your local timezone ⚔️ All chronicles — Interlude, High Five, GoD, Classic, Essence, Grand Crusade and more 🎯 Filters — by chronicle, rates (x1–x1000+) and server type (PvP, RvR, GvE, Craft, Low Rate...) ⭐ VIP servers — verified projects pinned at the top 🌍 Multi-language — EN, UK, RU, PT   Listing is completely FREE. 🔗 https://l2soon.com/en Feedback welcome — drop a comment or contact us via Telegram @l2Soon_bot
    • Download Lobby u need island for lobby Download Crow Island  
    • Website: https://l2elixir.org/ Discord: https://discord.gg/5ydPHvhbxs    
    • L2-LORENA x100 MID RATE   Interlude Nostalgia Meets Modern Gameplay   OFFICIAL OPENING:  April 4 (Saturday)  19:00 UTC+1 ⸻  MAIN INFORMATION  Adena: x5  Drop: x10  Spoil: x10  Raid Boss: x10  Seal Stones: x2  Quests: x10 ⸻  FEATURES  GM Shop up to B-Grade  Full Buffer  Premium System (x2 bonuses)  AutoFarm – FREE for everyone ⸻  SERVER CONCEPT  Classic Interlude nostalgia  Enhanced with modern interface & mechanics  Balanced PvP & PvE gameplay  Active development & custom features ⸻  WHY JOIN L2-LORENA?  No Pay-to-Win  Smooth gameplay & stable server  Competitive PvP environment  Friendly & active community ⸻  JOIN US NOW L2-LORENA 100X <<< LINK Discord: https://discord.gg/TYZ88Tgx4b  Facebook: https://www.facebook.com/share/18kwbkaYZY/?mibextid=wwXIfr   L2-LORENA Link << Discord: https://discord.gg/TYZ88Tgx4b  Facebook: https://www.facebook.com/share/18kwbkaYZY/?mibextid=wwXIfr
  • 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..