From: Dan Brown <redacted>
Date: Wed, 8 Feb 2023 13:20:00 +0000 (+0000)
Subject: Removed deprecated syntax in old migration file
X-Git-Tag: v23.02~1^2~20
X-Git-Url: http://source.bookstackapp.com/bookstack/commitdiff_plain/5d18e7df79983db0b86631df6b156aa5c7a71cbf

Removed deprecated syntax in old migration file
---

diff --git a/database/migrations/2017_04_20_185112_add_revision_counts.php b/database/migrations/2017_04_20_185112_add_revision_counts.php
index 9961c1dee..891ff8e0a 100644
--- a/database/migrations/2017_04_20_185112_add_revision_counts.php
+++ b/database/migrations/2017_04_20_185112_add_revision_counts.php
@@ -24,7 +24,7 @@ return new class extends Migration
         // Update revision count
         $pTable = DB::getTablePrefix() . 'pages';
         $rTable = DB::getTablePrefix() . 'page_revisions';
-        DB::statement("UPDATE ${pTable} SET ${pTable}.revision_count=(SELECT count(*) FROM ${rTable} WHERE ${rTable}.page_id=${pTable}.id)");
+        DB::statement("UPDATE {$pTable} SET {$pTable}.revision_count=(SELECT count(*) FROM {$rTable} WHERE {$rTable}.page_id={$pTable}.id)");
     }
 
     /**