Support » Plugin: FeedWordPress » [Plugin: FeedWordPress] remove or limit "syndication_item_hash" entries?

Viewing 11 replies - 1 through 11 (of 11 total)
  • I have exactly the same question — the amount of entries is unreal!

    Anyone?

    A. How ’bout a hint: what are the hashes used for?
    B. Plan B — quit using this plugin.

    Thanks!

    liquidbook

    (@liquidbook)

    I had the same issue. It caused some other key plugins to fail. Additionally the post -> post all (wp-admin/edit.php) failed to load. I was getting massive memory overload. Its a useful plugin and works wells (otherwise). In a week and a half i had 38,000 entries in the wp_postmeta (table) with the syndication_item_hash reference. After deleting these entries in phpMyAdmin and disabling FeedWordPress. All seem to go back to normal. But unless this issue is resolve i can use it.

    I want to use this plug-in and it really solves a key need. Maybe i am missing something in the settings.

    It’s actually quite easy to limit the number of stored hashes, but the question is: what is the point of storing all the past hashes?

    I’d love to know!

    Plugin Author radgeek

    (@radgeek)

    Hey y’all,

    The reason for storing the past hashes has to do with an attempt to avoid the kind of problem you’re seeing — an ever-growing number of post revisions being stored in the database under certain conditions. (For example, one case that came up a lot in practice was when users syndicated two aggregator feeds that sometimes carried the same items — without a backlog of previously-syndicated hashes, you could get into a more or less endless “update war” between two sources, which would cause a new revision to be stored on every update). Now it sounds like in your cases something has caused the conflict-avoidance mechanism to break down, so that it is detecting far more “updates” than it should.

    I’m currently making some changes and running some tests for the next public release of FWP, and if I could track down and make sure I’ve squashed the problem that y’all are running into, I’d be happy about that. So, could you (any of you, all of you) let me know:

    (1) Which version of FWP you are using that gives you this problem;

    (2) Which version of WordPress you’re using it with;

    (3) One or more of the URL(s) for the feed or feeds where you’re seeing the problem;

    and, if you know, (4) Whether the problem seems to be happening with every post on the feed(s), or only intermittently with some posts, but not with others. (And if intermittently, let me know an example of a post where you’re seeing the problem.)

    Thanks!

    I am having the same problems which accumulated in a complete stop of the site Euro2012Twitter.com . The wp_postmeta contained 7.800.000 records!
    Some details
    1. FWP version 2011.1019
    2. WP version 3.3.1 and since today 3.3.2 (same problem)
    3. feed causing hash problems:
    http://www.guardian.co.uk/football/euro2012/rss
    http://www.goal.com/en-india/feeds/news?id=477&fmt=rss
    4. feeds NOT causing hash problems:
    http://www.meetyourgoals.nl/news/feed
    http://2012euro.pap.pl/API/pl/Cms.Informations/CategoryRss/140/18/English%20News%20PAP%20Euro%202012

    It looks like it’s not happening with all feeds but if a feed goes wrong it affects all post.

    Hope this helps you a little.

    rgdrs,
    Cees

    Any progress on this? or for now does anyone have the sql to remove the postmeta hash keys that arent needed or old? I can remove all hash keys for a post but dont know what impact that has

    please advise….

    I have deleted all those item_hash meta keys, everything is fine, all rss feed links are still keep in on list and keep updating.

    Dutch RC

    (@jps-autosport)

    How 2 fast delete all these lines?
    I have over a milion of these lines.

    Dutch RC

    (@jps-autosport)

    Found it
    DELETE FROM wp1_postmeta WHERE meta_key LIKE ‘syndication_item_hash’

    Saved me over a million lines

    any news on this problem? my postmeta table just grown to over 700.000 lines in just a few days! manually deleting those lines is not an option for a live system.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘[Plugin: FeedWordPress] remove or limit "syndication_item_hash" entries?’ is closed to new replies.