3 files changed, 3 insertions, 0 deletions
diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php
index 2dcfd3b7..e5269d93 100644
--- a/app/Schema/Mysql.php
+++ b/app/Schema/Mysql.php
@@ -162,6 +162,7 @@ function version_49($pdo)
     $pdo->exec('ALTER TABLE subtasks ADD COLUMN position INTEGER DEFAULT 1');
 
     $task_id = 0;
+    $position = 1;
     $urq = $pdo->prepare('UPDATE subtasks SET position=? WHERE id=?');
 
     $rq = $pdo->prepare('SELECT * FROM subtasks ORDER BY task_id, id ASC');
diff --git a/app/Schema/Postgres.php b/app/Schema/Postgres.php
index 6c6ea001..2c5e0f28 100644
--- a/app/Schema/Postgres.php
+++ b/app/Schema/Postgres.php
@@ -155,6 +155,7 @@ function version_30($pdo)
     $pdo->exec('ALTER TABLE subtasks ADD COLUMN position INTEGER DEFAULT 1');
 
     $task_id = 0;
+    $position = 1;
     $urq = $pdo->prepare('UPDATE subtasks SET position=? WHERE id=?');
 
     $rq = $pdo->prepare('SELECT * FROM subtasks ORDER BY task_id, id ASC');
diff --git a/app/Schema/Sqlite.php b/app/Schema/Sqlite.php
index ef6523e4..b9c264bc 100644
--- a/app/Schema/Sqlite.php
+++ b/app/Schema/Sqlite.php
@@ -157,6 +157,7 @@ function version_48($pdo)
     // Migrate all subtasks position
 
     $task_id = 0;
+    $position = 1;
     $urq = $pdo->prepare('UPDATE subtasks SET position=? WHERE id=?');
 
     $rq = $pdo->prepare('SELECT * FROM subtasks ORDER BY task_id, id ASC');