[Koha-bugs] [Bug 39618] Add a non-unique index/key to borrowers table for preferred_name

[bugzilla-daemon--- via Koha-bugs]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39618

Adolfo Rodríguez Taboada <adolfo.rodrig...@xercode.es> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |adolfo.rodrig...@xercode.es

--- Comment #16 from Adolfo Rodríguez Taboada <adolfo.rodrig...@xercode.es> ---
This patch returned the following error in my local instance.

ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: BLOB/TEXT column
'preferred_name' used in key specification without a key length 

The field preferred_name is defined as longtext so I understand the key for 
preferred_name should have a length like the index of middle_name

CREATE INDEX middle_name_idx ON borrowers ( middle_name(768) )

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/