Hi,

I am receiving following error every time when i do operation like 'edit','delete feed items' for particular 'feed' node.

Plz look into screenshot.

I am using

D-6.16
PHP 5.3.0
CCK 6.x-2.6
Filefield 6.x-3.2
Imagefield 6.x-3.2
Feeds 6.x-1.0-alpha12
Feeds Image Grabber 6.x-1.0-beta1

I am trying to fetch feed from http://feeds.feedburner.com/people/stylewatch/offtherack
and generating feed item with cck images.

Thanks in Advance

CommentFileSizeAuthor
1.JPG72.64 KBkuldip zala

Comments

publicmind’s picture

Project: Feeds Image Grabber » Feeds
Version: 6.x-1.0-beta1 » 6.x-1.0-alpha12

I am pretty sure that it has nothing to do with Feeds Image Grabber. I am shifting it to Feeds issue queue.

regards,

alex_b’s picture

Status: Active » Closed (duplicate)
cato’s picture

Version: 6.x-1.0-alpha12 » 6.x-1.0-alpha14

I've been hunting this error for a while now since it appears everytime I edit/import the feed.
The solution is to either quit updating the feed_nid field in DB or to remove it from the index.

mysql> show create table feeds_source\G
*************************** 1. row ***************************
       Table: feeds_source
Create Table: CREATE TABLE `feeds_source` (
  `id` varchar(128) NOT NULL DEFAULT '',
  `feed_nid` int(10) unsigned NOT NULL DEFAULT '0',
  `config` text,
  `source` text NOT NULL,
  `batch` longtext,
  PRIMARY KEY (`id`,`feed_nid`),
  KEY `id` (`id`),
  KEY `feed_nid` (`feed_nid`),
  KEY `id_source` (`id`,`source`(128))
) ENGINE=MyISAM DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

Looking at the mysql log, it's clear that the db handling code for both Feeds and Feeds Image Grabber creates the same error: It tries to update the (unique) key field in the table(s) for no apparant reason.

10 Query	UPDATE feeds_source SET id = 'feed', feed_nid = 203, config = 'a:1:{s:16:\"FeedsHTTPFetcher\";a:1:{s:6:\"source\";s:107:\"http://ax.itunes.apple.com/WebObjects/MZStoreServices.woa/ws/RSS/topfreeapplications/sf=143456/limit=10/xml\";}}', source = 'http://ax.itunes.apple.com/WebObjects/MZStoreServices.woa/ws/RSS/topfreeapplications/sf=143456/limit=10/xml', batch = 'b:0;' WHERE id = 'feed' AND feed_nid = 203

Regards,
Christopher Cato