Hi,

I've just installed Drupal 4.7.3 and NodeReview 4.7.0 (and the requisite Voteing API 4.7.0 and Views 4.7.0). When I visit a node, I see the "Reviews" tab at the top, but clicking on it gives me:

  • warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /home/radiantw/public_html/wificafe/includes/database.mysql.inc on line 349.
  • user warning: Unknown column 'nodereview.parent' in 'where clause'
    query: SELECT count(node.nid) FROM node node LEFT JOIN nodereview nodereview ON node.nid = nodereview.nid WHERE (nodereview.parent AND '') AND (reviewed_nid = '5') AND (nodereview.nid = node.nid) in /home/radiantw/public_html/wificafe/includes/database.mysql.inc on line 120.
  • warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /home/radiantw/public_html/wificafe/includes/database.mysql.inc on line 349.
  • user warning: Unknown column 'nodereview.parent' in 'where clause'
    query: SELECT node.nid FROM node node LEFT JOIN nodereview nodereview ON node.nid = nodereview.nid WHERE (nodereview.parent AND '') AND (reviewed_nid = '5') AND (nodereview.nid = node.nid) ORDER BY node.changed DESC LIMIT 0, 10 in /home/radiantw/public_html/wificafe/includes/database.mysql.inc on line 120.

I saw a previous issue about this, but it says the code has been updated and the issue is resolved. Help? :)

--Ian

Comments

Crell’s picture

Crell commented
Assigned: Unassigned » Crell
Status: Active » Fixed

Yeah, I'd checked in the CVS version but not the 4.7 version by accident. Sorry about that. I just fixed the 4.7 version, which should be updated whenever the tarball is updated next, which shouldn't be more than a day. Otherwise the version currently marked CVS should already be fixed. (The two should be identical at the moment.)

Cheers.

IanCabell’s picture

IanCabell commented

I downloaded the CVS version (though the tarball seems to have been updated this morning) and it worked like a charm. Thanks much! --Ian

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)