Error using sql

[Waldrich]

I have this error when I open my server, I'm trying to use SQL, when I activate this option a lot of errors appear and I don't know what to do, when I deactivate SQL the errors disappear. I need SQL to run. What can I do to use SQL normally and eliminate the errors?

Quote

 

[Racaae]

Hi. rAthena does not update database sql files everytime there's new entries. You need to do it yourself.
Open yaml2sql.exe in your server folder. It is used to convert yml files to sql files. Press Y to convert (and replace) the following files one by one:

db/re/item_db_usable.yml
db/re/item_db_equip.yml
db/re/item_db_etc.yml
db/re/mob_db.yml

Then import the four .sql files in /sql-files to your database.

 

 

[Waldrich]

9 hours ago, Racaae said:

Hi. rAthena does not update database sql files everytime there's new entries. You need to do it yourself.
Open yaml2sql.exe in your server folder. It is used to convert yml files to sql files. Press Y to convert (and replace) the following files one by one:

db/re/item_db_usable.yml
db/re/item_db_equip.yml
db/re/item_db_etc.yml
db/re/mob_db.yml

Then import the four .sql files in /sql-files to your database.

 

 

Hi, I did what you said, it solved several errors but gave me others, even because when importing db/re/mob_db.yml it generated the image error.

[hendra814]

1 hour ago, Waldrich said:

Hi, I did what you said, it solved several errors but gave me others, even because when importing db/re/mob_db.yml it generated the image error.

try import mob_db_re.sql first at sql-files folder

Edited August 15, 2024 by hendra814

[Waldrich]

57 minutes ago, hendra814 said:

try import mob_db_re.sql first at sql-files folder

Nothing has changed, it's still the same. 

[hendra814]

3 hours ago, Waldrich said:

Nothing has changed, it's still the same. 

i want to ask, why you import yml file into sql?

i think yml file not supported for import to sql

[Racaae]

16 hours ago, Waldrich said:

Hi, I did what you said, it solved several errors but gave me others, even because when importing db/re/mob_db.yml it generated the image error.

Run this in your database to fix the error in the image.

ALTER TABLE `mob_db`
	ADD COLUMN `racegroup_illusion_moonlight` tinyint(1) unsigned DEFAULT NULL
;
ALTER TABLE `mob_db2`
	ADD COLUMN `racegroup_illusion_moonlight` tinyint(1) unsigned DEFAULT NULL
;
ALTER TABLE `mob_db_re`
	ADD COLUMN `racegroup_illusion_moonlight` tinyint(1) unsigned DEFAULT NULL
;
ALTER TABLE `mob_db2_re`
	ADD COLUMN `racegroup_illusion_moonlight` tinyint(1) unsigned DEFAULT NULL
;

 

Make sure your database is up to date by importing the latest files in \sql-files\upgrades.

Edited August 15, 2024 by Racaae
typo fix

[Waldrich]

17 hours ago, hendra814 said:

i want to ask, why you import yml file into sql?

i think yml file not supported for import to sql

Sorry, I didn't import the yml, I imported the sql only.

6 hours ago, Racaae said:

Run this in your database to fix the error in the image.

ALTER TABLE `mob_db`
	ADD COLUMN `racegroup_illusion_moonlight` tinyint(1) unsigned DEFAULT NULL
;
ALTER TABLE `mob_db2`
	ADD COLUMN `racegroup_illusion_moonlight` tinyint(1) unsigned DEFAULT NULL
;
ALTER TABLE `mob_db_re`
	ADD COLUMN `racegroup_illusion_moonlight` tinyint(1) unsigned DEFAULT NULL
;
ALTER TABLE `mob_db2_re`
	ADD COLUMN `racegroup_illusion_moonlight` tinyint(1) unsigned DEFAULT NULL
;

 

Make sure your database is up to date by importing the latest files in \sql-files\upgrades.

I used sql from the upgrade folder, I used this code, and whenever I try to load mob_db_re.sql it still generates the error. I loaded all sql from 0 and it still persists.   

[hendra814]

1 hour ago, Waldrich said:

Sorry, I didn't import the yml, I imported the sql only.

I used sql from the upgrade folder, I used this code, and whenever I try to load mob_db_re.sql it still generates the error. I loaded all sql from 0 and it still persists.   

try drop your mob_db_re sql table and then reimport mob_db_re.sql file

[Waldrich]

22 hours ago, hendra814 said:

try drop your mob_db_re sql table and then reimport mob_db_re.sql file

I've done this several times and nothing has changed. Am I the only one having this problem?

[hendra814]

47 minutes ago, Waldrich said:

I've done this several times and nothing has changed. Am I the only one having this problem?

are the configuration for sql using this part?