[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[EP-tech] Auto complete not working for authors
- Subject: [EP-tech] Auto complete not working for authors
- From: mathieu_perron at uqac.ca (Mathieu Perron)
- Date: Mon, 23 Mar 2015 18:34:23 +0000 (UTC)
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????????
????????