Hi,

I found that authors with names beginning with special characters do not appear, when I filter by author.

Obviously the filter relies on a fixed array of characters, which may reflect most requirements for English and American names. A name starting with e.g. İ (capital I with a dot), a common character in Turkish, simply disaeppears in author-sorted listings.

A proper way to fix this would be to build the array of Initials from the author names instead using a fixed one. That would also lead to a cleaner index on top of the list - currently there are links for initials A-Z, even if only some few authors exist and most of these initials lead to empty results.

Cheers, Lars.

Comments

grobe’s picture

grobe commented
Version: 7.x-1.0-beta2 » 7.x-1.0-beta4

Hi,

while I found that the authors get sorted into the more regular characters now (so İ is found under i), I get the following error now when clicking on the initial letters shown on top of the biblio-pages:

PDOException: SQLSTATE[42601]: Syntax error: 7 FEHLER: Syntaxfehler bei »RLIKE« LINE 8: WHERE (substring(('biblio_sort_title'),1 ,1) RLIKE LOWER('G... ^: SELECT COUNT(*) AS expression FROM (SELECT 1 AS expression FROM {node} n LEFT OUTER JOIN {biblio} b ON n.vid=b.vid INNER JOIN {biblio_types} bt ON b.biblio_type=bt.tid WHERE (substring(('biblio_sort_title'),1 ,1) RLIKE LOWER(:letter)) AND (n.language IN (:db_condition_placeholder_0, :db_condition_placeholder_1)) ) subquery; Array ( [:letter] => G [:db_condition_placeholder_0] => en [:db_condition_placeholder_1] => und ) in PagerDefault->execute() (line 74 of /var/www/drupal/drupal-7.7/includes/pager.inc).

Cheers, Lars.

rjerome’s picture

rjerome commented
Status: Active » Fixed

That error was when sorting by title and clicking on one of the "alpha" links at the top of the page.

It has now been fixed.

http://drupalcode.org/project/biblio.git/commit/a79b29d

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.