I was getting this error on a when trying to sort my views with an alpha pager on a live site, so I went ahead and installed a fresh version of drupal 5.1 with the latest views (1.6-beta4) and views alpha pager (1.x.dev) modules on my localhost and I'm still getting the same error:
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 ''') ORDER BY left(trim(LEADING 'and ' FROM (trim(LEADING 'the ' FROM (trim(LEAD' at line 1 query: SELECT DISTINCT left(trim(LEADING 'and ' FROM (trim(LEADING 'the ' FROM (trim(LEADING 'a ' FROM (trim(LEADING '\'' FROM (trim(LEADING '"' FROM (trim(LEADING ' ' FROM (upper(node.title))))))))))))), 1) FROM node node WHERE (. '') ORDER BY left(trim(LEADING 'and ' FROM (trim(LEADING 'the ' FROM (trim(LEADING 'a ' FROM (trim(LEADING '\'' FROM (trim(LEADING '"' FROM (trim(LEADING ' ' FROM (upper(node.title))))))))))))), 1) in C:\www\xampp\htdocs\testdru\includes\database.mysql.inc on line 172.
Comments
Comment #1
bsuttis commentedThis is fixed with the patch here: http://drupal.org/node/140969
Comment #2
douggreen commented