[Plugin: WPeMatico] I keep getting duplicate content during every fetch

  • Resolved keithp

    (@keithp)


    13 years, 3 months ago

    Hi,

    First of all, I think thisis a great plugin. The features are outstanding.

    But, everytime i have a schedule fetch, at times, itwill repost an article on my site that was posted by Wpematico during the last fetch.

    one time, I had the article sho up on my site, 7 times.

    How can I fix this

    At first, i had the fetch set up at any, because I wanted to fetch as soon the rss feeds updated, but i changd it to an hour.

    Is here any way I can fetch every 5 minutes without wpematico fetching the same article they posted on my site 5 minutes ago?

    Thanks

Viewing 10 replies - 1 through 10 (of 10 total)
  • gdaddy

    (@gdaddy)

    13 years, 3 months ago

    Does it have a single quote in the title? If so, go to the wpematico_dojob file, isDuplicate function, under the line that says –
    $title = $item->get_title();
    put
    $title2 = str_replace(“‘”,”””,$title);
    and in the query below it, change $title to $title2

    had the same issue

    MyShadowSelf

    (@myshadowself)

    13 years, 3 months ago

    Nice find gdaddy. Been banging my head on this problem all day, should’ve looked here first.

    RoamFree

    (@roamfree)

    12 years, 11 months ago

    This shows that SQL injection is possible, and the plugin is probably vulnerable in other places. Maybe a better choice if you’re using MySQL:

    $title2 = mysql_real_escape_string($title);

    amplifiedshock

    (@amplifiedshock)

    12 years, 11 months ago

    I tried the fix above and it seems to be working for titles with single quotes in it.

    However, it still posts duplicates if it contains a colon now.

    RoamFree

    (@roamfree)

    12 years, 11 months ago

    amplifiedshock: Which fix: str_replace() or mysql_real_escape_string()?

    I’m running with mysql_real_escape_string() and two titles yesterday had colons without a duplicate problem.

    Are the titles identical, or is there a subtle difference, such as spaces or what is at the end of the title?

    RoamFree

    (@roamfree)

    12 years, 11 months ago

    And I have a correction… WP has a function which is already being used elsewhere in the code to clean up incoming strings. This seems to be what is needed:

    $title2 = $wpdb->escape($title);

    And then replace $title in the following line with $title2.

    amplifiedshock

    (@amplifiedshock)

    12 years, 11 months ago

    You were right, it seems like there WAS a tiny difference in the title of the duplicate article!

    I guess mysql_real_escape_string() was working perfectly. I’ll test your latest correction now.

    bspr3663

    (@bspr3663)

    12 years, 6 months ago

    Hey guys, any idea how to stop duplication of titles with the character = &

    Thanks in advance

    techyhippy

    (@techyhippy)

    12 years, 5 months ago

    same issue.. thanks folks for the fix. did pretty much as RoamFree suggested but just amended that line to:
    $title = $wpdb->escape($item->get_title());
    to save editing the query.

    thanks again folks.. saved me lots of messing about to figure it out myself!

    Plugin Author etruel

    (@etruel)

    12 years, 5 months ago

    thanks, this fix come in next version.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘[Plugin: WPeMatico] I keep getting duplicate content during every fetch’ is closed to new replies.