Increase length of attachments file names (and truncate if really too long)

2 files changed, 7 insertions, 2 deletions

diff --git a/app/Model/File.php b/app/Model/File.php
index fe417d48..cb1e4792 100644
--- a/app/Model/File.php
+++ b/app/Model/File.php
@@ -92,7 +92,7 @@ class File extends Base
 
         return $this->db->table(self::TABLE)->save(array(
             'task_id' => $task_id,
-            'name' => $name,
+            'name' => substr($name, 0, 255),
             'path' => $path,
             'is_image' => $is_image ? '1' : '0',
             'size' => $size,
diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php
index aa611a6e..a65525c8 100644
--- a/app/Schema/Mysql.php
+++ b/app/Schema/Mysql.php
@@ -6,7 +6,12 @@ use PDO;
 use Core\Security;
 use Model\Link;
 
-const VERSION = 71;
+const VERSION = 72;
+
+function version_72($pdo)
+{
+    $pdo->exec('ALTER TABLE files MODIFY name VARCHAR(255)');
+}
 
 function version_71($pdo)
 {