diff options
Diffstat (limited to 'lib')
-rw-r--r-- | lib/Migration/Version150004Date20201009183830.php | 2 | ||||
-rw-r--r-- | lib/Migration/Version150005Date20201009192341.php | 4 |
2 files changed, 3 insertions, 3 deletions
diff --git a/lib/Migration/Version150004Date20201009183830.php b/lib/Migration/Version150004Date20201009183830.php index 635d8d592..b587d8ad9 100644 --- a/lib/Migration/Version150004Date20201009183830.php +++ b/lib/Migration/Version150004Date20201009183830.php @@ -72,7 +72,7 @@ class Version150004Date20201009183830 extends SimpleMigrationStep { $item_name = $this->connection->getQueryBuilder()->getTableName('news_items'); $feed_name = $this->connection->getQueryBuilder()->getTableName('news_feeds'); - $items_query = "DELETE FROM ${item_name} WHERE ${item_name}.`feed_id` NOT IN (SELECT DISTINCT id FROM ${feed_name})"; + $items_query = "DELETE FROM {$item_name} WHERE {$item_name}.`feed_id` NOT IN (SELECT DISTINCT id FROM {$feed_name})"; $this->connection->executeQuery($items_query); } } diff --git a/lib/Migration/Version150005Date20201009192341.php b/lib/Migration/Version150005Date20201009192341.php index 7d739603b..bcb4195d5 100644 --- a/lib/Migration/Version150005Date20201009192341.php +++ b/lib/Migration/Version150005Date20201009192341.php @@ -41,13 +41,13 @@ class Version150005Date20201009192341 extends SimpleMigrationStep { $feed_name = $this->connection->getQueryBuilder()->getTableName('news_feeds'); $folder_name = $this->connection->getQueryBuilder()->getTableName('news_folders'); - $items_query = "DELETE FROM ${feed_name} WHERE ${feed_name}.`folder_id` NOT IN (SELECT DISTINCT id FROM ${folder_name}) AND ${feed_name}.`folder_id` IS NOT NULL"; + $items_query = "DELETE FROM {$feed_name} WHERE {$feed_name}.`folder_id` NOT IN (SELECT DISTINCT id FROM {$folder_name}) AND {$feed_name}.`folder_id` IS NOT NULL"; $this->connection->executeQuery($items_query); $item_name = $this->connection->getQueryBuilder()->getTableName('news_items'); $feed_name = $this->connection->getQueryBuilder()->getTableName('news_feeds'); - $items_query = "DELETE FROM ${item_name} WHERE ${item_name}.`feed_id` NOT IN (SELECT DISTINCT id FROM ${feed_name})"; + $items_query = "DELETE FROM {$item_name} WHERE {$item_name}.`feed_id` NOT IN (SELECT DISTINCT id FROM {$feed_name})"; $this->connection->executeQuery($items_query); } |