RSS Aggregator Problem

jerwarren · Post by **jerwarren** » Thu Aug 31, 2006 3:17 am

sorry 'bout the delay.

 # Always update the MD5 hash, to catch updates of an entry properly. Patch by jerwarren!
         $t = time();
         $sql  = "INSERT INTO {$serendipity['dbPrefix']}aggregator_md5
                                      (entryid, md5, timestamp)
                                              VALUES ('$entryid', '$md5hash', '$t')";

        serendipity_db_query($sql);

It was copied verbatim from a few lines above. The $t=time(); is leftover from trying to figure out why the UPDATE call wasn't working, so I don't know if it's required or not.

Post by **garvinhicking** » Thu Aug 31, 2006 11:58 am

Hi!

Hm, that is strange, the "INSERT" should really have worked in the first time a feed was added. Could you check if the 'entryproperties' table holds all the ep_aggregator_articleurl etc. items for your feed items? My guess is that those are missing, too?

Judebert, I appreciate your help here too *gg*

Thus, the patch from you does seem to fix it for you, but we should better check why the insert fails in first place!

Best regards,
Garvin

jerwarren · Post by **jerwarren** » Thu Aug 31, 2006 2:37 pm

Well, it did work the first time a feed was added. It's just somehow being removed when a feed is updated... I've gone 'round and 'round through there trying to figure out how, but nothing is jumping out at me.

I'll take a peek at the other table this evening, or in the next couple days. I have a couple features I wnt to add to the aggregator, so I'll be mucking about in there anyway.

judebert · Post by **judebert** » Thu Aug 31, 2006 9:41 pm

Thanks, Garvin, but I'm afraid I'm failing. I'm just drowning in kids, activities and projects. I'm lucky if I can check in once a week.

I see you've committed some SVN changes; have you gotten your development machine back up and running?

Post by **garvinhicking** » Fri Sep 01, 2006 10:02 am

Hi Judebert!

No problem.

I committed some fixes via my live webserver, but that's far from perfect.

Best regards,
Garvin

jerwarren · Post by **jerwarren** » Sat Sep 02, 2006 7:35 pm

arg!

I guess that didn't fix it after all. Every time I think I've got it, I learn I'm wrong. I've currently got 2 entries that it is detecting as new repeatedly, which both HAVE entries in the md5 table, they just show the wrong hash. So whatever is deleting the entries sometimes isn't always doing it..

jerwarren · Post by **jerwarren** » Sat Sep 02, 2006 7:54 pm

garvinhicking wrote:Could you check if the 'entryproperties' table holds all the ep_aggregator_articleurl etc. items for your feed items? My guess is that those are missing, too?

Well, I can't vouch for whether they were there when the entries were saving as new, but they're all correct now..

I did a quick workaround fix by putting both the INSERT and the UPDATE in there to run each time. If for some reason the MD5 hash is deleted from the table, the INSERT puts it back, if not, the UPDATE updates it. Kinda stupid, but it seems to work..