I think that this is to do with nodereference.module because of the error report but I'm not sure.

  • I have created a content type with a nodereference field (noderefence.module is patched with KarenS's latest patch: http://drupal.org/node/60756).
  • I then create a blog entry (but the error occurs on CCK nodetypes too) and preview it without submitting it
  • I get the following 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 '' at line 1 query: SELECT nref.vid, n.* FROM node_content_transaction nref INNER JOIN node n ON nref.vid = n.nid WHERE field_relevant_project_nid= in /path-to-html-directory/htdocs/includes/database.mysql.inc on line 120.
  • I can submit the node as usual.

Comments

karens’s picture

karens commented
Status: Active » Fixed

I think the new patch by David in http://drupal.org/node/60756 fixes this problem. If not, why don't you report it in that thread so he can address it.

talltim’s picture

talltim commented

Ok, will do - thanks :).

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)
lekei’s picture

lekei commented
Version: » 4.7.x-1.x-dev
Priority: Normal » Critical
Status: Closed (fixed) » Closed (duplicate)

This bug is not fixed. It is a duplicate of http://drupal.org/node/60271 which still exists.