Bug 21496 - install.pl: DBD::mysql::st execute failed: Index column size too large. The maximum column size is 767 bytes. at /usr/share/perl5/DBIx/RunSQL.pm line 273.
Summary: install.pl: DBD::mysql::st execute failed: Index column size too large. The m...
Status: RESOLVED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: 18.05
Hardware: All Linux
: P5 - low normal (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-10-05 11:24 UTC by migraciones
Modified: 2023-10-07 23:03 UTC (History)
3 users (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 migraciones 2018-10-05 11:24:06 UTC
Hi,

I found the next error when I am installing Koha

install.pl: DBD::mysql::st execute failed: Index column size too large. The maximum column size is 767 bytes. at /usr/share/perl5/DBIx/RunSQL.pm line 273.

The opertive system is Debian 8
Database is 10.0.32-MariaDB-0+deb8u1
Koha version is Koha 18.05

I need help please

Thank you
Comment 1 Martin Renvoize 2018-10-31 15:31:12 UTC
Hmm, 

I'm running 10.1.26-MariaDB and can't replicate this locally.. anyone happens to be running the same MariaDB version out there?
Comment 2 Jonathan Druart 2018-10-31 15:42:41 UTC
Can you upgrade your mariadb-client package, the latest version for jessie is 10.0.36. Then try again.
Comment 3 Jonathan Druart 2019-06-22 23:56:06 UTC
Closing, please reopen if still valid.
Comment 4 Jorge Rodriguez 2019-11-07 22:39:57 UTC
 install.pl: DBD::mysql::st execute failed: Table 'koha_library.audio_alerts' doesn't exist at /usr/share/perl5/DBIx/RunSQL.pm line 273. I have Ubuntu 18.04 lts y Koha Estable 19.05
Comment 5 Jonathan Druart 2019-11-12 08:40:33 UTC
(In reply to Jorge Rodriguez from comment #4)
>  install.pl: DBD::mysql::st execute failed: Table
> 'koha_library.audio_alerts' doesn't exist at /usr/share/perl5/DBIx/RunSQL.pm
> line 273. I have Ubuntu 18.04 lts y Koha Estable 19.05

This is a different bug. You need to install MariaDB instead of MySQL, or wait for bug 23579 to be part of 19.05.x (it's pushed but not released and packaged yet).
Comment 6 Katrin Fischer 2023-10-07 23:03:19 UTC
(In reply to Jonathan Druart from comment #3)
> Closing, please reopen if still valid.