I have thanked you already but ile say it again thankyou lol.
I have just added a rss feed but i put the wrong member to show who has posted the feeds so i had to delete the feed posts on my forum and i have now re added another feed but now its not reposting what i have deleted.
Also when it posts it says
A TORY councillor who defected from Labour was today suspended from his new party after making a homophobic comment on his Facebook website.
Source: [url=http://www.wirralnews.co.uk/wirral-news/local-wirral-news/2010/03/31/wirral-councillor-suspended-for-anti-gay-facebook-update-100252-26144094/]Wirral councillor suspended for 'anti-gay' Facebook update[/ url]
Well, that's expected behavior, it should try NOT to repost anything; there is a field in the database that holds the timestamp of the last time it "grabbed" the feed and it'll attempt not to repost anything before that timestamp.
You could try this query:
Code
UPDATE `your_db`.`prefix_TOPIC_FEEDS` SET `LAST_BUILD` = '0', `LAST_TOPIC_TIME` = '0' WHERE `prefix_TOPIC_FEEDS`.`FEED_ID` =1;
As for the link, on what you posted it has a space before the end tag at the end, is that what it's doing on your site? could you link me to a story?
Well, that's expected behavior, it should try NOT to repost anything; there is a field in the database that holds the timestamp of the last time it "grabbed" the feed and it'll attempt not to repost anything before that timestamp.
You could try this query:
Code
UPDATE `your_db`.`prefix_TOPIC_FEEDS` SET `LAST_BUILD` = '0', `LAST_TOPIC_TIME` = '0' WHERE `prefix_TOPIC_FEEDS`.`FEED_ID` =1;
As for the link, on what you posted it has a space before the end tag at the end, is that what it's doing on your site? could you link me to a story?
No i had to leave a space or it would of posted correctly lol. Its just posting on my website like that instead of the proper link.
Also just tried that code above and it says SQL Error: Table 'web180-forum-2.prefix_TOPIC_FEEDS' doesn't exist
Is the source feed updating more than once a day? I know a lot of sites cache out their feed in the early morning and only do it once a day...
Its doing it once a day and thats it but when i look at the feed there is more news which could be added. When i had Vbulletin it updated every 10 mins
(SORRY CAN THIS BE MOVED TO THE RSS FEED, I POSTED IN WRONG THREAD.)
I don't receive any feeds. I added the lines in the source as described and added the files but nothing happens. Any idea how to check whether it is working right?
I am trying to post earthquake updates from USGS. the feed is live, so at 15 minutes I should be seeing posts, but nothing.
Its now started working
Is there a way it can post some of the data from the source, rather than a link just to it? The link is good at the bottom, but I want some of the data on the post rather than just a link.
Well, your problem from your feed is that they're using the description tag to roll out the date versus providing data on the page itself; the description tag is what gets parsed by this script.
They should be using the pubdate variable to publish the date, and the description variable to provide data on the link.
Also there is a bug. Any posts made by the fetching, keep the date of where the source is. This means twitter never picks them up as they are old as my forum is UTC+11.
The posts need to have the current time and date just like they were posted by a person.
The RSS feed parses what it's supposed to; their feed displays data in a manner that isn't what the RSS spec says it should.
As for the ATOM feed, this script isn't designed to parse that at all... That's why it's politely ignored.
Basically it reads the title, description, and pubdate; description should hold data about the link, the title is the title of the story, and the pubdate should be the date associated with it.
RSS Feed for AUS-CITY NATO Press Releases http://www.aus-city.com/ubbthreads/ubbthreads.php RSS Feed for AUS-CITY NATO Press Releases AUS-CITY Message Forums - UBB.threads(tm) Remarks by Secretary Panetta at Ali Al Salem Air Base, Kuwait http://www.aus-city.com/ubbthreads/ubbthreads.php?ubb=showflat&Number=135168#Post135168 Webmaster:
]]>
Wed, 12 Dec 2012 23:05:51 GMT
Visit to NATO by the Prime Minister of the Netherlands http://www.aus-city.com/ubbthreads/ubbthreads.php?ubb=showflat&Number=135066#Post135066 Webmaster:
]]>
Wed, 12 Dec 2012 22:44:40 GMT
Secretary General condemns North KoreaÂ’s rocket launch http://www.aus-city.com/ubbthreads/ubbthreads.php?ubb=showflat&Number=135020#Post135020 Webmaster:
]]>
Wed, 12 Dec 2012 14:44:42 GMT
Euro-Atlantic Partnership Council pays respect to late Ambassador Milinkovic of Serbia http://www.aus-city.com/ubbthreads/ubbthreads.php?ubb=showflat&Number=134763#Post134763 Webmaster:
]]>
Tue, 11 Dec 2012 16:05:20 GMT
North Atlantic Council expresses concern about North KoreaÂ’s intent to launch a ballistic missile http://www.aus-city.com/ubbthreads/ubbthreads.php?ubb=showflat&Number=133696#Post133696 Webmaster:
]]>
Wed, 05 Dec 2012 20:11:48 GMT
Remarks by Secretary Panetta at Walter Reed National Military Medical Center, Washington, D.C. http://www.aus-city.com/ubbthreads/ubbthreads.php?ubb=showflat&Number=133562#Post133562 Webmaster:
]]>
Tue, 04 Dec 2012 23:06:53 GMT
NATO Foreign Ministers's statement on Patriot deployment to Turkey http://www.aus-city.com/ubbthreads/ubbthreads.php?ubb=showflat&Number=133561#Post133561 Webmaster:
]]>
Tue, 04 Dec 2012 23:01:54 GMT
Remarks by Deputy Secretary Carter at the Cooperative Threat Reduction Symposium at National Defense University, Washing http://www.aus-city.com/ubbthreads/ubbthreads.php?ubb=showflat&Number=133421#Post133421 Webmaster:
]]>
Tue, 04 Dec 2012 12:59:34 GMT
Remarks by Deputy Secretary Carter at the Von der Heyden Fellows Program Endowment Fund Lecture Series at Duke Universit http://www.aus-city.com/ubbthreads/ubbthreads.php?ubb=showflat&Number=132736#Post132736 Webmaster:
]]>
Fri, 30 Nov 2012 19:47:07 GMT
NATO Press Release(2012)147 - Visit to NATO by the Minister of Foreign Affairs of Pakistan http://www.aus-city.com/ubbthreads/ubbthreads.php?ubb=showflat&Number=132716#Post132716 Webmaster:
I thought it was the Topic Creator at fault as our twitter updates stopped. But as it turned out it was working, but the template in the update from ubbthreads has the extra space that was corrupting the RSS feeds, and hence no twitter updates from the forum.
I added the fault to the thread in ubbthreads/bugs, so it should be moved to a known bug and the template file fixed in the zip.
It SHOULD post the entire body of the "description" field of the feed in question; if the feed truncates the display (which they commonly do) you can't import what's not there...
I did not write this script, I simply ported it up through the v7.4 system in 2010; you're going to have to try it out yourself to see if it works as I don't have it configured anywhere.
I can tell you that very little has changed in the database from v7.5.9 and v7.6; so if it was working in v7.5.9 for you it should continue to do so once it's reinstalled on v7.6.0.
RSS Topic Creator 1.2 - Updated for UBB.threads 7.7.0+
If you had been running version 1.1, your topics were being prevented from displaying on the News Portal. This release fixes that 1.1 bug, along with several other minor issues such as encoding corrections and images within the RSS feed, especially html5 img tags, and respecting responsive design guidelines.
Run the following SQL from Control Panel / Database Tools / SQL Command to retroactively correct the News Portal bug from version 1.1
Fix missing TOPIC_STATUS created by RSS Topic Creator 1.1
SQL Query
UPDATE ubbt_TOPICS SET TOPIC_STATUS = 'O' WHERE TOPIC_STATUS ISNULL
Thanks guys. I have made the necessary entries into the templates / php and created the new table. How long does it take to start populating? Within 30 mins ?
IIRC as long as the cache time of the feed has passed it should insert data; this should trigger when there is activity on the forum (the file is called on every page view)... So if you've never inserted data and the feeds are valid it should insert data as soon as a page on the main forum is accessed.
This script is simple and maintained just as required, so your mileage will vary.
Sorry, I do not do support in private messaging. More people can benefit from a support reply by making it public, keeping related questions within the correct thread, and on the correct domain.
From your PM to me on UBBCentral.com:
Originally Posted by Mors
Hi Issac,
I did the 1.2 upgrade on the script and I finally figured out I needed to assign a posting user. I got all that setup including creating my new topic feeds table etc.. all that went great.
It's still not posting yet. If I had you look at things what would you want to charge ?
Don't have lots of time and willing to pay for your services :)
If you added cache_builders/rss_topic_creator.php to your footer file, the RSS feed will update when your page footer is viewed and the "Feed Update Interval" timer expires.
You can view ubbt_TOPIC_FEEDS to see what is/is not happening. I believe that if you set LAST_BUILD to 0, the script force itself to run again.
If nothing is populating the database, you may have any of the following issues. 1/ Source feed is ATOM and not RSS 2.0. 2/ Source feed has an error in it. 3/ Source feed is empty. 4/ You are using a bad URL. 5/ You missed part of the directions within the rss_topic_creator.txt documentation. 6/ You have not set a User ID that the feeds should be posted by. 7/ You have not set a forum to put the feeds in to. 8/ Your "Format Of The Posts" is empty or incorrect. 9/ The Topic Feed is not enabled.
TIP: Create an RSS TEST FORUM so you can repete your feed fetches until you have them displaying exactly as you desire. Then you can easily delete the entire forum and all of your test posts in a single swoop of deleting that entire forum. You can also prune your tests with Control Panel > Prune Threads.
But first things first, watch your ubbt_TOPIC_FEEDS database to see if it is getting populated upon 1/ refreshing of a forum page with a footer (usually category page is easiest to do) 2/ setting LAST_BUILD to 0 to the feed in the database.
Ya ok they are atom feeds.. I need to find the same feeds in RSS 2.0 OR better yet you build atom capable switching formats and I buy it. :) Need to know costs..
1/ You could modify the script to support ATOM instead of RSS. 2/ You could modify the script to do #1, and along side the current RSS script, so you'll have two different processors. 3/ You could install a 3rd party feed agitator that exports everything in to an RSS 2.0 template.
I currently do #3 using https://tt-rss.org/ This also gives me the benefit of having feeds from multiple sources with hundreds of posts daily. Then applying a filter, for example, "Pixel" or "Nexus" and must include "Google." Then the UBB.threads RSS Topic Creator only downloads those items from custom feed that TTRSS made for me, with its own URL, in RSS 2.0 format.
LOL I keep finding out more and more haha :) I will look into your suggestion.. I am trying to get a rss 2.0 to work right now before I look at other options
You have to remember I haven't had a working forum in like 10 plus years :) I am slowly getting back into it.
While there are many initial intents for providing/serving RSS feeds, please keep in mind that that the RSS TOPIC CREATOR script provides something that is somewhat of a grey area with respect to taking someone elses content, hosting it on your server, and presenting it as your own content.
RSS is for news syndication. Not free web content for your website.
Game scores, weather, news snippets pointing back to the source...etc. Basically being responsible with the content someone else created and is sharing.
as far as your other question on who can write this for you, feel free to open the script and look at its bits. the script is rather short. Pull up a sample RSS 2.0 and ATOM (rss/xml) file and read them. its straight forward.
its one of those things where once you set it up and it is working, there is no further adjustments needed its low level "take from column A put in to column B." stuff.
If I wanted to figure out why it's just not doing anything, though the topic feed shows up as enabled and it's standard WordPress RSS2 (?feed=rss2), and works in desktop RSS viewers - what would I do? Is there a good place to put in a "log errors" command?
... also, instructions here suggest changing the nulls in the topics to 0s or Os. Any new topic appears as a null, though. If I change it, it seems to lock the topic.
Prior versions of the script will not work on current UBB.threads. You need to be using the current version of RSS Topic Creator with current versions of UBB.threads.
It sounds like you're using v1.1 from the OP, which is a direct port of Ian's original; instead you should be using Isaac's v1.2 which includes bugfixes and further upgrades for compatability.
Also, ensure you're not trying to use an ATOM feed, ATOM and RSS are different structures and this script (by default) will parse RSS only.
I just moved my server. The Topic Creator was running fine on the old server. Its running CentOS7 so old stuff.
New one is RedHat 9. Now I'm running old php for ubbthreads and the restored back runs perfectly. Everything runs, except the Topic Creator isn't creating posts off the feeds.
I'm suspecting I'm missing a php or perl library it needs for downloading, etc.
Can you give me all the required libraries please? I had issues getting dadamail but found those in the program itself so that's easy.
Issue was the domain its-self was running php 7.4, but the servers root didn't have php installed as it isn't serving out anything. But as cron runs some jobs there was no path to php.
Wasn't an issue early days of course, when it was all php 5 right :-)
I do love the Topic creator and will anxiously await its update for php8 as its a real great feature.
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
![[Linked Image]](https://ubbdev.com/forums/ubbthreads.php/ubb/download/Number/4515/filename/20201008_17-38-03.PNG)
