RSS Aggregator Problem

tpost · Post by **tpost** » Sat May 10, 2008 1:40 am

Hi everyone!

I have run into a problem.

I imported an RSS feed successfully with the "RSS Aggregator" plugin, then I deleted all the entries because they were posted with the wrong author name.

When I tried to re-import the same, exact feed, no entries were able to be imported.

With debug output turned on, this is what I get:

Code: Select all

DEBUG: cache_authors['realname'] = authorid has 7 entries DEBUG: cache_entries['title']['authorid']['timestamp'] = entryid has 0 entries. DEBUG: cache_md5['md5'] = entryid has 82 entries. Read http://www.tradingpostfinancial.com/Media/mind_trader_podcast.xml. DEBUG: Current authorid = 7 DEBUG: pubdate = Wed, 07 May 2008 17:30:00 PDT DEBUG: parseDate(Wed, 07 May 2008 17:30:00 PDT) as 2008-05-07 17:30:00 (strtotime) DEBUG: pubdate = Mon, 28 Apr 2008 20:00:00 PDT DEBUG: parseDate(Mon, 28 Apr 2008 20:00:00 PDT) as 2008-04-28 20:00:00 (strtotime) DEBUG: pubdate = Mon, 21 Apr 2008 19:40:00 PDT DEBUG: parseDate(Mon, 21 Apr 2008 19:40:00 PDT) as 2008-04-21 19:40:00 (strtotime) DEBUG: pubdate = Mon, 14 Apr 2008 19:30:00 PDT DEBUG: parseDate(Mon, 14 Apr 2008 19:30:00 PDT) as 2008-04-14 19:30:00 (strtotime) DEBUG: pubdate = Mon, 07 Apr 2008 20:30:00 PDT DEBUG: parseDate(Mon, 07 Apr 2008 20:30:00 PDT) as 2008-04-07 20:30:00 (strtotime) DEBUG: pubdate = Mon, 31 Mar 2008 18:15:00 PDT DEBUG: parseDate(Mon, 31 Mar 2008 18:15:00 PDT) as 2008-03-31 18:15:00 (strtotime) DEBUG: pubdate = Mon, 24 Mar 2008 14:45:00 PDT DEBUG: parseDate(Mon, 24 Mar 2008 14:45:00 PDT) as 2008-03-24 14:45:00 (strtotime) DEBUG: pubdate = Mon, 10 Mar 2008 15:30:00 PDT DEBUG: parseDate(Mon, 10 Mar 2008 15:30:00 PDT) as 2008-03-10 15:30:00 (strtotime) DEBUG: pubdate = Tue, 04 Mar 2008 18:50:00 PST DEBUG: parseDate(Tue, 04 Mar 2008 18:50:00 PST) as 2008-03-04 18:50:00 (strtotime) DEBUG: pubdate = Mon, 25 Feb 2008 16:10:00 PST DEBUG: parseDate(Mon, 25 Feb 2008 16:10:00 PST) as 2008-02-25 16:10:00 (strtotime) DEBUG: pubdate = Tue, 19 Feb 2008 13:10:00 PST DEBUG: parseDate(Tue, 19 Feb 2008 13:10:00 PST) as 2008-02-19 13:10:00 (strtotime) DEBUG: pubdate = Mon, 11 Feb 2008 13:45:00 PST DEBUG: parseDate(Mon, 11 Feb 2008 13:45:00 PST) as 2008-02-11 13:45:00 (strtotime) DEBUG: pubdate = Mon, 04 Feb 2008 15:00:00 PST DEBUG: parseDate(Mon, 04 Feb 2008 15:00:00 PST) as 2008-02-04 15:00:00 (strtotime) DEBUG: pubdate = Mon, 28 Jan 2008 18:15:00 PST DEBUG: parseDate(Mon, 28 Jan 2008 18:15:00 PST) as 2008-01-28 18:15:00 (strtotime) DEBUG: pubdate = Mon, 21 Jan 2008 18:35:00 PST DEBUG: parseDate(Mon, 21 Jan 2008 18:35:00 PST) as 2008-01-21 18:35:00 (strtotime) DEBUG: pubdate = Tue, 15 Jan 2008 16:35:00 PST DEBUG: parseDate(Tue, 15 Jan 2008 16:35:00 PST) as 2008-01-15 16:35:00 (strtotime) DEBUG: pubdate = Tue, 08 Jan 2008 18:15:00 PST DEBUG: parseDate(Tue, 08 Jan 2008 18:15:00 PST) as 2008-01-08 18:15:00 (strtotime) DEBUG: pubdate = Mon, 17 Dec 2007 16:15:00 PST DEBUG: parseDate(Mon, 17 Dec 2007 16:15:00 PST) as 2007-12-17 16:15:00 (strtotime) DEBUG: pubdate = Mon, 10 Dec 2007 15:00:00 PST DEBUG: parseDate(Mon, 10 Dec 2007 15:00:00 PST) as 2007-12-10 15:00:00 (strtotime) DEBUG: pubdate = Mon, 03 Dec 2007 19:30:00 PST DEBUG: parseDate(Mon, 03 Dec 2007 19:30:00 PST) as 2007-12-03 19:30:00 (strtotime) DEBUG: pubdate = Mon, 26 Nov 2007 17:30:00 PST DEBUG: parseDate(Mon, 26 Nov 2007 17:30:00 PST) as 2007-11-26 17:30:00 (strtotime) DEBUG: pubdate = Tue, 20 Nov 2007 20:30:00 PST DEBUG: parseDate(Tue, 20 Nov 2007 20:30:00 PST) as 2007-11-20 20:30:00 (strtotime) DEBUG: pubdate = Fri, 16 Nov 2007 15:00:00 PST DEBUG: parseDate(Fri, 16 Nov 2007 15:00:00 PST) as 2007-11-16 15:00:00 (strtotime) DEBUG: pubdate = Fri, 09 Nov 2007 15:00:00 PST DEBUG: parseDate(Fri, 09 Nov 2007 15:00:00 PST) as 2007-11-09 15:00:00 (strtotime) DEBUG: pubdate = Mon, 05 Nov 2007 20:00:00 PST DEBUG: parseDate(Mon, 05 Nov 2007 20:00:00 PST) as 2007-11-05 20:00:00 (strtotime) DEBUG: pubdate = Thu, 25 Oct 2007 20:00:00 PDT DEBUG: parseDate(Thu, 25 Oct 2007 20:00:00 PDT) as 2007-10-25 20:00:00 (strtotime) DEBUG: pubdate = Wed, 17 Oct 2007 19:00:00 PDT DEBUG: parseDate(Wed, 17 Oct 2007 19:00:00 PDT) as 2007-10-17 19:00:00 (strtotime) DEBUG: pubdate = Mon, 08 Oct 2007 11:30:00 PDT DEBUG: parseDate(Mon, 08 Oct 2007 11:30:00 PDT) as 2007-10-08 11:30:00 (strtotime) DEBUG: pubdate = Mon, 01 Oct 2007 14:30:00 PDT DEBUG: parseDate(Mon, 01 Oct 2007 14:30:00 PDT) as 2007-10-01 14:30:00 (strtotime) DEBUG: pubdate = Mon, 24 Sep 2007 13:45:00 PDT DEBUG: parseDate(Mon, 24 Sep 2007 13:45:00 PDT) as 2007-09-24 13:45:00 (strtotime) DEBUG: pubdate = Mon, 17 Sep 2007 12:30:00 PDT DEBUG: parseDate(Mon, 17 Sep 2007 12:30:00 PDT) as 2007-09-17 12:30:00 (strtotime) DEBUG: pubdate = Mon, 10 Sep 2007 17:00:00 PDT DEBUG: parseDate(Mon, 10 Sep 2007 17:00:00 PDT) as 2007-09-10 17:00:00 (strtotime) DEBUG: pubdate = Mon, 03 Sep 2007 11:30:00 PDT DEBUG: parseDate(Mon, 03 Sep 2007 11:30:00 PDT) as 2007-09-03 11:30:00 (strtotime) DEBUG: pubdate = Mon, 27 Aug 2007 12:03:00 PDT DEBUG: parseDate(Mon, 27 Aug 2007 12:03:00 PDT) as 2007-08-27 12:03:00 (strtotime) DEBUG: pubdate = Mon, 20 Aug 2007 11:28:00 PDT DEBUG: parseDate(Mon, 20 Aug 2007 11:28:00 PDT) as 2007-08-20 11:28:00 (strtotime) DEBUG: pubdate = Mon, 13 Aug 2007 11:30:00 PDT DEBUG: parseDate(Mon, 13 Aug 2007 11:30:00 PDT) as 2007-08-13 11:30:00 (strtotime) DEBUG: pubdate = Mon, 06 Aug 2007 11:30:00 PDT DEBUG: parseDate(Mon, 06 Aug 2007 11:30:00 PDT) as 2007-08-06 11:30:00 (strtotime) DEBUG: pubdate = Mon, 30 Jul 2007 11:30:00 PDT DEBUG: parseDate(Mon, 30 Jul 2007 11:30:00 PDT) as 2007-07-30 11:30:00 (strtotime) DEBUG: pubdate = Mon, 16 Jul 2007 11:30:00 PDT DEBUG: parseDate(Mon, 16 Jul 2007 11:30:00 PDT) as 2007-07-16 11:30:00 (strtotime) DEBUG: pubdate = Mon, 02 Jul 2007 11:30:00 PDT DEBUG: parseDate(Mon, 02 Jul 2007 11:30:00 PDT) as 2007-07-02 11:30:00 (strtotime) DEBUG: pubdate = Mon, 25 Jun 2007 11:30:00 PDT DEBUG: parseDate(Mon, 25 Jun 2007 11:30:00 PDT) as 2007-06-25 11:30:00 (strtotime) DEBUG: lookup cache_entries[MOT #41 - Building Strength From Your Losses][7][1210206600] finds nothing. DEBUG: lookup cache_md5[ec171e94bf85d86b2fcba07a9aed79e4] finds 306. DEBUG: lookup cache_entries[MOT #40 - A 3-Step Approach for Growth][7][1209438000] finds nothing. DEBUG: lookup cache_md5[aaf000bb36b4746ff55375ba281ad9ec] finds 307. DEBUG: lookup cache_entries[MOT #39 - The Beach Ball][7][1208832000] finds nothing. DEBUG: lookup cache_md5[4da1b80a84563bbeabbc0a9e2db7bac7] finds 308. DEBUG: lookup cache_entries[MOT #38 - The Daffodil Principle][7][1208226600] finds nothing. DEBUG: lookup cache_md5[5ed1b8c966f21806c4fb98d24a4e0da9] finds 309. DEBUG: lookup cache_entries[MOT #37 - The Measuring Stick][7][1207625400] finds nothing. DEBUG: lookup cache_md5[903919a1c19e7b23a32d6620e6a36eb2] finds 310. DEBUG: lookup cache_entries[MOT #36 - The Power of a Safety Net][7][1207012500] finds nothing. DEBUG: lookup cache_md5[7d20a619db380db86985d039bc205b9d] finds 311. DEBUG: lookup cache_entries[MOT #35 - Building a Winning Momentum][7][1206395100] finds nothing. DEBUG: lookup cache_md5[c1d38067bcd2c6e9ca1f0c7435ae798e] finds 312. DEBUG: lookup cache_entries[MOT #34 - The Miracle on Ice][7][1205188200] finds nothing. DEBUG: lookup cache_md5[fbabf39cb4074c22bc1e0eca304fb828] finds 313. DEBUG: lookup cache_entries[MOT #33 - Commit to... "A Little Bit More"][7][1204685400] finds nothing. DEBUG: lookup cache_md5[c01a55804e773831977bc6448bc20163] finds 314. DEBUG: lookup cache_entries[MOT #32 - The Mental Side - Method Commitment & Mentoring Approach][7][1203984600] finds nothing. DEBUG: lookup cache_md5[5357ec515bbe65392247ed99f62241f4] finds 315. DEBUG: lookup cache_entries[MOT #31 - Are You Focused?][7][1203455400] finds nothing. DEBUG: lookup cache_md5[659ef3d32eace6e1d66970d590a09081] finds 316. DEBUG: lookup cache_entries[MOT #30 - How Do You Approach Trading?][7][1202766300] finds nothing. DEBUG: lookup cache_md5[1c9c0cf5ed14e57bf55de8c44478f57d] finds 317. DEBUG: lookup cache_entries[MOT #29 - Don't Just Make A Plan... Follow It][7][1202166000] finds nothing. DEBUG: lookup cache_md5[944bc716f3d895c62022d4708da3c5eb] finds 318. DEBUG: lookup cache_entries[MOT #28 - A Decision to Change - Is this Good or Bad?][7][1201572900] finds nothing. DEBUG: lookup cache_md5[3e9110704cc370387ca6f63379342670] finds 319. DEBUG: lookup cache_entries[MOT #27 - 5 Simple Principles][7][1200969300] finds nothing. DEBUG: lookup cache_md5[e60e00f32837db985b21f1d769fa9dcb] finds 320. DEBUG: lookup cache_entries[MOT #26 - Aim Small, Miss Small][7][1200443700] finds nothing. DEBUG: lookup cache_md5[c3ee1a5cee9e5593d08e9f7eed7dd6f1] finds 321. DEBUG: lookup cache_entries[MOT #25 - Review and Refine][7][1199844900] finds nothing. DEBUG: lookup cache_md5[8655fc6f6f31cd5528e3cf6c0ea0c3b4] finds 322. DEBUG: lookup cache_entries[MOT #24 - Is Your Trading Camera in Focus?][7][1197936900] finds nothing. DEBUG: lookup cache_md5[1aa907c409abc2c3819340379e71adf9] finds 323. DEBUG: lookup cache_entries[MOT #23 - Positive Expectancy in Your Trading][7][1197327600] finds nothing. DEBUG: lookup cache_md5[713baf54915f19d8bd2b7cf2c4edf3a0] finds 324. DEBUG: lookup cache_entries[MOT #22 - Words Are Very Powerful][7][1196739000] finds nothing. DEBUG: lookup cache_md5[70d37dbd7b4f41fce456065755d3db7c] finds 325. DEBUG: lookup cache_entries[MOT #21 - 4 Basic Steps][7][1196127000] finds nothing. DEBUG: lookup cache_md5[ea4e64704600372f83970a8491baf4f1] finds 326. DEBUG: lookup cache_entries[MOT #20 - Trading Needs to be Approached as a Business][7][1195619400] finds nothing. DEBUG: lookup cache_md5[0ccdceca257600e3ce99936b5919793d] finds 327. DEBUG: lookup cache_entries[MOT #19 - Red Light... Green Light... Yellow Light][7][1195254000] finds nothing. DEBUG: lookup cache_md5[afb8bae88028fee28967fdc22f4d2ad3] finds 328. DEBUG: lookup cache_entries[MOT #18 - How Important is the Weakest Link?][7][1194649200] finds nothing. DEBUG: lookup cache_md5[66356748251cf9f4174d98154215a995] finds 329. DEBUG: lookup cache_entries[MOT #17 - A Shortcut Rarely Yields a Path Towards Success][7][1194321600] finds nothing. DEBUG: lookup cache_md5[f4b99401e0ed07421ce31c733a03bd89] finds 330. DEBUG: lookup cache_entries[MOT #16 - Warp Speed or Turtle Speed?][7][1193367600] finds nothing. DEBUG: lookup cache_md5[622360d09aeeb390d30672e8969f3707] finds 331. DEBUG: lookup cache_entries[MOT #15 - Have you Asked Yourself... Why?][7][1192672800] finds nothing. DEBUG: lookup cache_md5[be5351346928d8295796f13aa30bc1b5] finds 332. DEBUG: lookup cache_entries[MOT #14 - Your Formula for Success Needs a GPS][7][1191868200] finds nothing. DEBUG: lookup cache_md5[c2b3bebe9af07c563820c4fc4a5ba654] finds 333. DEBUG: lookup cache_entries[MOT #13 - The Little Engine That Could][7][1191274200] finds nothing. DEBUG: lookup cache_md5[d0ea8fa0d22c66be9651e474195702b6] finds 334. DEBUG: lookup cache_entries[MOT #12 - Mistakes Can Be Your Path to Success][7][1190666700] finds nothing. DEBUG: lookup cache_md5[1fe6efd1cf8fa9b84ed138e06199d7ed] finds 335. DEBUG: lookup cache_entries[MOT #11 - Steve's 10 Commandments for Trading][7][1190057400] finds nothing. DEBUG: lookup cache_md5[0607c63e9032d93d522ca86898180e25] finds 336. DEBUG: lookup cache_entries[MOT #10 - How to Become A Successful Losing Trader][7][1189468800] finds nothing. DEBUG: lookup cache_md5[d3655e8b8dbb0e049dd3c3d3c2b5fd70] finds 337. DEBUG: lookup cache_entries[MOT #9 - Taking Risk or Being Cautious... Which is Best?][7][1188844200] finds nothing. DEBUG: lookup cache_md5[0741b8ee5d35b8b371abaa4d6eaa4bd2] finds 338. DEBUG: lookup cache_entries[MOT #8 - A Fresh Perspective Provides Successful Trading Session][7][1188241380] finds nothing. DEBUG: lookup cache_md5[eae27d3b4177e21d765b9c745ab96db6] finds 339. DEBUG: lookup cache_entries[MOT #7 - Moderation and Patience is the Secret to Survival][7][1187634480] finds nothing. DEBUG: lookup cache_md5[c0736fddc0e48addb3c8f906bdaaa309] finds 340. DEBUG: lookup cache_entries[MOT #6 - August 13, 2007][7][1187029800] finds nothing. DEBUG: lookup cache_md5[38fa346acafbff5d078b4d206c49a45b] finds 341. DEBUG: lookup cache_entries[MOT #5 - August 6, 2007][7][1186425000] finds nothing. DEBUG: lookup cache_md5[1b334a7fed0661b18d8cd8ca794a4799] finds 342. DEBUG: lookup cache_entries[MOT #4 - July 30, 2007][7][1185820200] finds nothing. DEBUG: lookup cache_md5[63f39046fcda96c9e01d6cc8f155a358] finds 343. DEBUG: lookup cache_entries[MOT #3 - July 16, 2007][7][1184610600] finds nothing. DEBUG: lookup cache_md5[84e414d002143e10e9f81ee468358c2d] finds 344. DEBUG: lookup cache_entries[MOT #2 - July 2, 2007][7][1183401000] finds nothing. DEBUG: lookup cache_md5[683993e616e872a898be0795114bb890] finds 345. DEBUG: lookup cache_entries[MOT #1 - June 25, 2007][7][1182796200] finds nothing. DEBUG: lookup cache_md5[7b9e2b06765eb91fd891cb77bd79fe84] finds 346. Finish feed. Finish planetarium.

The debug shows something about cache_md5.

Maybe I have the wrong settings set for "Expire content" and "Expire checksums". Right now, I have that set to "0".

I also clicked on "Build cached entries" by accident , instead of "RSS Aggregator"... this might be the problem... but I have no idea how to fix it!

Any help is appreciated!

Thanks!

tpost · Post by **tpost** » Sat May 10, 2008 4:01 am

Update: I have deleted the feed from the RSS Aggregator plugin and have manually updated the aggregator with the debugger turned on.

I still get this output:

Code: Select all

DEBUG: cache_authors['realname'] = authorid has 7 entries DEBUG: cache_entries['title']['authorid']['timestamp'] = entryid has 0 entries. DEBUG: cache_md5['md5'] = entryid has 82 entries. Finish planetarium.

FYI for the above output, I had set "Expire content" and "Expire checksums" set to "0", but I just changed them both to "1" so they will hopefully expire in a day!

But here's a question, how do you manually empty the cache for the aggregator plugin?

I think once I can empty the cache I can re-use the aggregator again without any errors.

Thanks!

Post by **Don Chambers** » Sat May 10, 2008 5:02 am

Try removing all records from the table serendipity_aggregator_md5, then re-aggregate.

FYI - the author name will be set to the "Feed name" in the aggregator (aggreVATOR?) plugin.

tpost · Post by **tpost** » Sat May 10, 2008 7:52 am

Hey Don,

It's Ray from your optional-necessity blog!

If I had access to edit on MySQL, I would do so... i guess i'll have to wait until Monday! I wish there was a built-in function for the plugin though...

Digging the new nickname for the plugin

lol