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

--- Comment #59 from David Gustafsson <[email protected]> ---
(In reply to Phil Ringnalda from comment #57)
> Fails for me in koha-testing-docker startup, with
> 
> koha_1       | C4::Installer::load_sql returned the following errors while
> attempting to load
> /kohadevbox/koha/installer/data/mysql/mandatory/sysprefs.sql:
> koha_1       | DBD::mysql::st execute failed: Data too long for column
> 'type' at row 588 at /usr/share/perl5/DBIx/RunSQL.pm line 278, <$args{...}>
> line 1.
> koha_1       | Something went wrong loading file
> /kohadevbox/koha/installer/data/mysql/mandatory/sysprefs.sql ([SQL ERROR]:
> INSERT INTO systempreferences ( `variable`, `value`, `options`,
> `explanation`, `type` ) VALUES
> 
> Looks like at 22 characters, modification-templates doesn't quite fit in a
> 20 character column.

That column has length 50 for me, and also in kohastructure.sql. Don't know if
you created this table using a different version of Koha. If this can be
reproduced will address the issue.

Some things in the patch needed adjustment after changing to using template ids
instead of name. There is a problem with Elasticsearch in my devbox for recent
version of Koha which had not had time to fix, so was not able to properly test
the code. Meanwhile submitting and hoping for the best, will get back to
properly testing this once this issue has been sorted out.

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://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