Rebuild author index?

I suspect the problem may lie in the the fact that the biblio related node information was not deleted from the node_revisions table, since every node has a corresponding entry in the node_revisions table.

Prior to your SQL command above, you should have executed...

DELETE FROM node_revisions 
WHERE node_revisions.nid IN (SELECT n.nid FROM node n WHERE n.type='biblio')

Which would first clear the biblio data out of the node_revisions table.

The only other problem you might encounter with the scenario you describe (deleting nodes but not authors) is if you made and modifications to author names AFTER you imported them the first time. If so, the second import will create a new author, but if you are seeing more additional publications attributed to authors, I still suspect the node_revisions table issue.

Ron.

Yes, that appears to achieve the same result, so there must be a issue elsewhere. Thinking about this a bit more, you would have to empty the biblio_contributor (and biblio_keyword) table prior to reimporting because they both have references to nid's. Also, did you empty the biblio table prior to re-import?

Do you have some "unpublished" biblio nodes? Only the admin would see those.

Hmmm, I'm running out of ideas, here is the SQL that builds that page if that helps...

SELECT bd.cid, bd.drupal_uid, bd.name, bd.lastname,
                              bd.firstname, bd.prefix, bd.suffix, bd.initials,
                              bd.affiliation, bd.md5, COUNT(*) AS cnt
                            FROM {biblio_contributor} b
                                 LEFT JOIN {biblio_contributor_data} bd ON b.cid = bd.cid
                                 LEFT JOIN {node} n on n.vid = b.vid
                                 WHERE n.status = 1
                            GROUP BY bd.cid, bd.drupal_uid, bd.name, bd.lastname,
                                     bd.firstname, bd.prefix, bd.suffix,
                                     bd.initials, bd.affiliation, bd.md5
                            HAVING COUNT(*) > 0
                            ORDER BY  lastname ASC, SUBSTRING(firstname,1,1) ASC,
                            initials ASC

This version is no longer maintained. If this issue is still relevant to the Drupal 7 version, please re-open and provide details.