diff options
author | Tim Almdal <tnalmdal@shaw.ca> | 2009-03-18 01:20:30 +0000 |
---|---|---|
committer | Tim Almdal <tnalmdal@shaw.ca> | 2009-03-18 01:20:30 +0000 |
commit | 8e1817d4e4f6be8b550f38f7103d5cf01ac503f9 (patch) | |
tree | 118166a9f4d8e612ed3004183f550389abde3ec1 | |
parent | 222f6e2e23a878b5c598fa189a8c385fe6f0ebf3 (diff) |
Couple of sql statements that had incorrect prefix handling or no
prefix handling.
-rw-r--r-- | modules/comment/helpers/comment_installer.php | 3 | ||||
-rw-r--r-- | modules/search/helpers/search_event.php | 2 |
2 files changed, 2 insertions, 3 deletions
diff --git a/modules/comment/helpers/comment_installer.php b/modules/comment/helpers/comment_installer.php index 5c5e9f03..69a08c63 100644 --- a/modules/comment/helpers/comment_installer.php +++ b/modules/comment/helpers/comment_installer.php @@ -61,8 +61,7 @@ class comment_installer { $sql = "SELECT `item_id` FROM {comments}"; module::event("item_related_update_batch", $sql); - $db->query("DROP TABLE IF EXISTS {comments] -`;"); + $db->query("DROP TABLE IF EXISTS {comments}`;"); module::delete("comment"); } } diff --git a/modules/search/helpers/search_event.php b/modules/search/helpers/search_event.php index 83e65721..68020b10 100644 --- a/modules/search/helpers/search_event.php +++ b/modules/search/helpers/search_event.php @@ -46,6 +46,6 @@ class search_event_Core { static function item_related_update_batch($sql) { $db = Database::instance(); - $db->query("UPDATE `search_records` SET `dirty` = 1 WHERE item_id IN ($sql)"); + $db->query("UPDATE `{search_records}` SET `dirty` = 1 WHERE item_id IN ($sql)"); } } |