[EP-tech] Auto complete not working for authors

[Mathieu Perron]

Hi all,

I've just upgraded our ePrints repository from 3.2.7 to 3.3.13 and I'm 
trying to fix all the bugs I can find.  Before the upgrade, the auto 
complete never worked in the deposit workflow but now it's working just 
fine for the title of the document but not for the rest of the fields 
(author, etc.).  And when I look at the apache log, I see a lot of 
errors like this one :

SQL ERROR (execute): SELECT COUNT(`eprint`.`eprintid`)  AS  
`num_matches`,`creators_name_family`,`creators_name_given`,`creators_nam
e_lineage`,`creators_name_honourific`,`creators_id` FROM `eprint` LEFT 
JOIN `eprint_creators_name` ON 
`eprint`.`eprintid`=`eprint_creators_name`.`eprintid` LEFT JOIN 
`eprint_creators_id` ON 
`eprint_creators_name`.`eprintid`=`eprint_creators_id`.`eprintid`  AND 
`eprint_creators_name`.`pos`=`eprint_creators_id`.`pos`  WHERE  
`eprint`.`eprint_status`='archive' AND `creators_name_family` COLLATE 
utf8_general_ci LIKE 'Perron%' AND `creators_name_given` COLLATE 
utf8_general_ci LIKE 'Mathieu%'GROUP BY 
`creators_name_family`,`creators_name_given`,`creators_name_lineage`,`cr
eators_name_honourific`,`creators_id` ORDER BY `num_matches` 
DESC,`creators_name_family`,`creators_name_given`
SQL ERROR (execute): COLLATION 'utf8_general_ci' is not valid for 
CHARACTER SET 'latin1'
DBD::mysql::st fetchrow_array failed: fetch() without execute() at 
/eprints3/cgi/users/lookup/name line 61.
DBD::mysql::st execute failed: COLLATION 'utf8_general_ci' is not valid 
for CHARACTER SET 'latin1' at /eprints3/peÿɱ}±¥ˆ½AÉ¥¹Ñ̽…Ñ…‰…Í”¹Á´€)±¥¹”€ÌÈÄĸ()!½Ü…¸$É•Í½±Ù”Ñ¡½Í”•ÉɽÉÌü€¼$¡…Ù”Ñ¼¡…¹”Ñ¡”‘•™…ձЀ)•¹½‘¥¹œ™½ÈÑ¡”‘…Ñ…‰…Í”…¹Ñ¡•¸¡…¹”Ñ¡”•¹½‘¥¹œ™½È…±°½±Õµ¹Ì¸€€)$…±Í¼É•…±¥é•Ñ¡…Ёѡ•É”…É”Í½µ”½±Õµ¹ÌÍ•ÐÑ¼±…Ñ¥¸Ä…¹Í½µ”Ñ¼€)ÕÑ˜à¥¸Ñ¡”Í…µ”Ñ…‰±”€¡”¹œ¸èÑ…‰±”•ÁÉ¥¹Ð¤¸€%́ѡ¥Ì½¬ü()Q¡…¹¬å½Ô™½Èå½ÕȁµÕ …ÁÁÉ•¥…Ñ•¡•±À„()5…Ñ¡¥•ÔA•Éɽ¸)%PQ•¡¹¥¥…¸)	¥‰±¥½Ñ£¡ÅÕ”A…Õ°·%µ¥±”µ	½Õ±•Ð)U¹¥Ù•ÉÍ¥Ó¤‘ԁE×¥‰•Œƒ€
¡¥½ÕÑ¥µ