diff options
| -rw-r--r-- | modules/exif/helpers/exif_task.php | 6 | ||||
| -rw-r--r-- | modules/search/helpers/search_task.php | 6 |
2 files changed, 6 insertions, 6 deletions
diff --git a/modules/exif/helpers/exif_task.php b/modules/exif/helpers/exif_task.php index e6609cec..b6599395 100644 --- a/modules/exif/helpers/exif_task.php +++ b/modules/exif/helpers/exif_task.php @@ -23,9 +23,9 @@ class exif_task_Core { // Delete extra exif_records $db->query( - "DELETE {exif_records}.* FROM {exif_records} " . - "LEFT JOIN {items} ON ({exif_records}.`item_id` = {items}.`id`) " . - "WHERE {items}.`id` IS NULL"); + "DELETE FROM {exif_records} " . + "WHERE {exif_records}.`item_id` NOT IN " . + "(SELECT `id` FROM {items})"); // Insert missing exif_records $db->query( diff --git a/modules/search/helpers/search_task.php b/modules/search/helpers/search_task.php index 98eba097..d3d4377b 100644 --- a/modules/search/helpers/search_task.php +++ b/modules/search/helpers/search_task.php @@ -21,9 +21,9 @@ class search_task_Core { static function available_tasks() { // Delete extra search_records Database::instance()->query( - "DELETE {search_records}.* FROM {search_records} " . - "LEFT JOIN {items} ON ({search_records}.`item_id` = {items}.`id`) " . - "WHERE {items}.`id` IS NULL"); + "DELETE FROM {search_records} " . + "WHERE {search_records}.`item_id` NOT IN " . + "(SELECT `id` FROM {items})"); // Insert missing search_records Database::instance()->query( |