Bug #81821 MYSQL error in installing KOHA Library system
Submitted: 12 Jun 2016 18:24 Modified: 13 Jun 2016 5:17
Reporter: Prageeth Harshana Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Errors Severity:S2 (Serious)
Version:5.7.12.0ubuntu1 OS:Ubuntu
Assigned to: CPU Architecture:Any

[12 Jun 2016 18:24] Prageeth Harshana 
Description:
When I doing the 'Web Installer' on Koha Library system,

The following error occurred while importing the database structure:

[Sun Jun 12 23:29:23 2016] install.pl: DBD::mysql::st execute failed: BLOB, TEXT, GEOMETRY or JSON column 'defaultvalue' can't have a default value at /usr/share/perl5/DBIx/RunSQL.pm line 273. 

Please help me to fix this error

Regards 
Prageeth

How to repeat:
When I doing the 'Web Installer' on Koha Library system,

The following error occurred while importing the database structure:

[Sun Jun 12 23:29:23 2016] install.pl: DBD::mysql::st execute failed: BLOB, TEXT, GEOMETRY or JSON column 'defaultvalue' can't have a default value at /usr/share/perl5/DBIx/RunSQL.pm line 273. 

Please help me to fix this error

Regards 
Prageeth
[13 Jun 2016 5:17] MySQL Verification Team 
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/refman/5.7/en/blob.html which clearly states that "BLOB and TEXT columns cannot have DEFAULT values.".

The instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php

Imho - must be caused by strict sql_mode but I suggest you to open ticket with Koha bug system to see if there is any workaround or patch available for this.  I see related bug exists - https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16664

Thanks,
Umesh
[26 Nov 2024 12:06] PRATHEESH KUMAR P 
C4::Biblio::GetMarcSubfieldStructure(): DBI Exception: DBD::mysql::db selectall_arrayref failed: Unknown column 'display_order' in 'order clause' at /usr/share/koha/lib/C4/Biblio.pm line 1183
Something went wrong rebuilding biblio indexes for library
C4::Biblio::GetMarcSubfieldStructure(): DBI Exception: DBD::mysql::db selectall_arrayref failed: Unknown column 'display_order' in 'order clause' at /usr/share/koha/lib/C4/Biblio.pm line 1183
Something went wrong rebuilding authority indexes for library