Check inventory script - Revision history

Tampa at 08:24, 29 November 2025

2025-11-29T08:24:36Z

2022-05-13T05:04:07Z

‎Remove duplicates

2022-05-12T12:06:10Z

2022-05-12T09:50:40Z

‎Checking bad root folders

2022-05-11T16:16:40Z

‎Usage

2022-05-11T16:07:49Z

‎How to resolve issues

2022-05-11T16:06:16Z

‎Check Inventory Script

2022-05-11T16:06:00Z

‎Check Inventory Script

2022-05-11T16:04:16Z

‎Check Inventory Script

2022-05-11T16:01:49Z

‎Check Inventory Script

← Older revision		Revision as of 08:24, 29 November 2025
Line 1:		Line 1:
−	{{Quicklinks}}	+	{{Quicklinks\|Check_inventory_script}}

	== Check Inventory Script ==		== Check Inventory Script ==

@@ Line 79: / Line 79: @@
 However, removing the folder entirely when it might contain items the user placed there might not be the best idea. Instead simply change the type of each duplicate folder to "-1" to make them regular folders.
-<pre style="color: darkblue"> UPDATE inventoryfolders SET `type` = '-1' WHERE `AgentID` = 'user-uuid' AND `parentFolderID` != 'folderID of My Inventory'; </pre>
+<pre style="color: darkblue"> UPDATE inventoryfolders SET `type` = '-1' WHERE `AgentID` = 'user-uuid' AND `parentFolderID` != 'folderID of My Inventory' AND `parentFolderID` != '00000000-0000-0000-0000-000000000000'; </pre>
 This will set all folders to type "-1" for that specific user if the parent folder is not "My Inventory", which will change all "My Suitcase" sub-folders.

@@ Line 83: / Line 83: @@
 ==== Checking bad root folders ====
-Newer versions of OpenSim will put the "My Suitcase" folder as a type that does not conflict, usually type "100", but older versions will have put it as type "8" or "9", which causes a fatal error. To resolve this change the type to "-1" as well.
+Newer versions of OpenSim will put the "My Suitcase" folder as a type that does not conflict, usually type "100", but older versions will have put it as type "8" or "9", which causes a fatal error. To resolve this change the type to "100".
-<pre style="color: darkblue"> UPDATE inventoryfolders SET `type` = '-1' WHERE `AgentID` = 'user-uuid' AND `folderName` = 'My Suitcase'; </pre>
+<pre style="color: darkblue"> UPDATE inventoryfolders SET `type` = '100' WHERE `AgentID` = 'user-uuid' AND `folderName` = 'My Suitcase'; </pre>
 In some cases the "My Inventory" folder might still be of the old type "9", which will also causes issues. To resolve this it needs to be changed to type "8".

@@ Line 28: / Line 28: @@
 <div style="background-color:#FFA0A0; padding:10px; padding-bottom:5px; border: 1px #FF544F solid">
-'''If this seems complicated or dangerous that is because making changes to the database directly usually is. If this is something you rather leave to someone with more knowledge feel free to reach out to people on IRC for help or contact one of the many providers of OpenSim hosted services.'''
+'''If this seems complicated or dangerous that is because making changes to the database directly usually is. If this is something you rather leave to someone with more knowledge feel free to reach out to people on IRC for help or contact one of the many [http://opensimulator.org/wiki/FAQ#OpenSimulator_in_the_Wild providers of OpenSim hosted services].'''
 </div>

← Older revision		Revision as of 16:07, 11 May 2022
Line 40:		Line 40:

	To resolve issues the inventory structure needs to be returned to the proper setup accepted by the viewers. To do this you will need to edit the inventoryfolders database table. This can be done from the command line or via external programs such as [https://dbeaver.io/ DBeaver] or [https://www.navicat.com/en/ Navicat] whichever you prefer.		To resolve issues the inventory structure needs to be returned to the proper setup accepted by the viewers. To do this you will need to edit the inventoryfolders database table. This can be done from the command line or via external programs such as [https://dbeaver.io/ DBeaver] or [https://www.navicat.com/en/ Navicat] whichever you prefer.
		+
		+
		+	==== Create a backup ====
		+
		+	'''Using tools like sqldump or the aforementioned database tools create a backup of the inventoryfolders table first before making edits to the table!'''
		+

	==== Find the user ====		==== Find the user ====

← Older revision		Revision as of 16:06, 11 May 2022
Line 23:		Line 23:

	<pre style="color: red"> php check_inventory.php everyone true</pre> Will run the script looking for optional duplicate folders of the same type for all users in UserAccounts table.		<pre style="color: red"> php check_inventory.php everyone true</pre> Will run the script looking for optional duplicate folders of the same type for all users in UserAccounts table.
		+
		+
		+

	<div style="background-color:#FFA0A0; padding:10px; padding-bottom:5px; border: 1px #FF544F solid">		<div style="background-color:#FFA0A0; padding:10px; padding-bottom:5px; border: 1px #FF544F solid">

@@ Line 24: / Line 24: @@
 <pre style="color: red"> php check_inventory.php everyone true</pre> Will run the script looking for optional duplicate folders of the same type for all users in UserAccounts table.
+<div style="background-color:#FFA0A0; padding:10px; padding-bottom:5px; border: 1px #FF544F solid">
-<nowiki> If this seems complicated or dangerous that is because making changes to the database directly usually is. If this is something you rather leave to someone with more knowledge feel free to reach out to people on IRC for help or contact one of the many providers of OpenSim hosted services.</nowiki>
+'''If this seems complicated or dangerous that is because making changes to the database directly usually is. If this is something you rather leave to someone with more knowledge feel free to reach out to people on IRC for help or contact one of the many providers of OpenSim hosted services.'''
 == How to resolve issues ==

← Older revision		Revision as of 16:04, 11 May 2022
Line 25:		Line 25:


−	~~'''~~If this seems complicated or dangerous that is because making changes to the database directly usually is. If this is something you rather leave to someone with more knowledge feel free to reach out to people on IRC for help or contact one of the many providers of OpenSim hosted services.~~'''~~	+	<nowiki> If this seems complicated or dangerous that is because making changes to the database directly usually is. If this is something you rather leave to someone with more knowledge feel free to reach out to people on IRC for help or contact one of the many providers of OpenSim hosted services.</nowiki>

	== How to resolve issues ==		== How to resolve issues ==

← Older revision		Revision as of 16:01, 11 May 2022
Line 23:		Line 23:

	<pre style="color: red"> php check_inventory.php everyone true</pre> Will run the script looking for optional duplicate folders of the same type for all users in UserAccounts table.		<pre style="color: red"> php check_inventory.php everyone true</pre> Will run the script looking for optional duplicate folders of the same type for all users in UserAccounts table.
		+
		+
		+	'''If this seems complicated or dangerous that is because making changes to the database directly usually is. If this is something you rather leave to someone with more knowledge feel free to reach out to people on IRC for help or contact one of the many providers of OpenSim hosted services.'''

	== How to resolve issues ==		== How to resolve issues ==