Ninjininja

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.

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...

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