Bug 39683

Summary: suggestion.copyrightdate and suggestion.publicationyear
Product: Koha Reporter: Andrew Fuerste-Henry <andrew>
Component: DatabaseAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low    
Version: Main   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Andrew Fuerste-Henry 2025-04-18 20:03:44 UTC
The suggestions form in the user interface contains a field labeled "Copyright date." It gets saved in the database in suggestions.copyrightdate.

The database also contains the field suggestions.publicationyear. As far as I can tell, there is no way in the staff interface or OPAC to put a value in this field (though if one were to get a value into it, that value would show on /cgi-bin/koha/suggestion/suggestion.pl).

It would probably make sense to just remove suggestions.publicationyear from the database. But at the same time copyrightdate and publication date are really two distinct values ....

I'm mostly filing this bug for the next person to stumbles into this hole and wonders what that field's about. Hello, future person!
Comment 1 Katrin Fischer 2025-04-18 20:10:22 UTC
It's a bit more complicated. For historical reasons UNIMARC maps the publication year to publicationyear, while MARC21 has always been using copyrightdate. It's not easy to fix in existing databases where people can have changed the mappings, so we have a number of places in the code where we look at both dependent of the MARC flavor.
Comment 2 Katrin Fischer 2025-04-18 20:11:02 UTC
Hm, and now I realize we are talking about the suggestions table and not biblio/biblioitems... in that case maybe it can be fixed?