Bug 18724

Summary: Upload cover image failed without error message
Product: Koha Reporter: Sebastian Krieg <sebastian.krieg>
Component: ToolsAssignee: Galen Charlton <gmcharlt>
Status: CLOSED WONTFIX QA Contact: Testopia <testopia>
Severity: minor    
Priority: P5 - low CC: jonathan.druart
Version: 16.11   
Hardware: All   
OS: Linux   
GIT URL: Initiative type: ---
Sponsorship status: --- Comma delimited list of Sponsors:
Crowdfunding goal: 0 Crowdfunding committed: 0
Crowdfunding contact: Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Attachments: koha-error.log: error messages with description of related steps to upload cover image

Description Sebastian Krieg 2017-06-03 20:06:16 UTC
Created attachment 63948 [details]
koha-error.log: error messages with description of related steps to upload cover image

Uploading a cover image failed without an error in UI, error message "no cover image available" is shown in the catalogue entries.

There are error messages in koha-error.log but this messages are shown for every step (see the described steps in attachment):
- open the administration site
- go to "tools|catalogue|upload cover images"
- upload a cover image

This error a duplicate with every try uploading a cover image.
Comment 1 Sebastian Krieg 2017-06-04 08:23:33 UTC
Additional system informations:

Koha-Version: 16.11.06.000
OS Version: Linux 4.11.3-200.fc25.x86_64
Perl-Version: 5.024001
MySQL-Version: mysql Ver 15.1 Distrib 10.1.21-MariaDB, for Linux (x86_64) using readline 5.1
Comment 2 Jonathan Druart 2017-09-27 18:49:55 UTC
Could you confirm this is still valid?
It certainly because the connection to the DBMS was lost.
Comment 3 Sebastian Krieg 2017-09-29 18:17:10 UTC
This is still valid. 

The error message confirm the lost of communication between DBMS and application. But I didn't find any reason why.
Comment 4 Jonathan Druart 2017-10-02 13:37:01 UTC
You should take a look at https://dev.mysql.com/doc/refman/5.7/en/gone-away.html
Comment 5 Sebastian Krieg 2018-04-08 08:58:25 UTC
I solved this issue by reinstallation of the mysql server. The reason of this bug I cant't describe, this should be a problem of filesystem permissions. I think, the cover file will temporarily uploaded into an file system and imported by mysql into the database. When there's a problem with the access to the cover file per mysql, mysql can't import the file into the database. But, I don't know, there's a temporary place during the file upload and where is it?

Ergo: After reinstallation of mysql the cover file upload works fine.