Hi,

For some reason whenever someone views one of the posts in our site three error messages come up in the watchdog that say:

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.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE in /homepages/1/d132351061/htdocs/drupal/includes/database.mysql.inc on line 66.

Invalid argument supplied for foreach() in /homepages/1/d132351061/htdocs/drupal/modules/node.module on line 358.

Invalid argument supplied for foreach() in /homepages/1/d132351061/htdocs/drupal/modules/node.module on line 358.

I tried re uploading node.module but it didnt work. Please someone help!

Comments

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented

Perhaps this issue is related to this other "Node words" issue:

http://drupal.org/node/29739

They seemed to have fixed that guys problem - perhaps it can help you as well.

If not, can you tell us

1. Which modules you have installed?
2. What the "options" are for that node (published, moderation, etc.)

Thanks

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented

Marked http://drupal.org/node/48957 as a duplicate of this issue.

Mildo - (who submitted that bug) can you please reply on this bug with the options that you have selected on the node in question (e.g. "published" or "in moderation queue")?

Mildo’s picture

Mildo commented

All the nodes are "published". I will close the new issue I opened and follow this instead. Thanks.

greggo’s picture

greggo commented
Version: 4.6.5 » 4.7.0-rc1

Has there been any resolution to this issue? I am experiencing the same problem but cannot find any answers on posts relating to it. I do not have Node Words installed.

warning: Invalid argument supplied for foreach() in /home/paul/public_html/modules/node.module on line 356.

warning: implode() [function.implode]: Bad arguments. in /home/paul/public_html/modules/node.module on line 361.

user error: 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.*, u.uid, u.name, u.picture, u.data FROM cs_node n INNER JOIN cs_users u ON u.uid = n.uid WHERE in /home/paul/public_html/includes/database.mysql.inc on line 66.

druppy’s picture

druppy commented

I confirm this problem with a new installation of Drupal 4.6.6, and I do not have the 'node words' module installed.

It is typical of Drupal web site to have issues go unresolved (and even closed) for many many months.

When a problem is persisting, then the issue is just closed and no one makes replies to offer help.

Anonymous’s picture

Anonymous (not verified) commented

I cannot reproduce this (tried on a fresh 4.6.6 install). I created a node, clicked on it to view it, went to the logs and there was nothing.

If this is still a problem, please tell us how we can reproduce it. Create a fresh install, without installing or enabling any modules, then try to duplicate the bug. Post results here.

killes@www.drop.org’s picture

killes@www.drop.org commented
Version: 4.7.0-rc1 » 4.7.0
Status: Active » Closed (won't fix)

Some contributed module is returning improper data. Disable contrib module untill you find it. Marking won't fix.