Bug 16775 - install.pl error: BLOB, TEXT, GEOMETRY or JSON column 'defaultvalue' can't have a default value
Summary: install.pl error: BLOB, TEXT, GEOMETRY or JSON column 'defaultvalue' can't ha...
Status: RESOLVED DUPLICATE of bug 16554
Alias: None
Product: Koha
Classification: Unclassified
Component: Installation and upgrade (web-based installer) (show other bugs)
Version: unspecified
Hardware: All Linux
: P5 - low blocker (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-06-20 05:56 UTC by Pallavi Tomar
Modified: 2016-08-14 15:52 UTC (History)
4 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
Stepwise Screen Shots to get to the error (56.83 KB, image/png)
2016-06-21 07:20 UTC, Pallavi Tomar
Details
Stepwise Screen Shots to get to the error (51.62 KB, image/png)
2016-06-21 07:21 UTC, Pallavi Tomar
Details
Stepwise Screen Shots to get to the error (71.60 KB, image/png)
2016-06-21 07:22 UTC, Pallavi Tomar
Details
Stepwise Screen Shots to get to the error (50.68 KB, image/png)
2016-06-21 07:22 UTC, Pallavi Tomar
Details
Stepwise Screen Shots to get to the error (66.15 KB, image/png)
2016-06-21 07:23 UTC, Pallavi Tomar
Details

Note You need to log in before you can comment on or make changes to this bug.
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 ***