[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