Minato
-
Posts
3 -
Joined
-
Last visited
Content Type
Profiles
Forums
Downloads
Jobs Available
Server Database
Third-Party Services
Top Guides
Store
Crowdfunding
Posts posted by Minato
-
-
Thank you very much you two. You have helped me a lot!
Do I understand correctly that the latest rAthena version now has this web service integrated?
Best regards.
-
SQLSTATE[42S02]: Base table or view not found: 1146 Table '***_db.guild_emblems' doesn't exist
in Web Support
Posted · Edited by Minato
Bugs :(
It's strange...
I was able to install the web service, emblems are uploaded and the ERROR message has disappeared.
But nothing is displayed in Ranking, Who's Online, Guilds, Item DB, Monster DB.
I have installed the latest FluxCP version. I guess no information can be read out?
Ranking says:
There are no characters.
Who's Online says:
No characters found. (But I am online with an account that has normal player privileges).
ItemsDB says:
No items found. (But I have imported the necessary .sql files).
MonsterDB:
No monsters found. (Again, the .sql files have been imported).
The Servers.php is set to 'Renewal' => true
Unfortunately, I am a bit at a loss at the moment. ^^"
------------
Edit:
Okay I could now fix some problems thanks to this PR. ( https://github.com/rathena/FluxCP/pull/275 ) Unfortunately, the database is not output correctly. A search field appears, but it is not possible to search for items. Also no list with items appears.
When I search for monsters in the MonsterDB, no drops are listed.
Edit 2:
Fixed my problem by making the following change in "\modules\item\index.php"
if($server->isRenewal) {
$fromTables = array("{$server->charMapDatabase}.item_db_re_compat", "{$server->charMapDatabase}.item_db2_re_compat");
} else {
$fromTables = array("{$server->charMapDatabase}.item_db", "{$server->charMapDatabase}.item_db2");
}
changed to
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");
}