Occasionally the publishing status history can be confused, either due to a bug, or to allot of restructuring of a given site. The following SQL will “reset” or clear the publishing status from all content in all sites on the system.
NOTE: An incremental edition run after clearing publishing status history will essentially be a Full publish until either a Full Publishing or a Full Incremental completes.
DELETE FROM PSX_PUBLICATION_SITE_ITEM;
DELETE FROM PSX_PUBLICATION_DOC;
DELETE FROM PSX_PUBLICATION_STATUS;