Bug 11145 - creating a guided report in non-english language fails
Summary: creating a guided report in non-english language fails
Alias: None
Product: Koha
Classification: Unclassified
Component: Reports (show other bugs)
Version: 3.12
Hardware: PC Linux
: P5 - low normal (vote)
Assignee: Galen Charlton
QA Contact: Testopia
Depends on:
Reported: 2013-10-27 20:32 UTC by philippe kloos
Modified: 2015-12-03 22:00 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this bug.
Description philippe kloos 2013-10-27 20:32:58 UTC

At our library we use Koha with the Unimarc format, in french.
Since we switched to koha 3.10 we are no longer able to create guided reports : it fails after the second step with message "Unsuported report area "types" at /usr/share/koha/lib/C4/Reports/Guided.pm line 213".

I googled around and found out that the same happens with the spanish version :

I tried with the english interface and it worked.
Comment 1 Katrin Fischer 2013-10-27 20:50:41 UTC
Hi Michel, can you give us the exact version you are using? You can find it on the About page of your installation.
I think this might be a bug, that has been fixed, but it's easier to check when we have more information.
Comment 2 philippe kloos 2013-10-27 22:35:59 UTC
I'm using koha version 3.10.11, perl version 5.14 on a debian wheezy system.
Comment 3 Katrin Fischer 2013-12-05 00:09:28 UTC
Hi Michel,

I have tested this with German and it works for me, I can create Guided reports without problems. I think it might be a problem with the French translation files in 3.10.11 as they won't install correctly for me. 

To check if the bug is fixed in later versions I also tried 3.10.12. French templates install without errors in this version and crating guided reports worked nice. I am closing this bug, please reopen if I missed something.
Comment 4 philippe kloos 2013-12-24 09:11:20 UTC

We couldn't test koha version 3.10.12, since it is not in the repository any more ; but testing version 3.12.07 gives the same error when genrating guided reports :

Software error:

Unsuported report area "types" at /usr/share/koha/lib/C4/Reports/Guided.pm line 215.

Thanks for your help.
Comment 5 Owen Leonard 2014-01-02 18:01:35 UTC
(In reply to michel from comment #4)
> testing version 3.12.07 gives the same error when generating
> guided reports

I have tried generating guided reports in 3.12.x using both French and German templates and have not encountered an error. Please post a detailed description of the steps to reproduce your error.
Comment 6 philippe kloos 2014-01-04 09:58:09 UTC
is that ok if i send you a database via mail ?
Comment 7 Katrin Fischer 2014-01-04 10:31:31 UTC
I think it's unlikely that it's something in your configuration or data cuasing this. Could you give a step by step? Maybe it's something in the translations causing this. Could you check it also happens for you when using another language (maybe German)?
Comment 8 philippe kloos 2014-01-06 16:14:34 UTC
Here are the steps to get the error :

From the "Plus" menu, choose "Bilans et statistiques"
Then choose "assistant de rapports", then "construire nouveau".
Etape 1/6 : choose "Circulation" then "suivant"
Etape 2/6 : choose "Tabulaire" then "suivant"
and here i get "software error..."

Using the german language works fine.
Using koha 3.14 in french also produces the error.

On the other hand, if i try to generate a SQL report nothing happens.
Steps :
From the "Assistant de rapports" page, click "créer à partir de SQL".
Fill in "nom de rapport" and "notes" with "testFR"
Leave "type" as "tabulaire"
Paste a sql report (i pasted the report previously generated with the german interface :
SELECT  borrowers.borrowernumber,biblioitems.biblioitemnumber FROM borrowers LEFT JOIN statistics on (statistics.borrowernumber=borrowers.borrowernumber) LEFT JOIN items on (items.itemnumber = statistics.itemnumber) LEFT JOIN biblioitems on (biblioitems.biblioitemnumber = items.biblioitemnumber) 

Click "enregistrer rapport"

You get the message "votre rapport a été sauvegardé" ("your report was saved").

Click "rapports sauvegardés"

-->> you get the table with the saved reports, but the report you have just created does not appear.
Comment 9 philippe kloos 2014-01-29 17:36:33 UTC

i solved the problem by upgrading to koha 3.14 and rerunning the translation process with the command

  perl translate install fr-FR

i already used this fix to solve problems when upgrading -- but i'm not sure which problems, maybe the "search by keyword" not working anymore.

Maybe reruning the translation(s) automatically when updating could be put in the wish list ?
Comment 10 Katrin Fischer 2014-01-31 21:12:23 UTC
I think 10942 would help with your wish :)
Comment 11 Katrin Fischer 2014-11-29 08:59:59 UTC
we run translations now automatically on update for package installations.