0000077: New Tool to Fix Orphaned Posts

ID	Project	Category	View Status	Date Submitted	Last Update

0000077	XMB1	New Features	public	2008-07-26 18:05	2008-11-28 22:08

Reporter	miqrogroove	Assigned To	miqrogroove
Priority	high	Severity	feature	Reproducibility	N/A
Status	closed	Resolution	fixed
Target Version	1.9.11	Fixed in Version	1.9.11

Summary	0000077: New Tool to Fix Orphaned Posts
Description	We have two orphaned post scenarios that are common in the xmbforum.com database today. 1. Posts with invalid tids. 2. Posts with invalid fids. I just ran this check on xmbforum.com.. Query Results: SELECT COUNT(p.pid) FROM xmb_posts AS p LEFT JOIN xmb_threads AS t USING (tid) WHERE t.tid IS NULL COUNT(p.pid) 1148 Query Results: SELECT COUNT(p.pid) FROM xmb_posts AS p LEFT JOIN xmb_threads AS t USING (tid) WHERE p.fid != t.fid COUNT(p.pid) 1028
Tags	No tags attached.

MySQL Version
PHP Version
Web Server
Browser
Flags
Original Reporter
SVN Revision	1388

Date Modified	Username	Field	Change
2008-07-26 18:05	miqrogroove	New Issue
2008-07-26 18:06	miqrogroove	Relationship added	related to 0000076
2008-08-23 19:24	miqrogroove	Status	new => confirmed
2008-11-16 19:42	miqrogroove	Description Updated
2008-11-16 19:57	miqrogroove	Relationship added	related to 0000050
2008-11-23 23:51	miqrogroove	SVN Revision	=> 1388
2008-11-23 23:51	miqrogroove	Status	confirmed => resolved
2008-11-23 23:51	miqrogroove	Fixed in Version	=> 1.9.11
2008-11-23 23:51	miqrogroove	Resolution	open => fixed
2008-11-23 23:51	miqrogroove	Assigned To	=> miqrogroove
2008-11-28 22:08	miqrogroove	Status	resolved => closed

related to	0000076	closed	miqrogroove	Posts Orphaned by Incorrect WHERE Command in viewthread
related to	0000050	closed	miqrogroove	viewthread should not rely on threads.replies