When I click the 'next' button on the pager within the node browser, I get the following errors:

    * 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 ''admissions_processing','b4_pane','bpm_policy',&#0' at line 4 query: SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid FROM node node INNER JOIN users users ON node.uid = users.uid WHERE node.type IN ('admissions_processing','b4_pane','bpm_policy','bpmtags','business_processes','counseling','financial_aid_home_office','financial_aid_processing','iss_reports','icon','icon_category','simplenews','onestop_tabs','panel','private_shared','productivity','project','registrar','related','saas_training','shared','student_services','technology','public_page') ) count_alias in D:\WWW\sites\all\modules\views\includes\view.inc on line 745.
    * 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 ''admissions_processing','b4_pane','bpm_policy',&#0' at line 10 query: SELECT DISTINCT node.nid AS nid, node.title AS node_title, node.type AS node_type, node.changed AS node_changed, users.name AS users_name, users.uid AS users_uid, node.status AS node_status FROM node node INNER JOIN users users ON node.uid = users.uid WHERE node.type IN ('admissions_processing','b4_pane','bpm_policy','bpmtags','business_processes','counseling','financial_aid_home_office','financial_aid_processing','iss_reports','icon','icon_category','simplenews','onestop_tabs','panel','private_shared','productivity','project','registrar','related','saas_training','shared','student_services','technology','public_page') ORDER BY node_changed DESC LIMIT 0, 6 in D:\WWW\sites\all\modules\views\includes\view.inc on line 771.

It says there is an error in the SQL syntax. It appears to be the ' characters, which should show up as apostrophes. I replaced each ' with an apostrophe and ran it through an SQL checker, and it checked out fine. Does anybody know what could be causing this issue?

Comments

andylhansen’s picture

It replaced the '& # 0 3 9 ;' (without spaces) code I typed in my issue description with an an actual apostrophe.

gnindl’s picture

Status: Active » Fixed

Fixed.

There's a problem in the NRE Views rewrite function. Changes have been committed to the repository:

http://drupal.org/cvs?commit=503190

http://drupalcode.org/viewvc/drupal/contributions/modules/nodereference_...

Status: Fixed » Closed (fixed)

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