After updating drupal to 4.7 rc3, everytime I run cron (which refreshes the feeds) I get:
Duplicate entry '369-563' for key 1 query: INSERT INTO term_node (nid, tid) VALUES (563, 369) in httpdocs/includes/database.mysql.inc on line 120.
The values change depending on the feed.
Anyone else experiencing this? Or know how to fix it?
| Comment | File | Size | Author |
|---|---|---|---|
| #6 | agg2.patch | 682 bytes | Steve Dondley |
Comments
Comment #1
hadishon commentedUpgrading to drupal CVS head seems to fix the problem.
Comment #2
hadishon commentedWell I thought it was fixed until aggregator2 syndicated more rss content and then I got these error messages again.
Is this a problem with aggregator2.module? I don't get these error messages any other time.
Comment #3
zis commentedI had the same problem It seems that for some reason, after the update, taxonomy vocabularies are not associated with feeds and items anymore.
To solve the problem, edit the feed and item vocabularies and associate them with the node types.
It worked for me.
Comment #4
zis commentedSorry.
It was a false positive. Today after almost a week of it working fine. the errors started appearing again.
I'll look into it.
Comment #5
zis commentedI think i got the issue cornered, but i need some help to fix it.
The error is apearing on every item update. That is an item that already exists and is updated. An error apears for every taxonomy term associated with this item.
I think its got to do with the hook_update implementation not checking for revisions or smthg. Here's the code:
in the drupal api, the implementation of hook update, is different:
here's the revision page of the handbook: http://drupal.org/node/30030
Comment #6
Steve Dondley commentedI think this should fix it.
Comment #7
redraven commentedApplied patch and it resolves this issue
+1 to commiting upon further review
Comment #8
zis commentedWorked for me. +1 to commiting
Comment #9
dalinworks for me
+1 for commiting
Comment #10
peterdeitz commentedHi all, I have installed the "patch" and run the upgrade.php script on my copy of Drupal. Despite these efforts, i'm still getting the "duplicate entry" error message. Do I have to empty drupal's chache of module information? Please advise. --Peter
Comment #11
jarea commentedI am getting the same error, but running Leech in 5.1.
I added two values to the News Feeds taxonomy field and it generated one message for each RSS article node that I had online.
It appears that both terms were added to the category list, but only the second term was added to the individual node tags.