id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
12253	MU global taxonomy can be disrupted when blog db tables are copied directly in	donncha		"If you've used MU much you'll probably have noticed that term_ids increase whenever you edit a category or tag. There's actually a bug #12206 about it but I closed it earlier today. This is how we maintain global tags/categories in MU. Whenever one is changed you have to assume some other blog may have used it already so you have to give the changed tag/cat a new term_id.

That makes it easy to maintain the correct term_id for the same tag or category across blogs.

Well, that all goes out the window when you copy a blog into a wpmu site using phpmyadmin and not through the WP importer. 

It's not normally much of a problem except if you want to do something with the global tags like use the sitewide tags plugin. The problem showed there with numeric categories instead of the correct category showing on the tags table. 

I received a patch for fixing the plugin that checked the cat_ID before inserting the post into the tags blog. (props Nasim Mansurov) Upon investigation I discovered he had copied his first blog's db tables directly into his MU site.

MU really should handle that more gracefully. It should do a once off check of the categories and tags, comparing them against the data in the sitecategories table and adjust the term_ids in the local blog's taxonomy."	defect (bug)	closed	normal		Multisite	2.9.2	normal	wontfix