[Koha-bugs] [Bug 17306] Update scripts fail with Mysql 5.7

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17306

--- Comment #3 from Rodrigo Santellan <rsantellan at gmail.com> ---
Created attachment 55618
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=55618&action=edit
Changes of update22to30

diff --git a/installer/data/mysql/update22to30.pl
b/installer/data/mysql/update22to30.pl
index f10ace9..f2010e1 100755
--- a/installer/data/mysql/update22to30.pl
+++ b/installer/data/mysql/update22to30.pl
@@ -53,10 +53,10 @@ my $DBversion = "3.00.00.000";
         action_logs     => "(
                         `timestamp` TIMESTAMP NOT NULL ,
                         `user` INT( 11 ) NOT NULL default '0' ,
-                        `module` TEXT default '',
-                        `action` TEXT default '' ,
+                        `module` TEXT default NULL,
+                        `action` TEXT default NULL ,
                         `object` INT(11) NULL ,
-                        `info` TEXT default '' ,
+                        `info` TEXT default NULL ,
                         PRIMARY KEY ( `timestamp` , `user` )
                     )",
         letter        => "(
@@ -132,7 +132,7 @@ my $DBversion = "3.00.00.000";
                     labelid int(11) NOT NULL auto_increment,
                                 batch_id varchar(10) NOT NULL default '1',
                                 itemnumber varchar(100) NOT NULL default '',
-                                timestamp timestamp(14) NOT NULL,
+                                timestamp timestamp NOT NULL,
                                 PRIMARY KEY  (labelid)
                                 )",

@@ -214,7 +214,7 @@ my $DBversion = "3.00.00.000";
     );

     my %requirefields = (
-        subscription => { 'letter' => 'varchar(20) NULL', 'distributedto' =>
'text NULL', 'firstacquidate'=>'date default NULL','irregularity'=>'TEXT NULL
default \'\'','numberpattern'=>'TINYINT(3) NULL default 0', 'callnumber'=>'text
NU
+        subscription => { 'letter' => 'varchar(20) NULL', 'distributedto' =>
'text NULL', 'firstacquidate'=>'date default NULL','irregularity'=>'TEXT NULL
default NULL','numberpattern'=>'TINYINT(3) NULL default 0', 'callnumber'=>'text
NU
         itemtypes => { 'imageurl' => 'varchar(200) NULL'},
         aqbookfund => { 'branchcode' => 'varchar(4) NULL'},
         aqbudget => { 'branchcode' => 'varchar(4) NULL'},

-- 
You are receiving this mail because:
You are watching all bug changes.