Bug 11908

Summary: update22to30.pl falls to create `labels` table
Product: Koha Reporter: Indranil Das Gupta <indradg>
Component: Installation and upgrade (command-line installer)Assignee: Indranil Das Gupta <indradg>
Status: RESOLVED WONTFIX QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: indradg
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

Description Indranil Das Gupta 2014-03-07 15:30:42 UTC
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
Comment 1 Owen Leonard 2019-03-07 19:50:50 UTC
Can this bug be closed?
Comment 2 Katrin Fischer 2023-07-09 10:26:04 UTC
(In reply to Owen Leonard from comment #1)
> Can this bug be closed?

Another 4 years later... I believe so.