Talk:Troubleshooting - Revision history

Tampa at 03:42, 27 September 2023

2023-09-27T03:42:31Z

Gwyneth Llewelyn: /* Neither there is a "users" table, nor any table has a "userInventoryURI" field... */ new section

2023-09-26T16:45:00Z

‎Neither there is a "users" table, nor any table has a "userInventoryURI" field...: new section

Magneto CartWheel: Erasing my mistaking text.

2010-10-19T15:03:44Z

Erasing my mistaking text.

Magneto CartWheel: /* Union section proposal and discussion */ new section

2010-10-19T15:01:33Z

‎Union section proposal and discussion: new section

Magneto CartWheel: New page: Is the situation under "Errors from incomplete data migrations" really and Opensim migration to MySQL from Windows to Linux?. Should they join these two situations or are they different? ...

2010-10-19T14:58:49Z

New page: Is the situation under "Errors from incomplete data migrations" really and Opensim migration to MySQL from Windows to Linux?. Should they join these two situations or are they different? ...

New page

Is the situation under "Errors from incomplete data migrations" really and Opensim migration to MySQL from Windows to Linux?.

Should they join these two situations or are they different?

Is the migration table erase a good solution or remigration could damage the integrity of the database?.

Thank you very much.

--[[User:Magneto CartWheel|Magneto CartWheel]] 14:58, 19 October 2010 (UTC)

← Older revision		Revision as of 03:42, 27 September 2023
Line 32:		Line 32:

	— [[User:Gwyneth Llewelyn\|Gwyneth Llewelyn]] ([[User talk:Gwyneth Llewelyn\|talk]]) 09:45, 26 September 2023 (PDT)		— [[User:Gwyneth Llewelyn\|Gwyneth Llewelyn]] ([[User talk:Gwyneth Llewelyn\|talk]]) 09:45, 26 September 2023 (PDT)
		+
		+
		+	Pretty sure that table hasn't existed for... gonna have to write a few more numbers on that first. Remember there is basically 5 people that still update these pages so some of this hasn't changed since it was written. Feel free to remove obsolete information or changing it to current standards, much appreciate that :) -Tampa

← Older revision		Revision as of 16:45, 26 September 2023
Line 10:		Line 10:

	--[[User:Magneto CartWheel\|Magneto CartWheel]] 15:01, 19 October 2010 (UTC)		--[[User:Magneto CartWheel\|Magneto CartWheel]] 15:01, 19 October 2010 (UTC)
		+
		+	== Neither there is a "users" table, nor any table has a "userInventoryURI" field... ==
		+
		+	On section [[Troubleshooting#After_starting_OpenSimulator_with_Hypergrid_enabled_my_inventory_wont_load.21\|"After starting OpenSimulator with Hypergrid enabled my inventory wont load!"]] ''(sic)'' it is claimed that the following two commands will 'fix' Hypergrid-related issues with profiles, inventories, etc. not loading properly:
		+
		+	update users set userInventoryURI="http://new.UGAIM.address:8004" where userInventoryURI = "http://old.UGAIM.address:8004";
		+	update users set userAssetURI="http://new.UGAIM.address:8003" where userAssetURI = "http://old.UGAIM.address:8003";
		+
		+	Now, please correct me if I'm wrong, but under OpenSimulator 0.9.3.0, there is no <code>users</code> table any longer.
		+
		+	Instead, there are essentially two tables with user-related information:
		+
		+	# <code>UserAccounts</code>
		+	# <code>GridUser</code> (if your grid is configured to allow Hyperjumps)
		+
		+	Neither has a <code>userInventoryURI</code> or a <code>userAssetURI</code> row; this might have been true in the distant past, but not any longer. <code>UserAccounts</code> stores the local users, so there is a <code>ServiceURLs</code> column, which essentially contains a list of the many service URLs (beyond Inventory and Asset server(s)), one per line; as a consequence, you cannot write a simple one-liner as suggested above — that is, even if the table and the columns exist (legacy?), if you replace the code above with <code>UserAccounts</code> and <code>ServiceURLs</code> instead, then, well, congrats, you've just bricked your own configuration :-(
		+
		+	<code>GridUser</code> seems to deal both with remote accounts hyperjumping to your grid, and, conversely, with 'gridnauts' among your own users that (may) have teleported to a different grid. As such, to track these down, <code>GridUser</code> includes the 'base URI' for the visitor origin grid, saved directly to the <code>UserId</code> field. Currently, the format of this field is made of three subfields — avatar UUID, an URI (to the grid of origin), and the avatar name, all separated by semicolons. The URI ''is'' the 'main' grid URI, that is, the one where the login server is running, and which will probably be able to retrieve the URI for the Inventory & Asset servers of the origin grid.
		+
		+	So... whatever was meant with that suggestion, it definitely requires an update!
		+
		+	— [[User:Gwyneth Llewelyn\|Gwyneth Llewelyn]] ([[User talk:Gwyneth Llewelyn\|talk]]) 09:45, 26 September 2023 (PDT)

← Older revision		Revision as of 15:03, 19 October 2010
Line 1:		Line 1:
−	~~Is the situation under "Errors from incomplete data migrations" really and Opensim migration to MySQL from Windows to Linux?.~~
−
−	~~Should they join these two situations or are they different?~~
−
−	~~Is the migration table erase a good solution or remigration could damage the integrity of the database?.~~
−
−	~~Thank you very much.~~
−
−	~~--[[User:Magneto CartWheel\|Magneto CartWheel]] 14:58, 19 October 2010 (UTC)~~
−
	== Union section proposal and discussion ==		== Union section proposal and discussion ==

← Older revision		Revision as of 15:01, 19 October 2010
Line 8:		Line 8:

	--[[User:Magneto CartWheel\|Magneto CartWheel]] 14:58, 19 October 2010 (UTC)		--[[User:Magneto CartWheel\|Magneto CartWheel]] 14:58, 19 October 2010 (UTC)
		+
		+	== Union section proposal and discussion ==
		+
		+	Is the situation under "Errors from incomplete data migrations" really and Opensim migration to MySQL from Windows to Linux?.
		+
		+	Should they join these two situations or are they different?
		+
		+	Is the migration table erase a good solution or remigration could damage the integrity of the database?.
		+
		+	Thank you very much.
		+
		+	--[[User:Magneto CartWheel\|Magneto CartWheel]] 15:01, 19 October 2010 (UTC)