Hi, After reading about this module in the Eureka! Science News article I thought I'd give it a try. The module works and I'd like to use it but when I click on a feed item I get the errors below (I have errors write to the screen on my MAMP installation). I got the same errors on a live site using Drupal 5.7, PHP 5.2.6, MySQL 5.0.45. Any suggestions?

  • warning: Invalid argument supplied for foreach() in /Applications/MAMP/htdocs/drupal5/modules/node/node.module on line 521.
  • warning: implode() [function.implode]: Invalid arguments passed in /Applications/MAMP/htdocs/drupal5/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 /Applications/MAMP/htdocs/drupal5/includes/database.mysql.inc on line 172.

Comments

leoleo’s picture

leoleo commented

Me too, when I visit the feeds page.

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 'DISTINCT(node.nid) AS fpnid, count(node.nid) AS num_nodes, feed_parent_node.titl' at line 1 query: SELECT simplefeed_feed_item.fid, feed_parent_node.title, feed_parent_ DISTINCT(node.nid) AS fpnid, count(node.nid) AS num_nodes, feed_parent_node.title AS feed_parent_node_title FROM node node LEFT JOIN simplefeed_feed_item simplefeed_feed_item ON node.vid = simplefeed_feed_item.vid LEFT JOIN node feed_parent_node ON simplefeed_feed_item.fid = feed_parent_node.nid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'forum_access') OR (na.gid = 1 AND na.realm = 'term_access'))) AND ( (node.status = '1') AND (node.type IN ('feed_item')) AND (feed_parent_node.nid IS NOT NULL) ) GROUP BY feed_parent_node.title, feed_parent_node_ti in home/public_html/includes/database.mysql.inc on line 172.

webdrips’s picture

webdrips commented

I received the following message after installing this module:

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 ') /*!40100 DEFAULT CHARACTER SET UTF8 */' at line 11 query: CREATE TABLE simplefeed_feed ( vid int unsigned NOT NULL, nid int unsigned NOT NULL, url text, expires int NOT NULL default '0', refresh int NOT NULL default '0', checked int NOT NULL default '0', hash varchar(32), PRIMARY KEY (vid), KEY nid (nid), ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /mydBdirectory/database.mysql.inc on line 172.

Then when I attempt to create a feed, I receive several warnings:

# user warning: Table 'mytable.simplefeed_feed' doesn't exist query: SELECT nid FROM simplefeed_feed WHERE url = 'http://rss.news.yahoo.com/rss/health' in /mydBPath/database.mysql.inc on line 172.
# user warning: Table 'mytable.simplefeed_feed' doesn't exist query: INSERT INTO simplefeed_feed (vid, nid, url, expires, refresh) VALUES (105, 105, 'http://rss.news.yahoo.com/rss/health', 1209600, 21600) in /mydBPath/database.mysql.inc on line 172.
# user warning: Table 'mytable.simplefeed_feed' doesn't exist query: SELECT url, expires, refresh, checked, hash FROM simplefeed_feed WHERE vid = 105 in /mydBPath/database.mysql.inc on line 172.
# user warning: Table 'mytable.simplefeed_feed' doesn't exist query: SELECT url, expires, refresh, checked, hash FROM simplefeed_feed WHERE vid = 105 in /mydBPath/database.mysql.inc on line 172.
mfer’s picture

mfer commented
Status: Active » Needs work

Here's a patch that fixes #2. It's a start.

mfer’s picture

mfer commented

@jt_jones and @leoleo I can't duplicate your errors. Can you give more detail on how you got it.

mfer’s picture

mfer commented
Status: Needs work » Postponed (maintainer needs more info)

@daneesia - I moved your issue to http://drupal.org/node/269704.

jtjones23’s picture

jtjones23 commented
Version: 5.x-2.0 » 5.x-2.1

Don't know what else I can say...the error messages are over my head. But, I get the same errors with version 5.x-2.1. Also tried an installation on the latest Drupal 5 head but there's no changes to the node module so I get the same errors.

Update: I just did a clean installation with SimpleFeed as the only contributed module. There are no MySQL errors when I click on a feed item. So, I'm guessing there's a conflict with another module but which one?

mfer’s picture

mfer commented
Version: 5.x-2.1 » 5.x-2.2

Trial and error. Keep turning modules on and off until you find the problem module. I'd start with modules you know affect nodes.

Or, you could install the devel module and turn on backtrace for error reporting. That would give you a lot more detail to the error.

jtjones23’s picture

jtjones23 commented

Thanks for the backtrace tip. Image Attach 5.x-1.8 (part of the Image module package) appears to be the culprit. The MySQL errors go away when I disable Image Attach on my MAMP site that has silly amounts of modules enabled.

But, just to be sure I added the Image module to my clean installation (enabled Image, Image Attach & SimpleFeed only) and I did not get any errors so I'm not sure if Image Attach is really the problem.

mfer’s picture

mfer commented

Did you consistently use the same versions?

Andy Galaxy’s picture

Andy Galaxy commented

Regarding post #1. I have this error also. I have too many modules to disable, so I may not be of any help to ascertain what may be bugging Simplefeed.

dmjossel’s picture

dmjossel commented

With Image-Attach 1.9 enabled I get this error:

warning: Invalid argument supplied for foreach() in /usr/local/apache/htdocs/drupal/modules/node/node.module on line 561.
warning: implode() [function.implode]: Bad arguments. in /usr/local/apache/htdocs/drupal/modules/node/node.module on line 565.
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 /usr/local/apache/htdocs/drupal/includes/database.mysql.inc on line 172.

With Image-Attach disabled, the error goes away.

m3avrck’s picture

m3avrck commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

This is not an issue with this module.