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?)
Re: LiveMap not working anymore.
2I 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...
character table is empty and admin_lands table does not even match the layout of the current game version...
Re: LiveMap not working anymore.
3The 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.
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.
Re: LiveMap not working anymore.
4Sadly 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.
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.
Re: LiveMap not working anymore.
5That'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.
Re: LiveMap not working anymore.
6The 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.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.
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.
Re: LiveMap not working anymore.
7you 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.
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;
Re: LiveMap not working anymore.
8Worked like a charm, thanks a lot Chris, you are my hero. Map is working great once again.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;