http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11908 Bug ID: 11908 Summary: update22to30.pl falls to create `labels` table Change sponsored?: --- Product: Koha Version: 3.14 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Installation and upgrade (command-line installer) Assignee: gmcharlt@gmail.com Reporter: indradg@gmail.com QA Contact: testopia@bugs.koha-community.org Due to specifying 14 as the width of the datatype TIMESTAMP, the table creation fails with the following output: Adding labels table... DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL,PRIMARY KEY (labelid)' at line 5 at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/update22to30.pl line 3165. Error : DBI::st=HASH(0x2640c40)->errstr ------------- Additional Info: Encountered while moving a Koha 2.2.5 db to 3.14 and MySQL 4.1.11 to MySQL 5.5.35-0+wheezy1 -- You are receiving this mail because: You are watching all bug changes.