issue at charserv

[hendra814]

i'm need help, i helping my friend setup his local rathena server.

when run the server showing error like this

Already tried reimport main.sql but still show the error, even already tried with remove char and login table.

What should i do to fix this issue?

 

Found bonus-script table in the database, but when i tried remove it

it's show error like this

Edited April 28, 2023 by hendra814
update

[hendra814]

On 4/28/2023 at 2:11 PM, hendra814 said:

i'm need help, i helping my friend setup his local rathena server.

when run the server showing error like this

Already tried reimport main.sql but still show the error, even already tried with remove char and login table.

What should i do to fix this issue?

 

Found bonus-script table in the database, but when i tried remove it

it's show error like this

solve using this sql script

IF DROP TABLE EXISTS `bonus_script`;
CREATE TABLE IF NOT EXISTS `bonus_script` (
  `char_id` INT(11) UNSIGNED NOT NULL,
  `script` TEXT NOT NULL,
  `tick` BIGINT(20) NOT NULL DEFAULT '0',
  `flag` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
  `icon` SMALLINT(3) NOT NULL DEFAULT '-1',
  KEY `char_id` (`char_id`)
) ENGINE=InnoDB;

 

Edited November 24, 2023 by hendra814

[hendra814]

curently solve by create new database and setup inter_atchena to read new database.