- $sql = "UPDATE pagecontent SET textvector = NULL WHERE textvector IS NOT NULL and old_id IN " .
- "(SELECT DISTINCT rev_text_id FROM revision WHERE rev_page = " . intval( $pageid ) .
- " ORDER BY rev_text_id DESC OFFSET 1)";
+ $slotRoleStore = MediaWikiServices::getInstance()->getSlotRoleStore();
+ $sql = "UPDATE pagecontent SET textvector = NULL " .
+ "WHERE textvector IS NOT NULL " .
+ "AND old_id IN " .
+ "(SELECT DISTINCT substring( c.content_address from '^tt:([0-9]+)$' )::int AS old_rev_text_id " .
+ " FROM content c, slots s, revision r " .
+ " WHERE r.rev_page = $pageid " .
+ " AND s.slot_revision_id = r.rev_id " .
+ " AND s.slot_role_id = " . $slotRoleStore->getId( SlotRecord::MAIN ) . " " .
+ " AND c.content_id = s.slot_content_id " .
+ " ORDER BY old_rev_text_id DESC OFFSET 1)";