[Conversion of Item Database to YAML]

Hmm... you might be overengineering the problem. Your error seems to state the solution to the problem you're having:

SQLSTATE: 42000, ERROR: 1055

this is incompatible with sql_mode=only_full_group_by

Isn't "SQLSTATE: 42000, ERROR: 1055" an access/permission error? Why do you have "sql_mode=only_full_group_by" enabled? Says it doesn't like that.

[Conversion of Item Database to YAML]

Well I'll be damned... that was EXACTLY it.

 

Go to modules\item and look for a file called index.php

You're going to look for something like this in that file (I used notepad):

 

try {

    if($server->isRenewal) {
        $fromTables = array("{$server->charMapDatabase}.item_db_re", "{$server->charMapDatabase}.item_db2_re");
    } else {
        $fromTables = array("{$server->charMapDatabase}.item_db", "{$server->charMapDatabase}.item_db2");
    }

I changed it to this and it worked:

 

    if($server->isRenewal) {
        $fromTables = array("{$server->charMapDatabase}.item_db_re_compat", "{$server->charMapDatabase}.item_db2_re_compat");
    } else {
        $fromTables = array("{$server->charMapDatabase}.item_db_compat", "{$server->charMapDatabase}.item_db2_compat");
    }

 

 *** EDIT 2 ***

You also gotta do the same for a file called view.php inside of: modules\character

Go to the following line:

 

if($server->isRenewal) {
    $fromTables = array("{$server->charMapDatabase}.item_db_re", "{$server->charMapDatabase}.item_db2_re");
    $mobdb = array("mob_db_re","mob_db2_re");
} else {
    $fromTables = array("{$server->charMapDatabase}.item_db", "{$server->charMapDatabase}.item_db2");

 

Then change it to:

 

if($server->isRenewal) {
    $fromTables = array("{$server->charMapDatabase}.item_db_re_compat", "{$server->charMapDatabase}.item_db2_re_compat");
    $mobdb = array("mob_db_re","mob_db2_re");
} else {
    $fromTables = array("{$server->charMapDatabase}.item_db_compat", "{$server->charMapDatabase}.item_db2_compat");

 

*** EDIT 3 ***

LoL... found another... view.php inside of: modules\item

Went to the following line:

 

if($server->isRenewal) {
    $fromTables = array("{$server->charMapDatabase}.item_db_re", "{$server->charMapDatabase}.item_db2_re");
    $mobdb = array("mob_db_re","mob_db2_re");
} else {
    $fromTables = array("{$server->charMapDatabase}.item_db", "{$server->charMapDatabase}.item_db2");
    $mobdb = array("mob_db","mob_db2");

 

And then changed it:
 

if($server->isRenewal) {
    $fromTables = array("{$server->charMapDatabase}.item_db_re_compat", "{$server->charMapDatabase}.item_db2_re_compat");
    $mobdb = array("mob_db_re","mob_db2_re");
} else {
    $fromTables = array("{$server->charMapDatabase}.item_db_compat", "{$server->charMapDatabase}.item_db2_compat");
    $mobdb = array("mob_db","mob_db2");

 

There's an obvious pattern here... so if you find a broken item link, just keep following the path...

[Conversion of Item Database to YAML]

On 1/22/2021 at 3:41 PM, Adimgar said:

Asking for a little help, i've loaded compatibility views in sql, but control panel still cannot read tiem_db (missing columns), what is the right support forum to ask for help on this?

Yea... I'm getting that same problem too.

NOT A COMPUTER PERSON, just a noob trying to figure it out as well, so take this with a grain of salt:

From what I can gather from Google and piece together from the rAthena documents, I think what those compatibility files did was take the item databases and create a "virtual" database that rearranges the tables in the order FluxCP wants them to be in (under Views). However, maybe a file in FluxCP itself needs to be changed? Seems that by default the program looks at (in my case) item_db_re and item_db2_re. However it now needs to look at (in my case) item_db_re_compat and item_db2_re_compat.

So I've been spending extra free time the last few days looking in the various php files and seeing if anything like that is in there.

Again: I'm doing a blind leading the blind thing here... so I'm probably completely wrong. But I figure trying is better than doing nothing, and maybe I'll stumble on the answer... or fall off the cliff. LoL