Skip to content

[Help]Cant Create char

Featured Replies

I put this thing in my pack http://www.maxcheaters.com/forum/index.php?topic=35122.0 [interlude client]

and when i try to create a char i get this error on GC

Could not insert char data: java.sql.SQLException: Column count doesn't match value count at row 1

pack is l2jserver :x

 

How Can i fix this error?

ALTER TABLE `characters` ADD `donator` decimal(1,0) NOT NULL DEFAULT 0;

ALTER TABLE `characters` ADD `hero` decimal(1,0) NOT NULL DEFAULT 0;

ALTER TABLE `characters` ADD `donator` decimal(1,0) NOT NULL DEFAULT 0;

ALTER TABLE `characters` ADD `hero` decimal(1,0) NOT NULL DEFAULT 0;

 

If that was the case the error would be unknown column "donator" bla bla. His statement is missing columns aka statement_columns < table_columns usually. But im not sure.

If that was the case the error would be unknown column "donator" bla bla. His statement is missing columns aka statement_columns < table_columns usually. But im not sure.

Yes he is missing some columns, which MIGHT be the "hero" and "donator" like xAddytzu said. It would be easier to determine if the author at least posted the structure of characters' table.

I dont mean they are missing in the db, but in the statement.

Yeah, you may be right actually. So the whole INSERT query and the table structure would tell what's the problem :)

Create an account or sign in to comment

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.