RSS Aggregator Problem

[jerwarren]

I've just set up a new instance of serendipity to act as an rss aggregator for all the various other serendipity instances I've set up over the years. (This technology is very cool!)

I'm running into a problem, though. When I 'feed' the aggregator by hitting the plugins/aggregator link, it displays the output of what it has done and indicates that one of my feeds has 15 new entries, every time. It's like the cache mechanism isn't working properly or something, but only for the one feed.

I've been digging around, but can't seem to figure out what the problem might be. As far as configuration goes, all the s9y instances are configured with the same plugins, so I'm sure it's got to be a problem on the aggregator end.

Thanks for any insight into the problem that you can give me.

[jerwarren]

deleting the offending feed and re-adding it seems to have cleared things up. There must have been some kind of error creating the necessary data in the db the first time or something.

[jerwarren]

actually, now a different feed is behaving in exactly the same way?

removing and re-adding didnt work this time..

Any ideas?

[garvinhicking]

Hi!

Hm, could you provde a DB dump of your serendipity_aggregator DB table? Then I would like to try to reproduce the issue?

Best regards,
Garvin

[jerwarren]

here's the 3 tables I've got that include "serendipity_aggregator":

Code: Select all

-- phpMyAdmin SQL Dump
-- version 2.8.0.3
-- http://www.phpmyadmin.net
-- 
-- Host: mysql.alistair.nyquil.org
-- Generation Time: Aug 13, 2006 at 01:28 PM
-- Server version: 5.0.18
-- PHP Version: 4.4.2
-- 
-- Database: `s9ynetwork`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `serendipity_aggregator_feedcat`
-- 

CREATE TABLE `serendipity_aggregator_feedcat` (
  `feedid` int(11) NOT NULL,
  `categoryid` int(11) NOT NULL,
  UNIQUE KEY `feedid_idx` (`feedid`,`categoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `serendipity_aggregator_feedcat`
-- 

INSERT INTO `serendipity_aggregator_feedcat` (`feedid`, `categoryid`) VALUES (30, 0),
(31, 0),
(32, 0),
(33, 0),
(34, 0),
(35, 0),
(36, 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `serendipity_aggregator_feeds`
-- 

CREATE TABLE `serendipity_aggregator_feeds` (
  `feedid` int(11) NOT NULL auto_increment,
  `feedname` varchar(255) NOT NULL default '',
  `feedurl` varchar(255) NOT NULL default '',
  `htmlurl` varchar(255) NOT NULL default '',
  `last_update` int(10) unsigned default NULL,
  `charset` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`feedid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ;

-- 
-- Dumping data for table `serendipity_aggregator_feeds`
-- 

INSERT INTO `serendipity_aggregator_feeds` (`feedid`, `feedname`, `feedurl`, `htmlurl`, `last_update`, `charset`) VALUES (30, 'FUTV Production Diary', 'http://futv.nyquil.org/feeds/index.rss2', 'http://futv.nyquil.org/', 1155325657, 'UTF-8'),
(31, 'jer''s posts from crapstack.net', 'http://crapstack.net/blog/index.php?/feeds/authors/3-jer.rss', 'http://crapstack.net/blog/', 1155325657, 'UTF-8'),
(32, 'jer''s posts from Cooking with Kooks', 'http://cookingwithkooks.org/feeds/authors/1-jer.rss', 'http://CookingWithKooks.org/', 1155325657, 'UTF-8'),
(33, 'nyquil.org', 'http://nyquil.org/feeds/index.rss2', 'http://nyquil.org/', 1155325657, 'UTF-8'),
(34, 'nyquil.org''s link blog', 'http://links.nyquil.org/index.php?/feeds/index.rss2', 'http://links.nyquil.org/', 1155325657, 'UTF-8'),
(35, 'nyquilnetwork - nyquil''s Tagged Photos', 'http://flickr.com/services/feeds/photos_public.gne?id=33538207@N00&tags=nyquilnetwork&format=rss_200', 'http://www.flickr.com/photos/jerwarren/tags/nyquilnetwork/', 1155325657, 'UTF-8'),
(36, 'The Ramblings of an A Hoel', 'http://alistair.nyquil.org/feeds/index.rss2', 'http://alistair.nyquil.org/', 1155436642, 'UTF-8');

-- --------------------------------------------------------

-- 
-- Table structure for table `serendipity_aggregator_md5`
-- 

CREATE TABLE `serendipity_aggregator_md5` (
  `entryid` int(11) NOT NULL auto_increment,
  `md5` varchar(32) NOT NULL default '',
  `timestamp` int(10) unsigned default NULL,
  PRIMARY KEY  (`entryid`),
  KEY `md5_idx` (`md5`),
  KEY `timestamp_idx` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=122 ;

-- 
-- Dumping data for table `serendipity_aggregator_md5`
-- 

INSERT INTO `serendipity_aggregator_md5` (`entryid`, `md5`, `timestamp`) VALUES (1, 'b6e29ffa1fba99a6d042e9f67c0414ce', 1155042296),
(2, '291f5c4f20674216dd9a726bf615c61d', 1155042296),
(3, 'c7db3d3ae9e4aad0d90453199f469679', 1155042316),
(4, '837c97f7b86d786be6e90e2ed08c914c', 1155042316),
(5, 'a3f0fc79ff581e10f1df3a1658ef1046', 1155042316),
(6, '2f547c12d5a7dde83293fc7795de2e35', 1155042316),
(7, 'd36641fc3697471e027c844698daccd1', 1155042316),
(8, 'cf4f8641239ed7d2fd197ea622951eb2', 1155042316),
(9, 'aa0aa15e61e254d0dbc846a32dde91ce', 1155042316),
(10, '160c31d8a1dea876ac8aaadc88c845dc', 1155042316),
(11, '667fd17620167b28f04be992efe5d57b', 1155042316),
(12, 'b9583af98486e01aa0eef8c1534fd4f4', 1155042316),
(13, '19169d452092343c6358f1df7604cd36', 1155042316),
(14, '1195f9e7738d59cbee1287b8793949f8', 1155042316),
(15, '05b743d84df25ab0176eca27c6f976d6', 1155062264),
(16, 'be5c1a1e3e58b2f5163fcf54714c7113', 1155062264),
(17, '83c71bd9ffa1eafb8bdf7cc67a0c5606', 1155062288),
(18, '0568a4ee4dd9c35d6276a9dad8a5b231', 1155062288),
(19, '37f32ec0b80c281d09c26ee0ea32bd51', 1155062288),
(20, '4d64dcee03ffa4e3d43febd9e3c11a99', 1155062288),
(21, '09c29aae145562ee9fdb445ae9acfb70', 1155062289),
(22, '6becb81e3c323bf393a997f732f11605', 1155062289),
(23, '5b6347c5bd2556b5a8fc1375c936e1b5', 1155062289),
(24, '12ccf84a340c614a6335895b082062d4', 1155062289),
(25, '3aeef131adce25c1fa103a12fdf53052', 1155062289),
(26, '3e12b126461715aa7da4b2add054fc70', 1155062289),
(27, '8933c54f9b704a22c8e6480a3c24a39d', 1155062289),
(28, 'd99e9e9099f92732684399bc53eccf4c', 1155062289),
(29, '25138cd38e73cec8dd9974342a23306f', 1155062289),
(30, '86844a2ca479a64b5af7d1dcde88b9b8', 1155062290),
(31, '8763ab2ad7b9c29d8fd888775c115396', 1155062290),
(33, '770145d0f52d16a34f1ebf2de619ae1a', 1155089608),
(34, '86bd39082e8bf864b1a913bfe11711fb', 1155169636),
(36, 'a39e5ef6ffc15bd6530a2116ef8e4b43', 1155177181),
(37, 'be5b8cad3416437ebd4c0aac3fa4b6d9', 1155178937),
(38, 'bc9ae9fd363a3381188796ac06d60a6a', 1155236307),
(39, '53d27e5bff5bc29ddd82cc7a3c3ffc60', 1155263831),
(40, 'dc989b81c7aabdc9ed0cd67e68e99ee2', 1155314562),
(41, '1f8d282fb6fdf7b6b2f2b0be628f543e', 1155314562),
(42, 'b46a9e4848f722aae5f1a24aa080c31e', 1155314563),
(43, '7d50f18d1c14dc211b19578c068b458f', 1155314565),
(44, '42b7c1a72914ab751203255c7cf1cf74', 1155314565),
(45, 'fd291c9ee7c68306f37536c8e7beb425', 1155314566),
(46, '1df9810abb345705cb17d29441b6baa4', 1155314566),
(47, '6f83fa5aa92c3e90353dbec023827c73', 1155314567),
(48, '2a12e5459ee7973c286c0b718009b254', 1155314567),
(49, '8d7d5b5fa27974c4f74aeed2e4c1cf5e', 1155314567),
(50, 'f46d77d156f206529d60ffa12eb368c3', 1155314567),
(51, 'ac4d00e38f8a5e51855ae4c6e632741c', 1155314567),
(52, '7a2df0ad3cb6f367d906297f985c07f2', 1155314567),
(53, '4a1fb17e6a163fbc450712b506a73106', 1155314567),
(54, 'fcfdcfec26f81dac6495e3e8ebb0bf8a', 1155314567),
(55, '5ae3c0dd290ebf9607cdc9fe6e010ba6', 1155314567),
(56, '77db93e5e2a2645fa98cea2326c1528b', 1155314567),
(57, 'dabaebee54ea03f803c18295e6098dd8', 1155314567),
(58, '984f35bd093192535291882ad0ae8501', 1155314567),
(59, 'da0a011d8dee8df19ed62ddcce1424ca', 1155314567),
(60, 'be11dd274ce21e85191b9ffe772fc715', 1155314571),
(61, '174b076737b6bc3d59eaa47ef5131ebc', 1155314571),
(62, 'bf26a9e08e15417fc1dc0cdab21032e7', 1155314571),
(63, '33b5c461a9ed3825c14cd3071ddb35ef', 1155314571),
(64, 'c6cb70e6ba26874982eaf072c41dd317', 1155314571),
(65, '7f268204a6ba8910fc093fe8c51af0dc', 1155314571),
(66, '225265edb9cba382997f5b4a8721c644', 1155314571),
(67, '1fa78506f864168cd6594210f3491149', 1155314571),
(68, '8b3e85382bf56442ff4a094fd495fb7b', 1155314572),
(69, '20fa9e18d964bccfdd008860a48bfab7', 1155314572),
(70, 'ca5320e5774f1ac799ca9b97657a3d8d', 1155314572),
(71, '8c9ddede5c55be22e931e9a731e6c566', 1155314572),
(72, '5e99b26543646cbce80b5ead3da3e1ba', 1155314572),
(73, '32eae7b7896b93fd64f6a0d5382016ed', 1155314572),
(74, 'a564a51a44b399ce53799bc127d661ab', 1155314572),
(75, '872b06e023a08461cd9381e052115a6a', 1155314572),
(76, 'ae243adba0b17beb032afbb26b8ed339', 1155314572),
(77, '59a9ecf0c8d02a8a1426e6c9916e7a67', 1155314572),
(78, 'a5a4faf589d6b3ba15ea1487a507b23c', 1155314572),
(79, 'c74fb96d796e8d367592ae30604ea913', 1155314572),
(80, '94234de2b9c03745d8f81b16a777584a', 1155314582),
(82, 'e47aa3f7ae790210de4157ae16877010', 1155314597),
(83, 'c2af7a608e02cbbea79086b944a20b1e', 1155314599),
(84, 'bf69067bc5b70bc482d30c14233f05d5', 1155314601),
(85, 'd27328a5621597f1fb7f26b6cedce5b0', 1155314601),
(86, '34395ffcd04bf1cb32a0991b4216360e', 1155314601),
(87, '0805f05a3185ebf7baa3e75625ded827', 1155314601),
(88, '92cbc25a5e01ec9119f98ab00cac575a', 1155314602),
(89, '2f92da8d414fb46eb9a464241de733f8', 1155315074),
(90, '9845ced30115ea32ef22cdb95c5dcc5e', 1155315074),
(91, '7ec843efde6a672ef4a60635af666de5', 1155315074),
(92, '37f5f40e16c7c41cef2a5240e23089a3', 1155315075),
(93, '0669ff0f1b90d62643d3768713c2582f', 1155315077),
(94, '2d5381ce762b52f98c81ab6b8aa05636', 1155315077),
(95, 'dec95a41fff13e6995d6b8b9c20bfae2', 1155315077),
(96, '0b4f11db25b0be5978c81822773b5d04', 1155315077),
(97, '9f68c3392dfa10f73f00285d1d0b3f30', 1155315077),
(98, '202221c3b282ce56c1dcc09af070b025', 1155315077),
(99, '4896fd5ff2ebe7f955db876cf4ee7df7', 1155315077),
(100, '334a7abab3713fe8dc962458509ba53f', 1155315077),
(101, 'f80c1e2aaf97df7f7188bd4df3635ed4', 1155315077),
(102, 'c345ff934139ccc58705365fdad692de', 1155315077),
(103, '43c59ee68c107192b9fc970b16cd693b', 1155315077),
(104, '95a94a0cf058f759cad555b85dd1aa60', 1155315078),
(105, '30468d802c6c45751a95e9b54e7da346', 1155315078),
(106, 'bfba79ac5df0ddbc504e063fe3fa5329', 1155315078),
(107, '40d8b6141cab93f9dc88dc34d72ac7bb', 1155315078),
(108, '9f27a4c80f113bd3126c872ddcf3ed5a', 1155315082),
(109, '5662c25bb36799fccd3c1a14dba95e52', 1155315082),
(110, 'bf462b562c7507600791a2a1d52c0d33', 1155315082),
(111, '94d2fbc54f4b10ca14ef36b337a1c1bc', 1155315082),
(112, 'bd7b756670ce4d635f4e7e834fdb9f07', 1155315082),
(113, '47f64338c7aa2a52b1e8b90bedec30d6', 1155315082),
(114, '6ccd4d113f4c9d257e3ec0105de30109', 1155315082),
(115, '7c3df05c65a9088d2f954f13cbb95ad2', 1155315082),
(116, '7762700af0d3bf3c143d373c0484f04a', 1155315082),
(117, '2979a5182b57eb53a748cda744800d69', 1155315082),
(118, '48f145a289e08cbc3ace8f1c81f54aab', 1155315082),
(119, '46b488d7524db50c2141c277f8b28e41', 1155315082),
(120, 'c87cb1877288f1a28cf20f2fd39f1937', 1155324031),
(121, '7e96de4d64b715fbfe538acdaf6b2da9', 1155325019);

[jerwarren]

I've since added another feed, and it too exhibits the same behavior. Every time I refresh it, it adds feed entries again as if they have been updated. (but saves them as the same entry number, so at least it isn't duplicating things.)

I've temporarily gotten around the problem by setting it to expire entries after 3 days, instead of the 'never expire' that I had it set at, but this is less than desireable.

[garvinhicking]

Hi!

Could you tell me which of the feed URLs is showing that behaviour? If the plugin reports the entries as new, it might be because the timestamp could be changing in those feeds...or it might be because they're RSS 1.0 feeds - those to not contain unique IDs to look after...

Best regards,
Garvin

[jerwarren]

Read http://alistair.nyquil.org/feeds/index.rss2. Save 'Man, I really don't want to travel now' as 125. Finish feed.

That's part of the output of the aggregator plugin as I just ran it. #125 was posted yesterday afternoon, and will be saved every time the aggregator runs -- until it meets the 3 day expiry time. If I remove the expiration time, it saves the last 15 entries as if they were new/updated.

It is indeed an rss2.0 feed, and it does it regardless of modification times of the actual post.

The other feed that is exhibiting the same behavior is http://comics.nyquil.org/feeds/index.rss2, and the one post there was also posted yesterday afternoon, but keeps showing up as new/modified.

I can make you admin logins if that'd help anything.

[garvinhicking]

Hi!

Thanks a lot, I will look into this. I already have a supposal that the "-0700" of the timestamp might be involved.

Best regards,
Garvin[/quote]

[garvinhicking]

Hi!

Okay, my first idea didn't hit it. I subscribed to the feeds, and it did work for me (using Onyx RSS parser).

However there was a problematic query that involved entry detection: It only fetched feeds with "isdraft = false". But depending on the user your feeds are set to, it might be that he is only saving entries as draft entries.

Could you please enable the Debug-Logging of the aggregator feed and show me the output you get? It should definitely catch on your entry/entries. I now also removed the 'isdraft' thing in version 0.9 of the aggreagot plugin.

Best regards,
Garvin

[jerwarren]

unfortunately, it doesn't seem to be doing it now..

As soon as I see it do it again, I'll paste it in for you. Sporadic problems are no fun

[jerwarren]

OK. It's doing it again.. I think it might have something to do with posts that have been updated since the aggregator added them to the database, since it appears that only posts that have been updated repeatedly show up as new.

Is it perhaps not properly saving the new MD5 hash when it detects an update?

Anyway, here's the debug output. I wasn't sure if you'd just want the output involving the relevant feeds or what, so I'm just sending the whole thing. Sorry about that. Oh, also, I haven't posted anything since yesterday afternoon, so every 'Saved' in that log is an example of an 'always new' post.

Code: Select all

DEBUG: cache_authors['realname'] = authorid has 12 entries DEBUG: cache_entries['title']['authorid']['timestamp'] = entryid has 6 entries. DEBUG: cache_md5['md5'] = entryid has 132 entries. Read http://comics.nyquil.org/feeds/index.rss2. DEBUG: Current authorid = 12 DEBUG: parseDate(Thu, 17 Aug 2006 18:45:03 -0700) as 2006-08-17 18:45:03 (strtotime) DEBUG: pubDate Thu, 17 Aug 2006 18:45:03 -0700 = 1155865503 DEBUG: parseDate(Wed, 16 Aug 2006 18:18:16 -0700) as 2006-08-16 18:18:16 (strtotime) DEBUG: pubDate Wed, 16 Aug 2006 18:18:16 -0700 = 1155777496 DEBUG: parseDate(Sun, 13 Aug 2006 15:54:17 -0700) as 2006-08-13 15:54:17 (strtotime) DEBUG: pubDate Sun, 13 Aug 2006 15:54:17 -0700 = 1155509657 DEBUG: lookup cache_entries[Tales from Tom'sSpace: pollen shit][12][1155865503] finds 136. DEBUG: lookup cache_md5[8ae29703b28bfa23d37c96409af4073e] finds nothing. Save 'Tales from Tom'sSpace: pollen shit' as 136. DEBUG: lookup cache_entries[Farmaceutical Elixr][12][1155777496] finds 134. DEBUG: lookup cache_md5[fd654bc7ca3bdc3888b857d5ad25c2f7] finds nothing. Save 'Farmaceutical Elixr' as 134. DEBUG: lookup cache_entries[Comic #1][12][1155509657] finds nothing. DEBUG: lookup cache_md5[9147f73b51ec912ce1f70dafd5ce141e] finds nothing. DEBUG: 'Comic #1' is too old (1155509657 < 1155670273). Finish feed. Read http://futv.nyquil.org/feeds/index.rss2. DEBUG: Current authorid = 7 DEBUG: parseDate(Tue, 14 Mar 2006 20:29:32 -0800) as 2006-03-14 20:29:32 (strtotime) DEBUG: pubDate Tue, 14 Mar 2006 20:29:32 -0800 = 1142396972 DEBUG: parseDate(Tue, 28 Feb 2006 20:53:13 -0800) as 2006-02-28 20:53:13 (strtotime) DEBUG: pubDate Tue, 28 Feb 2006 20:53:13 -0800 = 1141188793 DEBUG: parseDate(Tue, 28 Feb 2006 19:17:01 -0800) as 2006-02-28 19:17:01 (strtotime) DEBUG: pubDate Tue, 28 Feb 2006 19:17:01 -0800 = 1141183021 DEBUG: lookup cache_entries[Idears][7][1142396972] finds nothing. DEBUG: lookup cache_md5[dc989b81c7aabdc9ed0cd67e68e99ee2] finds 40. DEBUG: lookup cache_entries[Moral Kids Show][7][1141188793] finds nothing. DEBUG: lookup cache_md5[1f8d282fb6fdf7b6b2f2b0be628f543e] finds 41. DEBUG: lookup cache_entries[Intro][7][1141183021] finds nothing. DEBUG: lookup cache_md5[b46a9e4848f722aae5f1a24aa080c31e] finds 42. Finish feed. Read http://cookingwithkooks.org/feeds/authors/1-jer.rss. DEBUG: Current authorid = 11 DEBUG: parseDate(Wed, 26 Jul 2006 19:12:31 -0700) as 2006-07-26 19:12:31 (strtotime) DEBUG: pubDate Wed, 26 Jul 2006 19:12:31 -0700 = 1153966351 DEBUG: parseDate(Tue, 18 Jul 2006 18:39:32 -0700) as 2006-07-18 18:39:32 (strtotime) DEBUG: pubDate Tue, 18 Jul 2006 18:39:32 -0700 = 1153273172 DEBUG: parseDate(Wed, 05 Apr 2006 18:22:43 -0700) as 2006-04-05 18:22:43 (strtotime) DEBUG: pubDate Wed, 05 Apr 2006 18:22:43 -0700 = 1144286563 DEBUG: parseDate(Sun, 02 Apr 2006 19:23:34 -0700) as 2006-04-02 19:23:34 (strtotime) DEBUG: pubDate Sun, 02 Apr 2006 19:23:34 -0700 = 1144031014 DEBUG: lookup cache_entries[Chili + Tortilini = Yum][11][1153966351] finds nothing. DEBUG: lookup cache_md5[2f92da8d414fb46eb9a464241de733f8] finds 89. DEBUG: lookup cache_entries['P B & J' French Toast][11][1153273172] finds nothing. DEBUG: lookup cache_md5[9845ced30115ea32ef22cdb95c5dcc5e] finds 90. DEBUG: lookup cache_entries[Extra Moist French Toast][11][1144286563] finds nothing. DEBUG: lookup cache_md5[7ec843efde6a672ef4a60635af666de5] finds 91. DEBUG: lookup cache_entries[Lemon Tuaca Surprise][11][1144031014] finds nothing. DEBUG: lookup cache_md5[37f5f40e16c7c41cef2a5240e23089a3] finds 92. Finish feed. Read http://crapstack.net/blog/index.php?/feeds/authors/3-jer.rss. DEBUG: Current authorid = 10 DEBUG: parseDate(Fri, 16 Jun 2006 17:20:25 -0700) as 2006-06-16 17:20:25 (strtotime) DEBUG: pubDate Fri, 16 Jun 2006 17:20:25 -0700 = 1150503625 DEBUG: parseDate(Wed, 24 May 2006 21:54:53 -0700) as 2006-05-24 21:54:53 (strtotime) DEBUG: pubDate Wed, 24 May 2006 21:54:53 -0700 = 1148532893 DEBUG: parseDate(Wed, 10 May 2006 19:27:13 -0700) as 2006-05-10 19:27:13 (strtotime) DEBUG: pubDate Wed, 10 May 2006 19:27:13 -0700 = 1147314433 DEBUG: parseDate(Wed, 10 May 2006 17:36:23 -0700) as 2006-05-10 17:36:23 (strtotime) DEBUG: pubDate Wed, 10 May 2006 17:36:23 -0700 = 1147307783 DEBUG: parseDate(Fri, 07 Apr 2006 13:57:59 -0700) as 2006-04-07 13:57:59 (strtotime) DEBUG: pubDate Fri, 07 Apr 2006 13:57:59 -0700 = 1144443479 DEBUG: parseDate(Wed, 15 Feb 2006 18:36:04 -0800) as 2006-02-15 18:36:04 (strtotime) DEBUG: pubDate Wed, 15 Feb 2006 18:36:04 -0800 = 1140057364 DEBUG: parseDate(Mon, 13 Feb 2006 20:12:29 -0800) as 2006-02-13 20:12:29 (strtotime) DEBUG: pubDate Mon, 13 Feb 2006 20:12:29 -0800 = 1139890349 DEBUG: parseDate(Fri, 03 Feb 2006 14:55:14 -0800) as 2006-02-03 14:55:14 (strtotime) DEBUG: pubDate Fri, 03 Feb 2006 14:55:14 -0800 = 1139007314 DEBUG: parseDate(Thu, 02 Feb 2006 20:19:44 -0800) as 2006-02-02 20:19:44 (strtotime) DEBUG: pubDate Thu, 02 Feb 2006 20:19:44 -0800 = 1138940384 DEBUG: parseDate(Thu, 05 Jan 2006 17:54:48 -0800) as 2006-01-05 17:54:48 (strtotime) DEBUG: pubDate Thu, 05 Jan 2006 17:54:48 -0800 = 1136512488 DEBUG: parseDate(Mon, 19 Dec 2005 20:28:38 -0800) as 2005-12-19 20:28:38 (strtotime) DEBUG: pubDate Mon, 19 Dec 2005 20:28:38 -0800 = 1135052918 DEBUG: parseDate(Tue, 13 Dec 2005 19:23:35 -0800) as 2005-12-13 19:23:35 (strtotime) DEBUG: pubDate Tue, 13 Dec 2005 19:23:35 -0800 = 1134530615 DEBUG: parseDate(Mon, 12 Dec 2005 17:20:19 -0800) as 2005-12-12 17:20:19 (strtotime) DEBUG: pubDate Mon, 12 Dec 2005 17:20:19 -0800 = 1134436819 DEBUG: parseDate(Fri, 09 Dec 2005 11:40:23 -0800) as 2005-12-09 11:40:23 (strtotime) DEBUG: pubDate Fri, 09 Dec 2005 11:40:23 -0800 = 1134157223 DEBUG: parseDate(Fri, 09 Dec 2005 10:58:30 -0800) as 2005-12-09 10:58:30 (strtotime) DEBUG: pubDate Fri, 09 Dec 2005 10:58:30 -0800 = 1134154710 DEBUG: lookup cache_entries[Great Bell South Ad][10][1150503625] finds nothing. DEBUG: lookup cache_md5[0669ff0f1b90d62643d3768713c2582f] finds 93. DEBUG: lookup cache_entries[Al Gore: Your 43rd President][10][1148532893] finds nothing. DEBUG: lookup cache_md5[2d5381ce762b52f98c81ab6b8aa05636] finds 94. DEBUG: lookup cache_entries[C For Cookie][10][1147314433] finds nothing. DEBUG: lookup cache_md5[dec95a41fff13e6995d6b8b9c20bfae2] finds 95. DEBUG: lookup cache_entries[Great Idea][10][1147307783] finds nothing. DEBUG: lookup cache_md5[0b4f11db25b0be5978c81822773b5d04] finds 96. DEBUG: lookup cache_entries[The Ultimate Showdown of Ultimate Destiny][10][1144443479] finds nothing. DEBUG: lookup cache_md5[9f68c3392dfa10f73f00285d1d0b3f30] finds 97. DEBUG: lookup cache_entries[More fun at the expense of emo][10][1140057364] finds nothing. DEBUG: lookup cache_md5[202221c3b282ce56c1dcc09af070b025] finds 98. DEBUG: lookup cache_entries[Emo Bears][10][1139890349] finds nothing. DEBUG: lookup cache_md5[4896fd5ff2ebe7f955db876cf4ee7df7] finds 99. DEBUG: lookup cache_entries[Jonathan Coulton][10][1139007314] finds nothing. DEBUG: lookup cache_md5[334a7abab3713fe8dc962458509ba53f] finds 100. DEBUG: lookup cache_entries[Brokeback to the Future][10][1138940384] finds nothing. DEBUG: lookup cache_md5[f80c1e2aaf97df7f7188bd4df3635ed4] finds 101. DEBUG: lookup cache_entries[The Chronic--WHAT?!--cles of Narnia][10][1136512488] finds nothing. DEBUG: lookup cache_md5[c345ff934139ccc58705365fdad692de] finds 102. DEBUG: lookup cache_entries[Unnecessary Censorship][10][1135052918] finds nothing. DEBUG: lookup cache_md5[43c59ee68c107192b9fc970b16cd693b] finds 103. DEBUG: lookup cache_entries[Getting in Touch with Santa/God][10][1134530615] finds nothing. DEBUG: lookup cache_md5[95a94a0cf058f759cad555b85dd1aa60] finds 104. DEBUG: lookup cache_entries[Jelly Donut][10][1134436819] finds nothing. DEBUG: lookup cache_md5[30468d802c6c45751a95e9b54e7da346] finds 105. DEBUG: lookup cache_entries[Scarlett Johanssen is awesome.][10][1134157223] finds nothing. DEBUG: lookup cache_md5[bfba79ac5df0ddbc504e063fe3fa5329] finds 106. DEBUG: lookup cache_entries[Calvin-esque Snowmen][10][1134154710] finds nothing. DEBUG: lookup cache_md5[40d8b6141cab93f9dc88dc34d72ac7bb] finds 107. Finish feed. Read http://nyquil.org/feeds/index.rss2. DEBUG: Current authorid = 2 DEBUG: parseDate(Thu, 17 Aug 2006 09:06:08 -0700) as 2006-08-17 09:06:08 (strtotime) DEBUG: pubDate Thu, 17 Aug 2006 09:06:08 -0700 = 1155830768 DEBUG: parseDate(Wed, 16 Aug 2006 09:10:15 -0700) as 2006-08-16 09:10:15 (strtotime) DEBUG: pubDate Wed, 16 Aug 2006 09:10:15 -0700 = 1155744615 DEBUG: parseDate(Tue, 15 Aug 2006 09:02:47 -0700) as 2006-08-15 09:02:47 (strtotime) DEBUG: pubDate Tue, 15 Aug 2006 09:02:47 -0700 = 1155657767 DEBUG: parseDate(Sun, 13 Aug 2006 17:35:00 -0700) as 2006-08-13 17:35:00 (strtotime) DEBUG: pubDate Sun, 13 Aug 2006 17:35:00 -0700 = 1155515700 DEBUG: parseDate(Fri, 11 Aug 2006 11:35:45 -0700) as 2006-08-11 11:35:45 (strtotime) DEBUG: pubDate Fri, 11 Aug 2006 11:35:45 -0700 = 1155321345 DEBUG: parseDate(Thu, 10 Aug 2006 09:08:18 -0700) as 2006-08-10 09:08:18 (strtotime) DEBUG: pubDate Thu, 10 Aug 2006 09:08:18 -0700 = 1155226098 DEBUG: parseDate(Tue, 08 Aug 2006 19:09:26 -0700) as 2006-08-08 19:09:26 (strtotime) DEBUG: pubDate Tue, 08 Aug 2006 19:09:26 -0700 = 1155089366 DEBUG: parseDate(Mon, 07 Aug 2006 17:53:54 -0700) as 2006-08-07 17:53:54 (strtotime) DEBUG: pubDate Mon, 07 Aug 2006 17:53:54 -0700 = 1154998434 DEBUG: parseDate(Mon, 31 Jul 2006 11:59:48 -0700) as 2006-07-31 11:59:48 (strtotime) DEBUG: pubDate Mon, 31 Jul 2006 11:59:48 -0700 = 1154372388 DEBUG: parseDate(Fri, 28 Jul 2006 10:23:04 -0700) as 2006-07-28 10:23:04 (strtotime) DEBUG: pubDate Fri, 28 Jul 2006 10:23:04 -0700 = 1154107384 DEBUG: parseDate(Thu, 27 Jul 2006 15:11:26 -0700) as 2006-07-27 15:11:26 (strtotime) DEBUG: pubDate Thu, 27 Jul 2006 15:11:26 -0700 = 1154038286 DEBUG: parseDate(Thu, 27 Jul 2006 07:19:00 -0700) as 2006-07-27 07:19:00 (strtotime) DEBUG: pubDate Thu, 27 Jul 2006 07:19:00 -0700 = 1154009940 DEBUG: parseDate(Wed, 26 Jul 2006 18:43:22 -0700) as 2006-07-26 18:43:22 (strtotime) DEBUG: pubDate Wed, 26 Jul 2006 18:43:22 -0700 = 1153964602 DEBUG: parseDate(Wed, 26 Jul 2006 17:07:26 -0700) as 2006-07-26 17:07:26 (strtotime) DEBUG: pubDate Wed, 26 Jul 2006 17:07:26 -0700 = 1153958846 DEBUG: parseDate(Mon, 24 Jul 2006 17:19:00 -0700) as 2006-07-24 17:19:00 (strtotime) DEBUG: pubDate Mon, 24 Jul 2006 17:19:00 -0700 = 1153786740 DEBUG: lookup cache_entries[open letter to morgan spurlock][2][1155830768] finds 135. DEBUG: lookup cache_md5[28cc299f5572f80a53396098a4347b21] finds 135. DEBUG: lookup cache_entries[oh no, not a Z-shaped one][2][1155744615] finds 129. DEBUG: lookup cache_md5[4b57bd0835662857daef6f2a125735bf] finds 129. DEBUG: lookup cache_entries[spork you][2][1155657767] finds nothing. DEBUG: lookup cache_md5[14609b0ee4ad9bcca6a76b09faec37fd] finds 127. DEBUG: lookup cache_entries[nothing's quite as entertaining as me hurting myself][2][1155515700] finds nothing. DEBUG: lookup cache_md5[30fba26b6346acda3021ff8734eca906] finds 126. DEBUG: lookup cache_entries[Photoshop Fun?][2][1155321345] finds nothing. DEBUG: lookup cache_md5[75c6808edc7c374ea3bfe701ce2a2805] finds nothing. DEBUG: 'Photoshop Fun?' is too old (1155321345 < 1155670298). DEBUG: lookup cache_entries[Furry Logic][2][1155226098] finds nothing. DEBUG: lookup cache_md5[bc9ae9fd363a3381188796ac06d60a6a] finds 38. DEBUG: lookup cache_entries[Bullet-point Jury Duty Recap, Days 2-14][2][1155089366] finds nothing. DEBUG: lookup cache_md5[770145d0f52d16a34f1ebf2de619ae1a] finds 33. DEBUG: lookup cache_entries[Family Guy == Unfunny][2][1154998434] finds nothing. DEBUG: lookup cache_md5[83c71bd9ffa1eafb8bdf7cc67a0c5606] finds 17. DEBUG: lookup cache_entries[Please Help][2][1154372388] finds nothing. DEBUG: lookup cache_md5[0568a4ee4dd9c35d6276a9dad8a5b231] finds 18. DEBUG: lookup cache_entries[I Can't Get No/ Notifaction][2][1154107384] finds nothing. DEBUG: lookup cache_md5[37f32ec0b80c281d09c26ee0ea32bd51] finds 19. DEBUG: lookup cache_entries[Ordering Online Drives Me Nuts][2][1154038286] finds nothing. DEBUG: lookup cache_md5[4d64dcee03ffa4e3d43febd9e3c11a99] finds 20. DEBUG: lookup cache_entries[TAM4 DVDs][2][1154009940] finds nothing. DEBUG: lookup cache_md5[09c29aae145562ee9fdb445ae9acfb70] finds 21. DEBUG: lookup cache_entries[Striving to be more like Christ][2][1153964602] finds nothing. DEBUG: lookup cache_md5[6becb81e3c323bf393a997f732f11605] finds 22. DEBUG: lookup cache_entries[Bullet-point Jury Duty Recap: Day 1][2][1153958846] finds nothing. DEBUG: lookup cache_md5[5b6347c5bd2556b5a8fc1375c936e1b5] finds 23. DEBUG: lookup cache_entries[No Robots Please][2][1153786740] finds nothing. DEBUG: lookup cache_md5[12ccf84a340c614a6335895b082062d4] finds 24. Finish feed. Read http://links.nyquil.org/index.php?/feeds/index.rss2. DEBUG: Current authorid = 8 DEBUG: parseDate(Wed, 16 Aug 2006 17:58:57 -0700) as 2006-08-16 17:58:57 (strtotime) DEBUG: pubDate Wed, 16 Aug 2006 17:58:57 -0700 = 1155776337 DEBUG: parseDate(Tue, 15 Aug 2006 18:17:19 -0700) as 2006-08-15 18:17:19 (strtotime) DEBUG: pubDate Tue, 15 Aug 2006 18:17:19 -0700 = 1155691039 DEBUG: parseDate(Sun, 13 Aug 2006 13:24:07 -0700) as 2006-08-13 13:24:07 (strtotime) DEBUG: pubDate Sun, 13 Aug 2006 13:24:07 -0700 = 1155500647 DEBUG: parseDate(Fri, 11 Aug 2006 12:35:33 -0700) as 2006-08-11 12:35:33 (strtotime) DEBUG: pubDate Fri, 11 Aug 2006 12:35:33 -0700 = 1155324933 DEBUG: parseDate(Wed, 09 Aug 2006 19:30:19 -0700) as 2006-08-09 19:30:19 (strtotime) DEBUG: pubDate Wed, 09 Aug 2006 19:30:19 -0700 = 1155177019 DEBUG: parseDate(Wed, 09 Aug 2006 17:24:51 -0700) as 2006-08-09 17:24:51 (strtotime) DEBUG: pubDate Wed, 09 Aug 2006 17:24:51 -0700 = 1155169491 DEBUG: parseDate(Sun, 06 Aug 2006 20:42:22 -0700) as 2006-08-06 20:42:22 (strtotime) DEBUG: pubDate Sun, 06 Aug 2006 20:42:22 -0700 = 1154922142 DEBUG: parseDate(Wed, 02 Aug 2006 18:41:38 -0700) as 2006-08-02 18:41:38 (strtotime) DEBUG: pubDate Wed, 02 Aug 2006 18:41:38 -0700 = 1154569298 DEBUG: parseDate(Wed, 02 Aug 2006 17:33:47 -0700) as 2006-08-02 17:33:47 (strtotime) DEBUG: pubDate Wed, 02 Aug 2006 17:33:47 -0700 = 1154565227 DEBUG: parseDate(Sat, 29 Jul 2006 12:02:00 -0700) as 2006-07-29 12:02:00 (strtotime) DEBUG: pubDate Sat, 29 Jul 2006 12:02:00 -0700 = 1154199720 DEBUG: parseDate(Sat, 29 Jul 2006 08:03:22 -0700) as 2006-07-29 08:03:22 (strtotime) DEBUG: pubDate Sat, 29 Jul 2006 08:03:22 -0700 = 1154185402 DEBUG: parseDate(Fri, 28 Jul 2006 11:27:13 -0700) as 2006-07-28 11:27:13 (strtotime) DEBUG: pubDate Fri, 28 Jul 2006 11:27:13 -0700 = 1154111233 DEBUG: parseDate(Tue, 25 Jul 2006 17:30:11 -0700) as 2006-07-25 17:30:11 (strtotime) DEBUG: pubDate Tue, 25 Jul 2006 17:30:11 -0700 = 1153873811 DEBUG: parseDate(Tue, 25 Jul 2006 17:21:09 -0700) as 2006-07-25 17:21:09 (strtotime) DEBUG: pubDate Tue, 25 Jul 2006 17:21:09 -0700 = 1153873269 DEBUG: parseDate(Sat, 22 Jul 2006 12:27:14 -0700) as 2006-07-22 12:27:14 (strtotime) DEBUG: pubDate Sat, 22 Jul 2006 12:27:14 -0700 = 1153596434 DEBUG: lookup cache_entries[advertising -- and muppets -- has sure changed][8][1155776337] finds 130. DEBUG: lookup cache_md5[b002aec05386585f6c156a810d6da3c7] finds 130. DEBUG: lookup cache_entries[I want one of these][8][1155691039] finds 128. DEBUG: lookup cache_md5[b358df4003c9b320a2d73cb4da3a6d7a] finds 128. DEBUG: lookup cache_entries[I love stuff like this][8][1155500647] finds nothing. DEBUG: lookup cache_md5[266a4a18883f04a1dabb906316c8ba1b] finds 123. DEBUG: lookup cache_entries[Kevin Smith's Superman Story][8][1155324933] finds nothing. DEBUG: lookup cache_md5[7e96de4d64b715fbfe538acdaf6b2da9] finds 121. DEBUG: lookup cache_entries[Interesting Web Desktop][8][1155177019] finds nothing. DEBUG: lookup cache_md5[a39e5ef6ffc15bd6530a2116ef8e4b43] finds 36. DEBUG: lookup cache_entries[It's funny because it's true][8][1155169491] finds nothing. DEBUG: lookup cache_md5[86bd39082e8bf864b1a913bfe11711fb] finds 34. DEBUG: lookup cache_entries[workfriendly.net][8][1154922142] finds nothing. DEBUG: lookup cache_md5[9f27a4c80f113bd3126c872ddcf3ed5a] finds 108. DEBUG: lookup cache_entries["Snakes" arriving soon.. are you ready?][8][1154569298] finds nothing. DEBUG: lookup cache_md5[5662c25bb36799fccd3c1a14dba95e52] finds 109. DEBUG: lookup cache_entries[Amusing Colbert Taping Story][8][1154565227] finds nothing. DEBUG: lookup cache_md5[bf462b562c7507600791a2a1d52c0d33] finds 110. DEBUG: lookup cache_entries[Too Much Time][8][1154199720] finds nothing. DEBUG: lookup cache_md5[94d2fbc54f4b10ca14ef36b337a1c1bc] finds 111. DEBUG: lookup cache_entries[The Earth Must Be Destroyed][8][1154185402] finds nothing. DEBUG: lookup cache_md5[bd7b756670ce4d635f4e7e834fdb9f07] finds 112. DEBUG: lookup cache_entries[God Bless the Internet][8][1154111233] finds nothing. DEBUG: lookup cache_md5[47f64338c7aa2a52b1e8b90bedec30d6] finds 113. DEBUG: lookup cache_entries[Every Accent You'll Ever Need][8][1153873811] finds nothing. DEBUG: lookup cache_md5[6ccd4d113f4c9d257e3ec0105de30109] finds 114. DEBUG: lookup cache_entries[Shame on you, Owen Wilson][8][1153873269] finds nothing. DEBUG: lookup cache_md5[7c3df05c65a9088d2f954f13cbb95ad2] finds 115. DEBUG: lookup cache_entries[Tazer Glove][8][1153596434] finds nothing. DEBUG: lookup cache_md5[7762700af0d3bf3c143d373c0484f04a] finds 116. Finish feed. Read http://flickr.com/services/feeds/photos_public.gne?id=33538207@N00&tags=nyquilnetwork&format=rss_200. DEBUG: Current authorid = 6 DEBUG: parseDate(Sun, 19 Dec 2004 18:44:57 -0800) as 2004-12-19 18:44:57 (strtotime) DEBUG: pubDate Sun, 19 Dec 2004 18:44:57 -0800 = 1103510697 DEBUG: parseDate(Sun, 19 Dec 2004 18:11:45 -0800) as 2004-12-19 18:11:45 (strtotime) DEBUG: pubDate Sun, 19 Dec 2004 18:11:45 -0800 = 1103508705 DEBUG: parseDate(Sun, 19 Dec 2004 17:57:51 -0800) as 2004-12-19 17:57:51 (strtotime) DEBUG: pubDate Sun, 19 Dec 2004 17:57:51 -0800 = 1103507871 DEBUG: parseDate(Sun, 19 Dec 2004 17:43:27 -0800) as 2004-12-19 17:43:27 (strtotime) DEBUG: pubDate Sun, 19 Dec 2004 17:43:27 -0800 = 1103507007 DEBUG: parseDate(Sun, 19 Dec 2004 17:43:27 -0800) as 2004-12-19 17:43:27 (strtotime) DEBUG: pubDate Sun, 19 Dec 2004 17:43:27 -0800 = 1103507007 DEBUG: parseDate(Sun, 12 Dec 2004 17:05:24 -0800) as 2004-12-12 17:05:24 (strtotime) DEBUG: pubDate Sun, 12 Dec 2004 17:05:24 -0800 = 1102899924 DEBUG: parseDate(Tue, 7 Dec 2004 21:51:47 -0800) as 2004-12-07 21:51:47 (strtotime) DEBUG: pubDate Tue, 7 Dec 2004 21:51:47 -0800 = 1102485107 DEBUG: parseDate(Tue, 7 Dec 2004 21:21:05 -0800) as 2004-12-07 21:21:05 (strtotime) DEBUG: pubDate Tue, 7 Dec 2004 21:21:05 -0800 = 1102483265 DEBUG: parseDate(Tue, 7 Dec 2004 21:21:05 -0800) as 2004-12-07 21:21:05 (strtotime) DEBUG: pubDate Tue, 7 Dec 2004 21:21:05 -0800 = 1102483265 DEBUG: parseDate(Sun, 5 Dec 2004 15:07:02 -0800) as 2004-12-05 15:07:02 (strtotime) DEBUG: pubDate Sun, 5 Dec 2004 15:07:02 -0800 = 1102288022 DEBUG: parseDate(Sun, 5 Dec 2004 15:07:02 -0800) as 2004-12-05 15:07:02 (strtotime) DEBUG: pubDate Sun, 5 Dec 2004 15:07:02 -0800 = 1102288022 DEBUG: parseDate(Sun, 5 Dec 2004 14:05:05 -0800) as 2004-12-05 14:05:05 (strtotime) DEBUG: pubDate Sun, 5 Dec 2004 14:05:05 -0800 = 1102284305 DEBUG: parseDate(Sun, 5 Dec 2004 13:52:56 -0800) as 2004-12-05 13:52:56 (strtotime) DEBUG: pubDate Sun, 5 Dec 2004 13:52:56 -0800 = 1102283576 DEBUG: parseDate(Sun, 5 Dec 2004 13:40:56 -0800) as 2004-12-05 13:40:56 (strtotime) DEBUG: pubDate Sun, 5 Dec 2004 13:40:56 -0800 = 1102282856 DEBUG: parseDate(Sun, 5 Dec 2004 13:40:56 -0800) as 2004-12-05 13:40:56 (strtotime) DEBUG: pubDate Sun, 5 Dec 2004 13:40:56 -0800 = 1102282856 DEBUG: parseDate(Thu, 2 Dec 2004 23:18:41 -0800) as 2004-12-02 23:18:41 (strtotime) DEBUG: pubDate Thu, 2 Dec 2004 23:18:41 -0800 = 1102058321 DEBUG: parseDate(Thu, 2 Dec 2004 22:22:22 -0800) as 2004-12-02 22:22:22 (strtotime) DEBUG: pubDate Thu, 2 Dec 2004 22:22:22 -0800 = 1102054942 DEBUG: parseDate(Thu, 2 Dec 2004 22:22:22 -0800) as 2004-12-02 22:22:22 (strtotime) DEBUG: pubDate Thu, 2 Dec 2004 22:22:22 -0800 = 1102054942 DEBUG: parseDate(Thu, 2 Dec 2004 20:38:34 -0800) as 2004-12-02 20:38:34 (strtotime) DEBUG: pubDate Thu, 2 Dec 2004 20:38:34 -0800 = 1102048714 DEBUG: parseDate(Thu, 2 Dec 2004 20:23:38 -0800) as 2004-12-02 20:23:38 (strtotime) DEBUG: pubDate Thu, 2 Dec 2004 20:23:38 -0800 = 1102047818 DEBUG: lookup cache_entries[daisy water drops][6][1103510697] finds nothing. DEBUG: lookup cache_md5[be11dd274ce21e85191b9ffe772fc715] finds 60. DEBUG: lookup cache_entries[more droplets][6][1103508705] finds nothing. DEBUG: lookup cache_md5[174b076737b6bc3d59eaa47ef5131ebc] finds 61. DEBUG: lookup cache_entries[sunset lit leaves][6][1103507871] finds nothing. DEBUG: lookup cache_md5[bf26a9e08e15417fc1dc0cdab21032e7] finds 62. DEBUG: lookup cache_entries[sunset tree][6][1103507007] finds nothing. DEBUG: lookup cache_md5[33b5c461a9ed3825c14cd3071ddb35ef] finds 63. DEBUG: lookup cache_entries[sunset daisy][6][1103507007] finds nothing. DEBUG: lookup cache_md5[c6cb70e6ba26874982eaf072c41dd317] finds 64. DEBUG: lookup cache_entries[Glimmers][6][1102899924] finds nothing. DEBUG: lookup cache_md5[7f268204a6ba8910fc093fe8c51af0dc] finds 65. DEBUG: lookup cache_entries[nearly symmetrical][6][1102485107] finds nothing. DEBUG: lookup cache_md5[225265edb9cba382997f5b4a8721c644] finds 66. DEBUG: lookup cache_entries[cloudy clouds][6][1102483265] finds nothing. DEBUG: lookup cache_md5[1fa78506f864168cd6594210f3491149] finds 67. DEBUG: lookup cache_entries[frozen lit stuff][6][1102483265] finds nothing. DEBUG: lookup cache_md5[8b3e85382bf56442ff4a094fd495fb7b] finds 68. DEBUG: lookup cache_entries[fern radiating inwards][6][1102288022] finds nothing. DEBUG: lookup cache_md5[20fa9e18d964bccfdd008860a48bfab7] finds 69. DEBUG: lookup cache_entries[fern radiating outwards][6][1102288022] finds nothing. DEBUG: lookup cache_md5[ca5320e5774f1ac799ca9b97657a3d8d] finds 70. DEBUG: lookup cache_entries[reaching for the night sky][6][1102284305] finds nothing. DEBUG: lookup cache_md5[8c9ddede5c55be22e931e9a731e6c566] finds 71. DEBUG: lookup cache_entries[ugly flowers are still my favorite][6][1102283576] finds nothing. DEBUG: lookup cache_md5[5e99b26543646cbce80b5ead3da3e1ba] finds 72. DEBUG: lookup cache_entries[leaf over troubled water][6][1102282856] finds nothing. DEBUG: lookup cache_md5[32eae7b7896b93fd64f6a0d5382016ed] finds 73. DEBUG: lookup cache_entries[stumped][6][1102282856] finds nothing. DEBUG: lookup cache_md5[a564a51a44b399ce53799bc127d661ab] finds 74. DEBUG: lookup cache_entries[loves me - loves me not][6][1102058321] finds nothing. DEBUG: lookup cache_md5[872b06e023a08461cd9381e052115a6a] finds 75. DEBUG: lookup cache_entries[beautiful rubbish][6][1102054942] finds nothing. DEBUG: lookup cache_md5[ae243adba0b17beb032afbb26b8ed339] finds 76. DEBUG: lookup cache_entries[Bright Leaf - Dark Sky][6][1102054942] finds nothing. DEBUG: lookup cache_md5[59a9ecf0c8d02a8a1426e6c9916e7a67] finds 77. DEBUG: lookup cache_entries[ugly flowers are my favorite][6][1102048714] finds nothing. DEBUG: lookup cache_md5[a5a4faf589d6b3ba15ea1487a507b23c] finds 78. DEBUG: lookup cache_entries[old_barn][6][1102047818] finds nothing. DEBUG: lookup cache_md5[c74fb96d796e8d367592ae30604ea913] finds 79. Finish feed. Read http://alistair.nyquil.org/feeds/index.rss2. DEBUG: Current authorid = 3 DEBUG: parseDate(Sun, 13 Aug 2006 16:36:00 -0700) as 2006-08-13 16:36:00 (strtotime) DEBUG: pubDate Sun, 13 Aug 2006 16:36:00 -0700 = 1155512160 DEBUG: parseDate(Wed, 09 Aug 2006 19:54:45 -0700) as 2006-08-09 19:54:45 (strtotime) DEBUG: pubDate Wed, 09 Aug 2006 19:54:45 -0700 = 1155178485 DEBUG: parseDate(Sun, 21 May 2006 23:41:04 -0700) as 2006-05-21 23:41:04 (strtotime) DEBUG: pubDate Sun, 21 May 2006 23:41:04 -0700 = 1148280064 DEBUG: parseDate(Tue, 09 May 2006 18:16:46 -0700) as 2006-05-09 18:16:46 (strtotime) DEBUG: pubDate Tue, 09 May 2006 18:16:46 -0700 = 1147223806 DEBUG: parseDate(Fri, 21 Apr 2006 14:40:54 -0700) as 2006-04-21 14:40:54 (strtotime) DEBUG: pubDate Fri, 21 Apr 2006 14:40:54 -0700 = 1145655654 DEBUG: parseDate(Fri, 21 Apr 2006 12:31:08 -0700) as 2006-04-21 12:31:08 (strtotime) DEBUG: pubDate Fri, 21 Apr 2006 12:31:08 -0700 = 1145647868 DEBUG: parseDate(Sun, 16 Apr 2006 19:25:08 -0700) as 2006-04-16 19:25:08 (strtotime) DEBUG: pubDate Sun, 16 Apr 2006 19:25:08 -0700 = 1145240708 DEBUG: parseDate(Wed, 12 Apr 2006 21:52:47 -0700) as 2006-04-12 21:52:47 (strtotime) DEBUG: pubDate Wed, 12 Apr 2006 21:52:47 -0700 = 1144903967 DEBUG: parseDate(Tue, 11 Apr 2006 18:43:35 -0700) as 2006-04-11 18:43:35 (strtotime) DEBUG: pubDate Tue, 11 Apr 2006 18:43:35 -0700 = 1144806215 DEBUG: parseDate(Tue, 04 Apr 2006 19:48:30 -0700) as 2006-04-04 19:48:30 (strtotime) DEBUG: pubDate Tue, 04 Apr 2006 19:48:30 -0700 = 1144205310 DEBUG: lookup cache_entries[Man, I really don't want to travel now][3][1155512160] finds nothing. DEBUG: lookup cache_md5[6201114908ec7c83ae673f56ba1c993f] finds 133. DEBUG: lookup cache_entries[podcasting][3][1155178485] finds nothing. DEBUG: lookup cache_md5[8689b59b18b4c573afd6842391107b74] finds nothing. DEBUG: 'podcasting' is too old (1155178485 < 1155670328). DEBUG: lookup cache_entries[Jesus Christ: The Greatest Role Model Ever?][3][1148280064] finds nothing. DEBUG: lookup cache_md5[bc61d0fe24f0a633b3bd2b4621bdf97f] finds nothing. DEBUG: 'Jesus Christ: The Greatest Role Model Ever?' is too old (1148280064 < 1155670328). DEBUG: lookup cache_entries[No Child's Behind Left][3][1147223806] finds nothing. DEBUG: lookup cache_md5[c096639c9d656f5255af81a4fb6b1f41] finds nothing. DEBUG: 'No Child's Behind Left' is too old (1147223806 < 1155670328). DEBUG: lookup cache_entries[I'm Afraid of iTunes][3][1145655654] finds nothing. DEBUG: lookup cache_md5[e33428d93b9b23d7e4e79266f0cb0311] finds nothing. DEBUG: 'I'm Afraid of iTunes' is too old (1145655654 < 1155670328). DEBUG: lookup cache_entries[I used to respect you a lot more Matt and Trey][3][1145647868] finds nothing. DEBUG: lookup cache_md5[45473290ee492080ac55d54ac3e28b47] finds nothing. DEBUG: 'I used to respect you a lot more Matt and Trey' is too old (1145647868 < 1155670328). DEBUG: lookup cache_entries[It's All Up In The Air][3][1145240708] finds nothing. DEBUG: lookup cache_md5[7e88b8100db7a3fd91483b9141f4688a] finds nothing. DEBUG: 'It's All Up In The Air' is too old (1145240708 < 1155670328). DEBUG: lookup cache_entries[You're not just an idiot, you're a thief too][3][1144903967] finds nothing. DEBUG: lookup cache_md5[dc61d1477f2dcd0e3c95de35e0a0d43c] finds nothing. DEBUG: 'You're not just an idiot, you're a thief too' is too old (1144903967 < 1155670328). DEBUG: lookup cache_entries[RIP Meiko][3][1144806215] finds nothing. DEBUG: lookup cache_md5[fa4f5594feddf137d9638de24a978ac8] finds nothing. DEBUG: 'RIP Meiko' is too old (1144806215 < 1155670328). DEBUG: lookup cache_entries[freely available unencumbered][3][1144205310] finds nothing. DEBUG: lookup cache_md5[29ba0a9fb3c674d2b4621359be46bd55] finds nothing. DEBUG: 'freely available unencumbered' is too old (1144205310 < 1155670328). Finish feed. Finish planetarium. DEBUG: Expire cutoff 1155670328 DEBUG: Nothing to expire. DEBUG: MD5 Expire cutoff 1148153528 DEBUG: Nothing to expire. 

[garvinhicking]

Hi!

Thanks for that debug log!

Actually, the two entries that got updated have a different MD5 than their previous contents. This means that either the body or the title of that entry MUST have changed! Could it be that this is true? Because I can't explain why else the md5 checksum of body and title should be different?

Regards,
Garvin

[jerwarren]

Well, they both had been modified since the initial posting, but not since the aggregator had previously updated it. It is updating once an hour, plus all the times I'm doing it for debug purposes. I'm sitting here rerunning the aggregator over and over again, and every time it sees the post as new. It's not possible that the post could be changing between aggregator runs.

Here's a guess at what's happening:

1. I post the post.
2. The aggregator sees it.
3. I update the post.
4. The aggregator sees that it has been changed and updates the post, but the MD5 in the database remains unchanged.
5. The aggregator sees a post, checks the MD5 and sees that it is different (because the last one wasn't saved) even though it technically isnt and updates, but not the MD5.
6. Ad infinitum.

Is this possible?

[garvinhicking]

Hi!

This is very well possible. Great debugging! It would have taken me ages to spot that, I guess.

I just committed this patch to the aggregator:

Code: Select all

Index: serendipity_event_aggregator.php
===================================================================
RCS file: /cvsroot/php-blog/additional_plugins/serendipity_event_aggregator/serendipity_event_aggregator.php,v
retrieving revision 1.54
diff -u -r1.54 serendipity_event_aggregator.php
--- serendipity_event_aggregator.php    16 Aug 2006 11:08:17 -0000      1.54
+++ serendipity_event_aggregator.php    21 Aug 2006 12:29:22 -0000
@@ -47,7 +47,7 @@
             'php'         => '4.1.0'
         ));

-        $propbag->add('version',       '0.9');
+        $propbag->add('version',       '0.10');
         $propbag->add('author',       'Evan Nemerson, Garvin Hicking, Kristian Köhntopp, Thomas Schulz, Claus Schmidt'
);
         $propbag->add('stackable',     false);
         $propbag->add('event_hooks',   array(
@@ -874,6 +874,9 @@
         }

         $sql = "UPDATE {$serendipity['dbPrefix']}aggregator_feeds SET last_update = " . time() . " WHERE feedid = " .
(int)$feed['feedid'];
+        # Always update the MD5 hash, to catch updates of an entry properly. Patch by jerwarren!
+        $sql = "UPDATE {$serendipity['dbPrefix']}aggregator_md5   SET timestamp = '$t', md5='$md5hash' WHERE entryid =
 " . (int)$entryid;
+
         serendipity_db_query($sql);
     }

HTH,
Garvin