From 08d2fcb1f7ae0ced528c0a7230c433480d64167c Mon Sep 17 00:00:00 2001 From: Bharat Mediratta Date: Thu, 5 Mar 2009 06:26:15 +0000 Subject: Fix some table names --- modules/exif/helpers/exif_task.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'modules/exif/helpers/exif_task.php') diff --git a/modules/exif/helpers/exif_task.php b/modules/exif/helpers/exif_task.php index c26b209f..8e715b52 100644 --- a/modules/exif/helpers/exif_task.php +++ b/modules/exif/helpers/exif_task.php @@ -23,13 +23,13 @@ class exif_task_Core { // Delete extra exif_records $db->query( - "DELETE {exif_records}.* FROM `exif_records` " . + "DELETE {exif_records}.* FROM {exif_records} " . "LEFT JOIN {items} ON ({exif_records}.`item_id` = {items}.`id`) " . "WHERE {items}.`id` IS NULL"); // Insert missing exif_records $db->query( - "INSERT INTO {exif_record}(`item_id`) (" . + "INSERT INTO {exif_records}(`item_id`) (" . " SELECT {items}.`id` FROM {items} " . " LEFT JOIN {exif_records} ON ({exif_records}.`item_id` = {items}.`id`) " . " WHERE {exif_records}.`id` IS NULL)"); -- cgit v1.2.3