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: [email protected]
          Reporter: [email protected]
        QA Contact: [email protected]

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.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to