Hi,

I see this error coming up after pressing refresh on my feed. I use feedapi 1.2 on drupal 5.

user warning: Duplicate entry '3033-4342' for key 1 query: INSERT INTO term_node (nid, tid) VALUES (4342, 3033) in /home/public_html/includes/database.mysql.inc on line 172.

greetings,
Martijn

Comments

aron novak’s picture

aron novak
Primary language Hungarian
Location Hungary, Budapest
commented
Assigned: Unassigned » aron novak
Status: Active » Postponed (maintainer needs more info)

Do you use feedapi_inherit processor? Is the taxonomy inheriting turned on?
Does the parent feed has terms?
Does the inheriting works or not?

summit’s picture

summit commented

Hi,
Yes I use feedapi_inherit. Yes the taxonomy inheriting is turned on at the contenttype feed.
The parentfeed has one term. Yes this term is inherited to the feed-items.
Sorry for not telling this info on the initial bugreport

Thanks again for going into this.
greetings,
Martijn

aron novak’s picture

aron novak
Primary language Hungarian
Location Hungary, Budapest
commented

Well, I tried to reproduce this bug, but without success.
Can you tell me a little bit more about the circumstances when these messages appear?
I simply added an empty vocabulary and set the inheriting for a feed. No error appeared.
Does it appear when you refresh a feed first time after creating the feed? Or does it appear later?

summit’s picture

summit commented

Hi Aron,

This happens after refreshing a feed which already exists with more than twenty feed-items.
When I first delete all the feed items and then hit refresh, the error does not occur.
But when I hit refresh with an excisting feed with more than 20 feed-items, the error occurs.
Thanks for going into this!
greetings,
Martijn

aron novak’s picture

aron novak
Primary language Hungarian
Location Hungary, Budapest
commented

Can you give me access to the site (or a copy of the site)? Sometimes this is the fastest way to solve these hard-to-reproduce bugs.

summit’s picture

summit commented
Version: 5.x-1.2 » 5.x-1.x-dev

Hi Aron, with the newest 5*.dev version (june 2008) the error still remains.

user warning: Duplicate entry '2457-10913' for key 1 query: INSERT INTO term_node (nid, tid) VALUES (10913, 2457) in /includes/database.mysql.inc on line 172.

Off course you can have access to the site to try yourself if you are still in the blue related to this error. Please PM me for this, ok?

greetings,
Martijn

kenorb’s picture

kenorb commented
Version: 5.x-1.x-dev » 6.x-1.5
Component: Code » Code feedapi (core module)
Status: Postponed (maintainer needs more info) » Active

This problem still persist.
How to reproduce the bug:
Make sure that you have pathauto module installed.
1. Create some test url feed content (i.e. http://feeds.feedburner.com/EnglishAsASecondLanguagePodcast)
2. Refresh the items.
3. Delete them.
4. Refresh again.
You should see the error:

user warning: Duplicate entry 'angielski/english-cafe-173/feed-' for key 2 query: INSERT INTO url_alias (src, dst, language) VALUES ('node/1624/uk', 'angielski/english-cafe-173/feed', '') in /home/sites/co.uk/public_html/modules/path/path.module on line 112.
user warning: Duplicate entry 'angielski/444-–-planning-retirement/feed-' for key 2 query: INSERT INTO url_alias (src, dst, language) VALUES ('node/1625/uk', 'angielski/444-–-planning-retirement/feed', '') in /home/sites/co.uk/public_html/modules/path/path.module on line 112.

Tested on 6.9

Probably menu aliases are not deleted when the items are.

alex_b’s picture

alex_b commented
Assigned: aron novak » Unassigned

Shouldn't pathauto delete URL's with their nodes? Looks like a pathauto issue to me.

kenorb’s picture

kenorb commented
Title: duplicate term_node after refresh » Duplicate entry after feed refresh
Project: FeedAPI » Pathauto
Version: 6.x-1.5 » 7.x-1.x-dev
Component: Code feedapi (core module) » Code

Marked #324632: "Duplicate entry" error for the feed - after manually changing the alias for an item as duplicate.

greggles’s picture

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

@alex_b: It depends how the nodes are deleted. If the nodeapi op=delete is invoked then yes. If not...

If we look at the original bug report, it is a duplicate entry error, but on a wholly different database table. I think this issue was incorrectly repurposed from a feedapi issue to a Pathauto issue...

kenorb’s picture

kenorb commented
Project: Pathauto » FeedAPI
Version: 7.x-1.x-dev » 6.x-1.5
Component: Code » Code feedapi (core module)
kenorb’s picture

kenorb commented
Title: Duplicate entry after feed refresh » FeedAPI: Duplicate entry after feed refresh
kenorb’s picture

kenorb commented
Issue summary: View changes
Status: Active » Closed (outdated)

Version 6.x is no longer supported due to Drupal 6 End of Life.