Bug 11908 - update22to30.pl falls to create `labels` table
Summary: update22to30.pl falls to create `labels` table
Status: RESOLVED WONTFIX
Alias: None
Product: Koha
Classification: Unclassified
Component: Installation and upgrade (command-line installer) (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal (vote)
Assignee: Indranil Das Gupta
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-03-07 15:30 UTC by Indranil Das Gupta
Modified: 2023-07-09 10:26 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.