How can I remove an invisible cart from my server?
Table of contents
- Locating the cart in your Database
- Checking the container to make sure cart is empty
- Finding the container and ensure Object type id Match using your container ID
- Time to delete all of the above
- ENSURE ANY DELETIONS ARE ONLY FOR THE OBJECT TYPE YOU WISH TO REMOVE
Locating the cart in your Database
- Stand on the cart in game
-
Use Below command in server console to gain the geo id of the cart whilst looking down at it
$TerrainSelection::debug_drawCellInfo = 1;
- Goto table Objects_Patch in database
-
Use the geo id in game to find the cart.
You can cheat using a query changing the “GeoDataID” to your needs
SELECT * FROM objects_patch WHERE GeoDataID = 117521895 ORDER BY ObjectTypeID ASC LIMIT 1000;SHOW TABLE STATUS LIKE 'objects_patch';
you can confirm you are looking at the correct object as ObjectTypeID for this item as it will be the following
1497 for horse cart no tent
1461 for horse cart with tent
Checking the container to make sure cart is empty
-
goto table “moveable_objects” and use the object id from objects patch with this query (replacing “Where ID = 72125” with the ID provided by the last step)
SELECT * FROM movable_objects WHERE ID = 72125 ORDER BY ID DESC LIMIT 1000;SHOW TABLE STATUS LIKE 'movable_objects';
Finding the container and ensure Object type id Match using your container ID
-
SELECT * FROM containers WHERE ID = 72584 LIMIT 1000;SHOW TABLE STATUS LIKE ‘containers’;
-
Goto the items table and use your container ID with the following query, any items inside the cart will show up. in this case cart is empty so no need to transfer items to new container.
SELECT * FROM items WHERE ContainerID = 72584 ORDER BY ObjectTypeID ASC LIMIT 1000;SHOW TABLE STATUS LIKE 'items';
Time to delete all of the above
Delete the lines associated with the cart from the following
moveable_objects
Objects_Patch
Containers
ENSURE ANY DELETIONS ARE ONLY FOR THE OBJECT TYPE YOU WISH TO REMOVE
-
AS A PRECAUTION IT IS SMART TO RUN THIS COMMAND IN SERVER CONSOLE AFTER DELETIONS
stretchedPatchMaintenance();
WAIT FOR IT TO SAY THE MAINTENANCE IS COMPLETE
- RESTART SERVER.
- it is important to allow the server to save data otherwise patch maintenance error can occur, this is difficult to resolve