My logs have been filling up lately with errors such as the following:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND (n.type='biblio' )' at line 1 query: SELECT COUNT(DISTINCT(n.nid)) FROM node n left join biblio b on n.vid=b.vid inner join biblio_types bt on b.biblio_type=bt.tid inner join biblio_contributor as bc1 on n.vid = bc1.vid WHERE () AND (n.type='biblio' ) in /var/www/live/drupal/sites/all/modules/biblio/biblio.pages.inc on line 86.
The associated page for this instance would be publications/author/17. I don't think this author ID exists any more; this page must be getting hit by Google's robot or someone's outdated link. At any rate, searching for a non-existent author probably shouldn't generate SQL errors. By the way, I think this only started recently, with the release of one of the betas.
Comments
Comment #1
rjerome commentedThanks for that report,
Your right, it shouldn't generate any errors and now it doesn't, it just reports that no items were found.
Ron.