| Index: trunk/phase3/includes/SearchPostgres.php |
| — | — | @@ -201,9 +201,9 @@ |
| 202 | 202 | |
| 203 | 203 | function update( $pageid, $title, $text ) { |
| 204 | 204 | ## We don't want to index older revisions |
| 205 | | - $SQL = "UPDATE pagecontent SET textvector = NULL WHERE old_id = ". |
| | 205 | + $SQL = "UPDATE pagecontent SET textvector = NULL WHERE old_id IN ". |
| 206 | 206 | "(SELECT rev_text_id FROM revision WHERE rev_page = $pageid ". |
| 207 | | - "ORDER BY rev_text_id DESC LIMIT 1 OFFSET 1)"; |
| | 207 | + "ORDER BY rev_text_id DESC OFFSET 1)"; |
| 208 | 208 | $this->db->doQuery($SQL); |
| 209 | 209 | return true; |
| 210 | 210 | } |