I experience this both with 6.x-1.10 and 6.x-1.x-dev (27 of January download) with Drupal 6.15 (imported 399 references from Endnote X3).

There seems to exist some problem with the sorting of the database by using the "author" criteria.

For instance with ?sort=author&order=asc I get this (an author with "P" is appears amongst authors with "A"):

A
Ackermann, E. (2001).  Piaget's constructivism, Papert's constructionism: What's the difference?. Future of learning group publication.
Adorno, Theodor, & Stephen Crook (2002).  Adorno : the stars down to earth and other essays on the irrational in culture. Routledge classics. vi, 239 p..
Al-khamayseh, Shadi, Agnieszka Zmijewska, Elaine Lawrence, & Gordana Culjak (2007).  Mobile learning systems for digital natives. Proceedings of the sixth conference on IASTED International Conference Web-Based Education. 2,

P
Postman, Neil (2007).  O Fim da Educação. Redefinindo o valor da escola..

A
Alexander, Bryan (2004).  Going Nomadic: Mobile Learning in Higher Education. EDUCAUSE Review. 39, 28-35.

If I click the name of the P author I get (the same key/entry appears 2 times and although "Export" correctly states "2 results" If I export the resulting files has a repeated entry)
biblio/author/445?sort=author&order=asc:

Postman, Neil (2007).  O Fim da Educação. Redefinindo o valor da escola..
Postman, Neil (1993).  Technopoly : the surrender of culture to technology. xii, 222 p..
Postman, Neil (2007).  O Fim da Educação. Redefinindo o valor da escola.

.

But when I sort the reults by "year", "title" or "type" I instantaneously get it right (biblio/author/445?sort=year&order=asc), e.g.:

1993
Postman, Neil (1993).  Technopoly : the surrender of culture to technology. xii, 222 p..

2007
Postman, Neil (2007).  O Fim da Educação. Redefinindo o valor da escola.

So the issue seems restricted to sorting by "author" alone. Any ideas on what may cause this?

Thanks

Comments

rjerome’s picture

Check /biblio/authors/445/edit/ and see if that author is "Linked" to any other.

rjerome’s picture

Could your issue be the same as this... #698016: Biblio mixes author sort order when editor fields are populated? i.e. is author 445 marked as an editor on one of the papers?

hvalentim’s picture

a) No. I have no "linked authors". This issue happens not just with 455 but with a few btw.
b) No. The problematic author 445 is not marked as "editor" anywhere and has no marked "editors", but the "translator" of the misplaced entry does have an "A" surname which may explain it. I did also find an example where the "editor" surname was given priority over the author in "sort by author".

It seems both "translator" and "editor" surnames (family names) are taken into account/included too when sorting the books by "author". So, while filtering, the books can at times occur twice (or more I guess): one for the author and another for the editor, translator etc. I would rather see them appear just once using the "Author" field and disregarding anything else.

rjerome’s picture

Ok, I think this is the same issue as #698016: Biblio mixes author sort order when editor fields are populated, then. I guess what I should have ask is: are any of the contributors not "Primary" authors, to which the answer it appears is Yes. I'm working on a fix for this.

rjerome’s picture

If you would like to test the fix, could you just replace line 162 in biblio.pages.inc (which is currently commented (//) out) with the following...


      $where['bc-auth-category'] = "bc.auth_category IN (1,5)";

hvalentim’s picture

At first sight your fix does seem to work (applied to your dev from today). Thanks a lot!

monodont’s picture

many thanks rjerome, this seems to be working properly now for the "Editor" issue as well.

rjerome’s picture

Status: Active » Fixed

Committed to DRUPAL-6--1 and DRUPAL-6--2

Status: Fixed » Closed (fixed)

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

fergusong’s picture

I had the same problem, I applied the fix and it solved the problem for most of our entries. One entry did not sort properly even with the fix and I suspect the problem has to do with the Corporate Author field. Some details follow.

The misplaced entry has a 'Corporate Author'. When I request an author sort the position of this entry reflects the Corporate Author. In this case the Corporate Author is 'Committee, Dharmachakra Translation' and it sorted as a C. The first author is 'Lingpa, Jigme' so I expected it to appear in the L's. The display of the list apparently expected the same. I.E. the C sequence is broken by an L sequence with this one entry, followed by another C sequence.

Gordon