hi - i installed the module - now when someone comments, the following shows up:
warning: Invalid argument supplied for foreach() in /home/centerne/public_html/modules/node/node.module on line 521.
warning: implode() [function.implode]: Bad arguments. in /home/centerne/public_html/modules/node/node.module on line 525.
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 n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in /home/centerne/public_html/includes/database.mysql.inc on line 172.

Please advise. Thanks!

Comments

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented
Status: Active » Postponed (maintainer needs more info)

I can't reproduce this bug. Are you sure it was cased by comment notify module?

dennys’s picture

dennys commented

I got the same problem too, you can try Drupal 5.5 + subscription 2.0beta7 and you should get the problem.

nealtz’s picture

nealtz commented

I got the same problem too, from Drupal Version 5.2 to 5.5. I now use Comment Notify Version 5.x-1.3. When i deactivate the module no errors appear.

I now it is a long list, but maybe it helps ... my modules:

Drupal Administration Menu 5.x-2.1
Akismet 5.x-1.3
Auto locale import 5.x-1.x-dev (2007-Okt-14)
BUEditor 5.x-1.0
CAPTCHA 5.x-3.1
Comment Notify 5.x-1.3
Re: Comment subjects 5.x-1.2
Content Templates (Contemplate) 5.x-1.8
Read More Tweak 5.x-1.2
FeedBurner 5.x-0.5
GeSHi Filter for syntax highlighting 5.x-2.2
Global Redirect 5.x-1.2
Image 5.x-1.6
IMCE 5.x-1.0
Image Assist 5.x-1.5
Node style 5.x-2.1
Meta tags 5.x-1.5
Notify 5.x-1.x-dev (2007-Dez-16)
Page title 5.x-2.0-alpha3
Panels 5.x-1.2
Path Redirect 5.x-1.1
Pathauto 5.x-2.0
Related links 5.x-1.0
Sections 5.x-1.1
Site map 5.x-1.1
Smileys 5.x-1.2-beta
Tagadelic 5.x-1.x-dev (2007-Dez-08)
Taxonomy Manager 5.x-1.0
Theme Settings API 5.x-2.6
Token 5.x-1.9
TrackBack 5.x-1.4
Update status 5.x-2.0
Views 5.x-1.6
XML Sitemap 5.x-1.4

btw: The errors appear also, when i edit an existing comment. Beside the naughty error massages i realized no bad affect to the functionality of drupal.

I already tried to disabled following modules to see if it had an effect to the errors with no result: Notify, XML Sitemap, Views, Re: Comment subjects

Update: I'm a little bit confused. I found the other thread "PHP error when submitting comment". Somebody posted a patch for the module and greggles wrote this was applied to the new module version 1.1.4.3. In my Version 1.1.4.3 Version of "comment_notify.module" line 340 and following looks like this:

    $languages = locale_supported_languages();
    $languages = $languages['name'];
  }
    $nid = $comment->nid;
    $cid = $comment->cid;
    $commname= $comment->name;
    $commtext= $comment->comment;
    $commsubj= $comment->subject;

After i altered these lines to the solution from michal.cihar, everything worked fine and no error messages show up anymore:

    $languages = locale_supported_languages();
    $languages = $languages['name'];
  }
    $nid = $comment[nid];
    $cid = $comment[cid];
    $commname= $comment[name];
    $commtext= $comment[comment];
    $commsubj= $comment[subject];
junyor’s picture

junyor commented

Duplicate of http://drupal.org/node/191313.

It seems greggles was a bit confused, as 1.1.4.3 *introduced* the problem rather than fixed it.

junyor’s picture

junyor commented
Status: Postponed (maintainer needs more info) » Closed (duplicate)