I receive this error message when I open up the filter tab:

user warning: 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 'DESC LIMIT 0, 10' at line 8 query: SELECT biblio.vid AS biblio_vid, biblio_type AS biblio_tid, biblio.biblio_year AS biblio_biblio_year, title, nid, created FROM biblio biblio ORDER BY DESC LIMIT 0, 10 in /var/www/html/sites/all/modules/views/includes/view.inc on line 755.

Comments

rjerome’s picture

rjerome commented

Hi Sarah,

I'm not entirely clear on what you are doing (referring to). Which tab are you referring to when you say the "filter tab"? It appears that there is a missing Sort field in your view "FROM biblio biblio ORDER BY ^^^^^^ DESC LIMIT 0, 10" There should be something after ORDER BY and before DESC.

aren cambre’s picture

aren cambre commented

[Deleting this message because it actually had nothing to do with Bibliography Module.]

aren cambre’s picture

aren cambre commented
Project: Bibliography Module » Views (for Drupal 7)
Version: 6.x-1.5 » 6.x-2.6

This is a views bug, BTW.

aren cambre’s picture

aren cambre commented
Project: Views (for Drupal 7) » Bibliography Module
Version: 6.x-2.6 » 6.x-1.5

Disregard. Probably not a Views bug. Reverting.

scarer’s picture

scarer commented

hey rjerome,

it was when i tried to view the filter tab on the biblio pages - i.e.the drop-down fields for sorting that enable you to filter your search results.

scarer’s picture

scarer commented

i downloaded the dev version and the problem seems to be fixed :)

scarer’s picture

scarer commented
Status: Active » Fixed
rjerome’s picture

rjerome commented

OK, great, I love those problems that just fix themselves :-) I honestly don't know what changed to resolve the issue, but as long as it's not an issue any more, that's all that matters.

Ron.

Status: Fixed » Closed (fixed)

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