]> BookStack Code Mirror - bookstack/commitdiff
Removed deprecated syntax in old migration file
authorDan Brown <redacted>
Wed, 8 Feb 2023 13:20:00 +0000 (13:20 +0000)
committerDan Brown <redacted>
Wed, 8 Feb 2023 13:20:00 +0000 (13:20 +0000)
database/migrations/2017_04_20_185112_add_revision_counts.php

index 9961c1dee3755bfeafa31878361a8a26376abfc1..891ff8e0a1de4ba216c3b82e66815061929c8876 100644 (file)
@@ -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)");
     }
 
     /**
Morty Proxy This is a proxified and sanitized view of the page, visit original site.