Bug 16775

Summary: install.pl error: BLOB, TEXT, GEOMETRY or JSON column 'defaultvalue' can't have a default value
Product: Koha Reporter: Pallavi Tomar <pallavi.tomar>
Component: Installation and upgrade (web-based installer)Assignee: Bugs List <koha-bugs>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: blocker    
Priority: P5 - low CC: gmcharlt, mtompset, pallavi.tomar
Version: unspecified   
Hardware: All   
OS: Linux   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Attachments: Stepwise Screen Shots to get to the error
Stepwise Screen Shots to get to the error
Stepwise Screen Shots to get to the error
Stepwise Screen Shots to get to the error
Stepwise Screen Shots to get to the error

Description Pallavi Tomar 2016-06-20 05:56:30 UTC
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
Comment 1 Katrin Fischer 2016-06-20 06:20:02 UTC
Hi,

can you please add a bit more information on how to reproduce the error?
Which page (URL) shows the error? Which steps lead to it?
Comment 2 Pallavi Tomar 2016-06-21 07:10:35 UTC
Dear Katrin

I installed Koha on Ubuntu 16.04 following instructions as per the link below

http://kohageek.pbworks.com/w/page/61133887/koha-installation-ubuntu-packages

As mentioned in the last step we have to Open following link in a broswer and proceed with post installation configurations,

 http://127.0.1.1:8080

I get this error after web installer step 3
Comment 3 Pallavi Tomar 2016-06-21 07:20:40 UTC
Created attachment 52629 [details]
Stepwise Screen Shots to get to the error
Comment 4 Pallavi Tomar 2016-06-21 07:21:33 UTC
Created attachment 52630 [details]
Stepwise Screen Shots to get to the error
Comment 5 Pallavi Tomar 2016-06-21 07:22:08 UTC
Created attachment 52631 [details]
Stepwise Screen Shots to get to the error
Comment 6 Pallavi Tomar 2016-06-21 07:22:58 UTC
Created attachment 52632 [details]
Stepwise Screen Shots to get to the error
Comment 7 Pallavi Tomar 2016-06-21 07:23:22 UTC
Created attachment 52633 [details]
Stepwise Screen Shots to get to the error
Comment 8 Katrin Fischer 2016-06-21 11:10:26 UTC
Thx for updating the bug! 

Which version of MySQL are you using? I assume that is the problem since the newest Koha is known not to work with new versions of MySQL as included in Ubuntu 16.04 yet.

There is a work done to resolve this problem, see:
bug 16573, bug 16554, bug 16664
Comment 9 Pallavi Tomar 2016-06-23 06:15:08 UTC
mysql server version is 5.7.12

(In reply to Katrin Fischer from comment #8)
> Thx for updating the bug! 
> 
> Which version of MySQL are you using? I assume that is the problem since the
> newest Koha is known not to work with new versions of MySQL as included in
> Ubuntu 16.04 yet.
> 
> There is a work done to resolve this problem, see:
> bug 16573, bug 16554, bug 16664
Comment 10 Mark Tompsett 2016-08-14 15:52:17 UTC
Katrin's comments (comment #8) are correct. Those issues are solved by those bug patches. Marking as duplicate.

*** This bug has been marked as a duplicate of bug 16554 ***