[SOLVED] rAthena to Hercules

[Brynner 34]

i already applied all the upgrade patch.

 

but still having an error on creating character.

 

 

: DB error - Field 'char_opt' doesn't have a default value

[Debug]: at d:hercules  - high ratesrccharchar.c:1584 - INSERT INTO `char` (

`account_id`, `char_num`, `name`, `zeny`, `status_point`,`str`, `agi`, `vit`, `i

nt`, `dex`, `luk`, `max_hp`, `hp`,`max_sp`, `sp`, `hair`, `hair_color`, `last_ma

p`, `last_x`, `last_y`, `save_map`, `save_x`, `save_y`) VALUES ('2000103', '2',

'jonathanpervs', '0',  '48','1', '1', '1', '1', '1', '1', '40', '40','11', '11',

'1', '0', 'new_1-1', '53', '111', 'new_1-1', '53', '111')

[Brynner 34]

char_opt` INT( 11 ) unsigned NOT NULL default '0'

 

i edit my main sql and i add this default '0' to make it work.

[jaBote 438]

You should adapt your databases. I'm right now in a hurry (Get to go to classes, but you can try this which seems it works. Run this onyour main Ragnarok folder AFTER making a backup:

 

---- Table structure for table `sql_updates`--CREATE TABLE IF NOT EXISTS `sql_updates` (  `timestamp` int(11) unsigned NOT NULL,  `ignored` enum('Yes','No') NOT NULL DEFAULT 'No',  PRIMARY KEY (`timestamp`)) ENGINE=MyISAM;-- Existent updates to enterINSERT INTO `sql_updates` (`timestamp`) VALUES (1360858500);INSERT INTO `sql_updates` (`timestamp`) VALUES (1360951560);INSERT INTO `sql_updates` (`timestamp`) VALUES (1362445531);INSERT INTO `sql_updates` (`timestamp`) VALUES (1362528000);INSERT INTO `sql_updates` (`timestamp`) VALUES (1362794218);INSERT INTO `sql_updates` (`timestamp`) VALUES (1364409316);---- Table differences for table `char`-- ALTER TABLE `char` CHANGE `moves` `slotchange` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT '0',ADD `char_opt` INT( 11 ) unsigned NOT NULL default '0';

 

Databases have changed slightly, and so what I made on this other post shouldn't work. Try this one. In case it doesn't work I'll try and amend it later, but seems to work.

[Brynner 34]

i tried that and there is no problem regarding on sql. but when i try to make a character. character denied? i try to edit it manually and it woks now.