bugfixes

diff --git a/source/mircoders/entity/EntityOther.java b/source/mircoders/entity/EntityOther.java
index 0ec4ad0..e26e5e6 100755 (executable)
--- a/source/mircoders/entity/EntityOther.java
+++ b/source/mircoders/entity/EntityOther.java
@@ -59,8 +59,7 @@ public class EntityOther extends EntityUploadedMedia
   public void update() throws StorageObjectFailure {\r
     super.update();\r
     try {\r
-      theStorageObject.executeUpdate(\r
-          "update content set is_produced='0' where to_media=" + getId());\r
+      theStorageObject.executeUpdate("update content set is_produced='0' where exists(select * from content_x_media where to_content=content.id and to_media=" + getId()+")");\r
     }\r
     catch (SQLException e) {\r
       throwStorageObjectFailure(e, "EntityOther :: update :: failed!! ");\r

diff --git a/source/mircoders/entity/EntityVideo.java b/source/mircoders/entity/EntityVideo.java
index 01c63ee..372306d 100755 (executable)
--- a/source/mircoders/entity/EntityVideo.java
+++ b/source/mircoders/entity/EntityVideo.java
@@ -66,7 +66,7 @@ public class EntityVideo extends EntityUploadedMedia
     super.update();\r
 \r
     try {\r
-      theStorageObject.executeUpdate("update content set is_produced='0' where to_media=" + getId());\r
+      theStorageObject.executeUpdate("update content set is_produced='0' where exists(select * from content_x_media where to_content=content.id and to_media=" + getId()+")");\r
     }\r
     catch (SQLException e) {\r
       logger.error("EntityVideo.update: " + e.toString());\r