Hi there,

I am trying to add a feed to the news aggregator and it will not add. I fill out the form at admin/content/aggregator/add/feed with:

Title: Google Body Piercing News

URL: http://news.google.com/news?q=body+piercing&output=rss

When it hit "Submit" the page just spins and spins and never changes and the feed never gets added. Any ideas?

-Drew

Comments

drubage’s picture

drubage commented
Project: Drupal core » Aggregation
Version: 5.6 » 5.x-4.3
Component: aggregator.module » Code
Ashraf Amayreh’s picture

Ashraf Amayreh commented
Project: Aggregation » Drupal core
Version: 5.x-4.3 » 5.6
Component: Code » aggregator.module

I think this belongs here, not in the aggregation module's queue.

The aggregation module is a separate module from drupal's aggregator module.

mustafau’s picture

mustafau commented
Status: Active » Postponed (maintainer needs more info)

Do you still have this issue?

drubage’s picture

drubage commented

Yes but I am able to add them manually to the database.

ainigma32’s picture

ainigma32 commented

@drubage: can you confirm this problem still exists in 5.12 ?

- Arie

s_oneill’s picture

s_oneill commented

I'm having the same problem. Just enabled the core aggregator module to day and I've tried adding this feed:

http://feeds.feedburner.com/wolterskluwer/spine/toccurrentrss

(I get the link from this page: http://www.spinejournal.com/pt/re/spine/rss.htm;jsessionid=J1KMsnVr0ldtt...)

Tried a couple of other URLs as well ... no better.

I add the details in Home >> Administer >> Contents management >> News aggregator >> Add Feed

I just hangs ... waiting for http://my.site

If I leave it for a while and the cancel the operation and check the Home >> Administer >> Contents management >> News aggregator >> List .... nothing has been added. (I've run cron once - no help there either).

drubage’s picture

drubage commented

I am on Drupal 5.6 now I can't upgrade any more right now without major work so I cannot confirm but we do still have the problem. I was able to add feeds manually to the database to at least get 1 in there but it's not ideal.

-Drew

ainigma32’s picture

ainigma32 commented

@drubage, @s_oneill: can you confirm this issue is still current and could please post what version of Drupal you are using?

- Arie

drubage’s picture

drubage commented

Still cannot add any feeds. We are on 5.14 now.

s_oneill’s picture

s_oneill commented

ainigma32 -- I upgraded the whole thing to 6.8 and I have no problems now (except the headers are too long) ....

ainigma32’s picture

ainigma32 commented

@s_oneill: Good for you (apart from the headers...)
Now all we need is some good news from drubage so we can close this puppy :-)

- Arie

drubage’s picture

drubage commented

Still not able to add feeds. So I go to add a feed and it spins and spins and then comes back with an error about MySQL being gone with errors like this...

Warning: MySQL server has gone away query: SELECT * FROM system WHERE type = 'theme' in D:\tribalectic\Drupal\includes\database.mysqli.inc on line 169

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Lost connection to MySQL server during query\nquery: INSERT INTO aggregator_feed (fid, title, url, refresh, block) VALUES (21, 'Yahoo Body Piercing News', 'http://news.search.yahoo.com/news/rss?p=body+piercing&ei=UTF-8&f..., 3600, 5) in D:\\tribalectic\\Drupal\\includes\\database.mysqli.inc on line 169.', 2, '', 'http://www.tribalectic.com/Drupal/admin/content/aggregator/add/feed', 'http://www.tribalectic.com/Drupal/admin/content/aggregator/add/feed', '24.8.189.152', 1233595218) in D:\tribalectic\Drupal\includes\database.mysqli.inc on line 169

And there's tons of lines just like the above watchdog one and they keep getting generated as the page loads. I added some debug info into the aggregator module and get this output:

in aggregator_save_feed (this gets printed as the function is entered)
ADDING FEED! (this gets printed in the if...then section where it says "else if ($edit['title']) {" which is where see an INSERT statement for feeds)

The next lines are the value of $edit in the function aggregator_save_feed right before the INSERT statement:

Array ( [title] => Yahoo Body Piercing News [url] => http://news.search.yahoo.com/news/rss?p=body+piercing&ei=UTF-8&fl=0&x=wrt [refresh] => 3600 [op] => Submit [submit] => Submit [form_token] => 0417e1f485ed9afd4df35daa3caa37eb [form_id] => aggregator_form_feed [fid] => 22 )

FYI nothing gets added to the aggregator_feed table. There's one entry in there which I manually added to MySQL but the fid for that entry is 18. Any ideas?

-Drew

ainigma32’s picture

ainigma32 commented

There are a couple of reasons why "Mysql went away" but the two most common are trying to send a query to MySQL that is too large or a timeout.

In this case I think MySQL is timing out. You could try adding mysqli.reconnect = On to php.ini or ask your host to add it if you can't do that yourself.

- Arie

ainigma32’s picture

ainigma32 commented

@drubage: Any progress on this? Or are you still struggling ;-)

- Arie

ainigma32’s picture

ainigma32 commented
Status: Postponed (maintainer needs more info) » Fixed

Looks like drubage won't be posting any feedback so I'm setting this to fixed.

Feel free to reopen if you think that is wrong.

- Arie

drubage’s picture

drubage commented

Sorry about that, thought I had responded. NO I cannot add any feeds unless I manually add them via a MySQL program like MySQL Administrator.

ainigma32’s picture

ainigma32 commented
Status: Fixed » Postponed (maintainer needs more info)

OK. Did you try the fix in #13 ?

- Arie

drubage’s picture

drubage commented

It is not timing out, the query is just not being executed. I have no idea why, all other tables run fine. I was able to make it show me the query it was getting stuck on and it was the insert. If I ran the insert myself via query analyzer it works fine so it just makes no sense.

ainigma32’s picture

ainigma32 commented

AFAIK It's not a single query that is timing out. The problem is that Drupal is doing a number of queries in a row but there is too much time between the query before the insert and the insert query. The mysqli.reconnect=On setting should make the session reconnect in such a situation.

Regardless, it's worth the try isn't it?

- Arie

drubage’s picture

drubage commented

OK, I changed that value on php.ini and confirmed that it took by looking at my phpinfo. Now when I go to add a feed I get this error:

user warning: Field 'description' doesn't have a default value query: INSERT INTO aggregator_feed (fid, title, url, refresh, block) VALUES (23, 'Yahoo Body Piercing News', 'http://news.search.yahoo.com/news/rss?p=body+piercing&ei=UTF-8&fl=0&x=wrt', 3600, 5) in D:\tribalectic\Drupal\includes\database.mysqli.inc on line 169.

ainigma32’s picture

ainigma32 commented

Sounds a lot like this issue: http://drupal.org/node/201427

Apparently it's caused by MySQL running in strict mode.

So you can try to have MySQL run in "non-strict" mode or you can modify the aggregator module with the patch from the issue above.

- Arie

drubage’s picture

drubage commented

I tried the patch and it seems to be fixed, thanks all!

ainigma32’s picture

ainigma32 commented
Status: Postponed (maintainer needs more info) » Fixed

Yay!

- Arie

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.