Exaxxion

Doing as you say, when I set `use_sql_db: no`, it loads up without that crazy amount of errors. While I can tell it not to use the database, wasn't the whole point of that part of the setup guide to make it use the database? Why have an entire guide instructing you to install, configure, and populate a MySQL database if, without telling you this anywhere, it doesn't even work and you have to use the flat files? Is there really no way to successfully use the database? I remember database functionality existing like 20 years ago.

Hello, yes, in `conf/import/inter_conf.txt` I do have `use_sql_db: yes` to override the default because the setup guide said I should enable it, and another guide recommended I do that in the import .txt files rather than in the original files to avoid merge conflicts when pulling future changes. When loading the server with `athena_start` the logs are interleaved so I can't distinguish which process the messages are coming from, but I do see this in the output: [Status]: Using SQL dbs: no [Status]: Using SQL dbs: yes Which I'm not sure if it's an indicator of a problem or if it's just saying that it's switching from not using SQL to using SQL. Right after the above messages are these messages, which seem to indicate that at least some things are in fact using the SQL database, and I can see in MySQL that there are entries in things like the login tables. [Info]: Logging item transactions to table 'picklog'. [Info]: Logging commands to table 'atcommandlog'. [Info]: Logging 'logmes' messages to table 'npclog'. [Info]: Logging Cash transactions to table 'cashlog'. [Info]: Logging Feeding items to table 'feedinglog'. WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. [Info]: Connecting to the Map DB Server.... [Status]: Connect success! (Map Server Connection) WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. [Info]: [SQL]: Connecting to the Log Database ragnarok At 127.0.0.1... [Status]: [SQL]: Successfully 'connected' to Database 'ragnarok'.

Hello, I am attempting to run an rAthena server but encountering some strange things I'm not sure how to fix even after searching through the forums and GitHub. I remember using eAthena forever ago and am no stranger to compiling from source or managing databases, so I figured I should be able to get this set up well enough. I compiled rAthena with hash b928e52398b79e55f6d98d752102d02cc11c2808 and to the best of my understanding it defaults to RE, and I specified to use packet version 20220406 when configuring as I am using the Froggo Test Client from this forum and that was recommended (I could not get WARP to do anything but scream errors at me when I tried to enable any of the patches, so I gave up on hexing my own kRO client). I configured MySQL and imported all of the core database scripts and compat scripts. I have set in the config/import directory that the server should use the SQL database. I have not added any custom content whatsoever. When I launch the server I have a mile-long list of errors of the following form: [Error]: sv_readdb: Could not process contents of line 70 of "db/re/item_noequip.txt". [Warning]: itemdb_read_noequip: Invalid item id 1329. [Error]: sv_readdb: Could not process contents of line 71 of "db/re/item_noequip.txt". [Warning]: itemdb_read_noequip: Invalid item id 28751. [Error]: sv_readdb: Could not process contents of line 72 of "db/re/item_noequip.txt". [Warning]: itemdb_read_noequip: Invalid item id 32103. [Error]: sv_readdb: Could not process contents of line 73 of "db/re/item_noequip.txt". [Warning]: itemdb_read_noequip: Invalid item id 26210. [Error]: sv_readdb: Could not process contents of line 74 of "db/re/item_noequip.txt". [Warning]: itemdb_read_noequip: Invalid item id 26019. [Error]: sv_readdb: Could not process contents of line 75 of "db/re/item_noequip.txt". [Warning]: itemdb_read_noequip: Invalid item id 16085. [Error]: sv_readdb: Could not process contents of line 76 of "db/re/item_noequip.txt". [Warning]: itemdb_read_noequip: Invalid item id 26147. [Error]: sv_readdb: Could not process contents of line 77 of "db/re/item_noequip.txt". [Warning]: itemdb_read_noequip: Invalid item id 28036. [Error]: sv_readdb: Could not process contents of line 78 of "db/re/item_noequip.txt". <skipping hundreds of lines...> [Warning]: itemdb_read_noequip: Invalid item id 470013. [Error]: sv_readdb: Could not process contents of line 318 of "db/re/item_noequip.txt". followed by more errors: [Error]: Unknown Item Costume_Exchange. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 109 and column 12. [Error]: Unknown Item C_Wing_Of_Fly_1Day_Box. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 123 and column 12. [Error]: Unknown Item E_Str_Dish_Box. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 853 and column 12. [Error]: Unknown Item E_Agi_Dish_Box. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 856 and column 12. [Error]: Unknown Item E_Int_Dish_Box. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 859 and column 12. [Error]: Unknown Item E_Dex_Dish_Box. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 862 and column 12. [Error]: Unknown Item E_Luk_Dish_Box. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 865 and column 12. [Error]: Unknown Item E_Vit_Dish_Box. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 868 and column 12. [Error]: Unknown Item E_Blessing_10_Scr_Box. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 871 and column 12. [Error]: Unknown Item E_Inc_Agi_10_Scr_Box. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 874 and column 12. [Error]: Unknown Item Butterfly_Hairpin. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 1677 and column 12. [Error]: Unknown Item Capricon_Diadem_Box. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 5783 and column 12. [Error]: Unknown Item Capricon_Crown_Box. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 5858 and column 12. [Error]: Unknown Item OminousSolider_Card. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 7380 and column 12. [Error]: Unknown Item OminousPermeter_Card. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 7383 and column 12. [Error]: Unknown Item OminousHeater_Card. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 7386 and column 12. [Error]: Unknown Item OminousAssulter_Card. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 7389 and column 12. [Error]: Unknown Item OminousFreezer_Card. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 7392 and column 12. [Error]: Unknown Item Colorful_T_Bear_Card. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 7536 and column 12. <...skipping hundreds of the same type of errors> [Error]: Unknown Item Premium_Box. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 114131 and column 12. [Error]: Unknown Item EXP_Drop_Up_7days. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 114134 and column 12. [Error]: Unknown Item K_Secret_Key. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 114143 and column 12. [Error]: Unknown Item CLB_SS_Box. [Error]: Occurred in file 'db/re/item_group_db.yml' on line 114146 and column 12. [Status]: Done reading '2631' entries in 'db/re/item_group_db.yml' This massive amount of errors repeats for several more YML files, which I don't really understand why it's using when I have all the databases in MySQL and the logs indicate a successful connection to said database. The server however does finish loading in spite of this and it seems mostly playable? I can load in game but various things don't seem to work properly, I teleported into some kind of event dungeon and had to warp out because none of the enemies actually spawned and was basically softlocked in the instance. Vendors also don't seem to sell certain items that RO guides tell me should exist. For example a tool merchant isn't selling Empty Bottles which you need for things like making Apple Juice to feed the baby poring you tame in one of the newbie quests. Porings are supposed to drop Empty Bottles, and I can see in MySQL in the mob_db table that Poring should drop Jellopy, Knife, Sticky Mucus, Apple, Empty Bottle, Unripe Apple, and Poring Card. However, when I use `@mi 1002` in game, it tells me that Porings drop Jellopy, Knife, Sticky Mucus, Apple, Fly Wing, Apple, Unripe Apple, and Poring Card. When I use `@whodrops Empty Bottle` it shows a variety of matching Empty Bottle and boxes of Empty Bottle items, but zero monsters that drop any of those items. Thus it seems like rAthena is ignoring my populated databases and trying (and failing tremendously) to load information from flat-files. I have tried my best to follow the guides for compiling and configuring the database and server but I am stumped on this particular issue. I would very much appreciate any advice.