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

    • OpenCV bot working for all l2 clients... but need special set for each server
    • Use l2tower for free, or try adrenaline. @Alex K.
    • 🎁 Double the Impact, Half the Cost! from 25/10/2025 until 25/12/2025 Buy or Renew your Donation Panel now and save 50% because supporting others should reward you too. 💡 Use code BLACKFRIDAY at checkout! https://hopzone.eu/store/product/26-donate-panel-v5/   About Donate Panel v5 PAYMENT IN EASY 5 STEPS Login with your character name. Select the donation service (Paypal Stripe Payeer MercadoPago 🆕). Select the amount of payment. Pay. 😎 Automatically recieve the reward ingame (and yes) while he is online! 🤯 PAYMENT METHODS Paypal Stripe accepts credit cards, debit cards, ACH transfers, Apple Pay, Google Pay, Microsoft Pay, and various local payment methods from around the world. Payeer accepts BTC, LTC, ETH, DASH, BCH, USD, EUR, RUB wallets MercadoPago accepts ARS, BRL, CLP, MXN, COP, PEN, UYU. PROTECTION Full SSL website (can be forced by htaccess) XSS Protection just in case. Remove vulnerability headers in htaccess level Session Validation COOKIE, POST, GET global inputs are sanitized SQL Injection protection Query String protetion Prepared statements of PDO driver (no sql injection there) Google Invisible Captcha v3 (NEW) Last but not least security through obscurity SEO & PUBLIC MANAGEMENT SEO Friendly urls (in htaccess level) Google Analytics and GTAG Code ready. Terms of use ready to go Refund policy ready to go Contact All the TERMS text are showing config dynamic item images/text with server's name and more OPTIMIZATION AND SPEED Zip Content (faster load) Memory save (unloading global vars) Using CDN’s for bootstrap Scripts are loaded in footer Images are soft to max 10kb Small and smart organized code style FUNCTIONALITIES Multilanguage (4 languages so far) EN ES NL EL (Easy to add more) Payment methods Paypal, Stripe, Payeer and MercadoPago After payment or cancel the user is redirected back to “Thank you” page. TECHNOLOGIES Bootstrap 5x CSS PHP 5.6+ (for l2off) and PHP 7.4+ (for java) Extensions for php: MySQL (L2Java), pdo_dblib(L2OFF), pdo_sqlsrv(L2OFF), mssql_connect (L2OFF) and PDO Drivers that support MariaDB, MySQL, MsSQL. SYSTEMS Stripe and MercadoPago supports sandbox and live. Detailed and seperated Logs (ERROR, DEVELOPER, INFO, WARNING, PAYMENT) for website and Rest APIs. Detailed Log in database for Payments and services used. Google Analytics (You know when players are in the panel and if they pay) Google Captcha V3 Dynamic Icons to show according your Donate Item ID Multiple servers L2OFF or L2JAVA servers can be added together as server network     BE AWARE: Leaked versions of old v2 panels (year 2018 with bugs) are still out sold by scammers without support or knowledge of the files.
    • I work with Kenrix and he is a  next level coder. Hugely Recommended.
    • Follow our Telegram channel, because exciting events are coming very soon! Halloween, 11.11, and also a giveaway related to 3000 subscribers in our Telegram channel are ahead! What do you think we have prepared? Subscribe to our Telegram channel and stay updated on all the news: https://t.me/accsforyou_shop Active links to SOCNET stores: Digital goods store (Website): Go Telegram store bot: Go – convenient access to the store via Telegram messenger. Telegram Stars purchasing bot: Go – fast and profitable purchase of stars in Telegram. SMM Panel: Go – promotion of your social media accounts. We would like to introduce you to the current list of promotions and special offers for purchasing products and services of our platform: 1. Promo code OCTOBER2025 (8% discount) for purchases in our store (Website, Bot) in October! You can also use a promo code for the first purchase: SOCNET (15% discount) 2. Get $1 to your store balance or a 10–20% discount — just send your username after registering on our website using the following template: "SEND ME BONUS, MY USERNAME IS..." — you need to write it in our forum thread! 3. Get $1 for the first trial launch of the SMM Panel — just open a ticket with the topic “Get Trial Bonus” on our website (Support). 4. Weekly Telegram Stars giveaways in our Telegram channel and in our Stars purchasing bot! News: ➡ Telegram channel: https://t.me/accsforyou_shop ➡ WhatsApp channel: https://chat.whatsapp.com/K8rBy500nA73z27PxgaJUw?mode=ems_copy_t ➡ Discord server: https://discord.gg/y9AStFFsrh Contacts & Support: ➡ Telegram: https://t.me/socnet_support ➡ WhatsApp: https://wa.me/79051904467 ➡ Discord: socnet_support ➡ ✉ Email: solomonbog@socnet.store
  • 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