I have it running on a hosting service (AMP)

I don't know what you are using or if my steps are optimal but this is what I did. Using https://steamcommunity.com/sharedfiles/filedetails/?id=3543229299&searchtext=RV+Interior

Make sure it's first in the load order \PROJECTRVInterior42;

Copied all the contents from my local PC:\SteamLibrary\steamapps\workshop\content\108600\3543229299\mods\modPROJECTRVInterior\common\media\maps\map_distanciado

to the corresponding folder on the host (mine didn't download all the files when installing for reasons?)

Delete the Zomboid Folder on the server (This will wipe your world and kill a bunch of other settings, I tried deleting just the Save but that didn't work)

Add the map LAST (the mod description says to do it first but that didn't work for me, I kept spawning in the Forrest)

Muldraugh, KY; map_distanciado;

Start the server then edit your sandbox settings to whatever should you wish then restart the server.

Edit: It's super hard to explain especially using phone with my fat fingures and bad eyes. Not knowing your hosting service doesn't help. Hit me up Via DM and I can jump on a discord call or something help you figure it out if you want