Change the value column of the messages table from a varchar(255) to a

text.  Fixes #1612.

1 files changed, 7 insertions, 2 deletions

diff --git a/modules/gallery/helpers/gallery_installer.php b/modules/gallery/helpers/gallery_installer.php
index 3c7b1c84..92e5b7b8 100644
--- a/modules/gallery/helpers/gallery_installer.php
+++ b/modules/gallery/helpers/gallery_installer.php
@@ -136,7 +136,7 @@ class gallery_installer {
                  `id` int(9) NOT NULL auto_increment,
                  `key` varchar(255) default NULL,
                  `severity` varchar(32) default NULL,
-                 `value` varchar(255) default NULL,
+                 `value` text default NULL,
                  PRIMARY KEY (`id`),
                  UNIQUE KEY(`key`))
                DEFAULT CHARSET=utf8;");
@@ -309,7 +309,7 @@ class gallery_installer {
     module::set_var("gallery", "show_user_profiles_to", "registered_users");
     module::set_var("gallery", "extra_binary_paths", "/usr/local/bin:/opt/local/bin:/opt/bin");
 
-    module::set_version("gallery", 44);
+    module::set_version("gallery", 45);
   }
 
   static function upgrade($version) {
@@ -658,6 +658,11 @@ class gallery_installer {
       $db->query("ALTER TABLE {items} CHANGE `rand_key` `rand_key` DECIMAL(11, 10)");
       module::set_version("gallery", $version = 44);
     }
+
+    if ($version == 44) {
+      $db->query("ALTER TABLE {messages} CHANGE `value` `value` text default NULL");
+      module::set_version("gallery", $version = 45);
+    }
   }
 
   static function uninstall() {