?Feed data not populating db

web2pro · Joined: 13 Feb 2008 Posts: 8

I don't think my set-up is working.

Ok I went through the set-up process, left everything standard, removed the "sample" from DB config file, and rss2sql Config.php file.

proved connectivity, logged in as admin, and have added 6 feeds, if I go to phpmyadmin, I can see all the DB structure with the two tables etc.

My problem seems to be the updates, there is no data in the tables, other than the feed URLS, last & next update shows 0000-00-00 00:00:00 and update count is 0.

I have tried to force the update with mydomain/admin/rss2sql/rss2sql.php?feedID=1
and other feeds also.. stil no update dates.

Please Advice

Regards

web2pro · Joined: 13 Feb 2008 Posts: 8

Four days of waiting for a reply is not a very good advertisement for this script.. I was sure that my problem was a simple one to answer for the coder of this script, but waiting and waiting, and searching the forum I finally found the answer I was looking for.

YOUR documentation that is enclosed with the script, is listed, numbered to a parrot fasion for somebody to follow.. however, you failed to mention in the documentation one VERY important factor... After adding the RSS Feed url to the Database, the documentation stats on line 19.

19) To cause the feed to be parsed and stored in the database use rss2sql.php

Example: http://www.FeedForAll.com/rss2sql.php

It fails to mention that you should type the following at the end:-

Example: http://www.FeedForAll.com/sql2rss.php?CONFIGFILE=sql2rss_Config.php

MacSupport · Joined: 24 Feb 2005 Posts: 2805

web2pro wrote:

I don't think my set-up is working.

Ok I went through the set-up process, left everything standard, removed the "sample" from DB config file, and rss2sql Config.php file.

proved connectivity, logged in as admin, and have added 6 feeds, if I go to phpmyadmin, I can see all the DB structure with the two tables etc.

My problem seems to be the updates, there is no data in the tables, other than the feed URLS, last & next update shows 0000-00-00 00:00:00 and update count is 0.

I have tried to force the update with mydomain/admin/rss2sql/rss2sql.php?feedID=1
and other feeds also.. stil no update dates.

Please Advice

Regards

You need to have http://yourdomaine.com/rss2sql.php called automatically every few minutes to have it update.

Jim

softandina · Joined: 14 Jul 2012 Posts: 2 Location: Argentina

Hi People !, ok, The connectivity to the mysql db is Ok, the rss that i use to add , have a lot of items (with an external rss reader found OK, show the items), and when i execute rss2sql.php, manually (or using the option rss2sql.php?CONFIGFILE=sql2rss_config.php) after of execute it, don't show items or data in rss2sql_admin.php, or executing the rss2sql.php only, when using the phpmyadmin don't visualizing any results like the rss2sql don't work,,what im'doing wrong ?, please help boys !.

softandina · Joined: 14 Jul 2012 Posts: 2 Location: Argentina

i forgot, the test was make with an a local mysql database and a local apache2 web server, yes, the scripting (php files) work very well.

FeedForAll Sales · Joined: 10 Jun 2009 Posts: 249

Glad the script is working well.