Heya. I'm having issues with the LiveMap since yesterday, it doesn't display the claims anymore nor does it display the menu on the right side. Maybe someone can help me out ?

Link to map : https://livemap.feudal.tools/id/6219

I can see the online players, weather and time, but that's pretty much all there is. Thanks in advance for any answer.
(If I disable it, will I be able to "reinstall" it afterwords?)

I think you have set your livemap to use a different yo database than your actual server is running on.
character table is empty and admin_lands table does not even match the layout of the current game version...

The server is hosted a pingperfect, there's just one database. I think I must have messed something with admin_lands and most likely that's what's causing the problem. I don't know how to solve the issue and I can't find a backup, so guess I will just leave it like it is and try to not ruin it further. Thanks.
Edit : I will try to shutdown the server when is empty and try to see if that "Repair database" function from game panel does the trick.

Sadly I was unable to resolve my issue, tried getting support from the server's host but no luck there either.

I was wondering if maybe someone could provide me with the basic admin_land sql part to upload and replace the files that I might have broken, that would be of great help and much appreciated... I got no other way to resolve the issue.

That's not going to help you. As I already pointed out, the database linked with your server/livemap on FeuadlTools isn't from a valid or running YO server.

Chris wrote: 03 Jun 2020, 11:43 That's not going to help you. As I already pointed out, the database linked with your server/livemap on FeuadlTools isn't from a valid or running YO server.

The SQL info/connection details are correct, I am able to see that FeudalTools is connected to the database and also I am able to login with HeidiSql and MySQL Workbench and I can see the character list and all the other files, I am able to export the files as well.

As you can see below both HeidiSql and the livemap are connected to the same database. I strongly believe that I've messed something on admin_lands that shows you a different story, like I said I got no clue how SQL works but I suspect the data LiveMap pulls from server database that is somewhat connected to the admin_lands files I've messed, the LiveMap worked flawlessly for over a week using the exact same database information, and I believe it stopped working once I've messed with the admin_lands files for which I've created no backup and got no way to restore the original files. I hope I understood your reply correctly and that this explains the issue @Chris, thanks for being so patient with me.

you are correct. my apologies.

please delete the admin_lands table and then run this query.
here's the admin_lands definition that you can run to create it.

Chris wrote: 04 Jun 2020, 19:15 you are correct. my apologies.

please delete the admin_lands table and then run this query.
here's the admin_lands definition that you can run to create it.

Code: Select all

CREATE TABLE `admin_lands` (
  `ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `Name` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
  `GeoID1` INT UNSIGNED NOT NULL,
  `GeoID2` INT UNSIGNED NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Worked like a charm, thanks a lot Chris, you are my hero. Map is working great once again.