[Koha-bugs] [Bug 10855] Additional fields for subscriptions

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Wed Jun 24 16:22:36 CEST 2015


http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10855

Nicole C. Engard <nengard at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |nengard at gmail.com

--- Comment #222 from Nicole C. Engard <nengard at gmail.com> ---
There is a problem here - if you query these new tables and some of the old
tables you get an error :


ERROR 1267 (HY000): Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and
(utf8_general_ci,IMPLICIT) for operation '='


Here's the query - we should probably fix the collation on the new table and/or
the old tables.


select s.subscriptionid, b.title 
from serial s 
left join biblio b using (biblionumber) 
left join additional_field_values d on (d.record_id=s.subscriptionid) 
left join authorised_values v on (d.value=v.authorised_value)

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list