From c5715bc756b2bfc010f4f861705d40bf092304e5 Mon Sep 17 00:00:00 2001
From: Mikael Nordfeldth <mmn@hethane.se>
Date: Wed, 15 Apr 2015 23:25:12 +0200
Subject: [PATCH] File_to_post indexing and cleaning preparations

---
 classes/File.php         | 8 ++++++++
 classes/File_to_post.php | 3 ++-
 2 files changed, 10 insertions(+), 1 deletion(-)

diff --git a/classes/File.php b/classes/File.php
index 242da159c2..1e296242b7 100644
--- a/classes/File.php
+++ b/classes/File.php
@@ -569,6 +569,14 @@ class File extends Managed_DataObject
                     $thumbs->delete();
                 }
             }
+
+            $f2p = new File_to_post();
+            $f2p->file_id = $this->id;
+            if ($f2p->find()) {
+                while ($f2p->fetch()) {
+                    $f2p->delete();
+                }
+            }
         }
 
         // And finally remove the entry from the database
diff --git a/classes/File_to_post.php b/classes/File_to_post.php
index 1d2733738f..4c751ae4f3 100644
--- a/classes/File_to_post.php
+++ b/classes/File_to_post.php
@@ -52,6 +52,7 @@ class File_to_post extends Managed_DataObject
                 'file_to_post_post_id_fkey' => array('notice', array('post_id' => 'id')),
             ),
             'indexes' => array(
+                'file_id_idx' => array('file_id'),
                 'post_id_idx' => array('post_id'),
             ),
         );
@@ -87,7 +88,7 @@ class File_to_post extends Managed_DataObject
     function delete($useWhere=false)
     {
         $f = File::getKV('id', $this->file_id);
-        if (!empty($f)) {
+        if ($f instanceof File) {
             $f->blowCache();
         }
         return parent::delete($useWhere);
-- 
2.39.5