On install there is the 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 ') /*!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 ...

Initially reported by daneesia on issue 262368.

This issue stops the table simplefeed_feed from installing.

Comments

mfer’s picture

mfer commented
Status: Active » Fixed

Fixed in commit http://drupal.org/cvs?commit=120992.

webdrips’s picture

webdrips commented
Status: Fixed » Closed (fixed)

The patch worked.

Andy Galaxy’s picture

Andy Galaxy commented

I'm sorry to say I get this 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 '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 WHERE (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_title ORDER BY feed_parent_node_title ASC LIMIT 0, 10 in /var/www/html/jobs/includes/database.mysql.inc on line 172.

on the views page for simplefeed. I have simplefeed-5.x-2.2 from http://drupal.org/node/270017

g76’s picture

g76 commented

same problem. v5.x.2.2

g76’s picture

g76 commented

upgraded 5.x-3.0

same error on view for feeds