I made a mistake when entering RSS feeds that didn't have any existing data on them ie: future RSS outlets that haven't been used. The program stopped visiting any additional RSS URLs entered in the list the second it found a URL with absolutely no data on it.
So when setting up RSS feed URLs make sure they have existing data on them. When it hits a null it just stopped polling past that url. Other then that this is an oustanding mod..
Totally unfamiliar with PhpAdmin I copy n pasted this:
Code
CREATE TABLE %%TABLE_PREFIX%%TOPIC_FEEDS ( FEED_ID int(4) unsigned not null auto_increment primary key, USER_ID int(9) unsigned not null, FORUM_ID int(9) unsigned not null, FEED_URL varchar(255), LAST_BUILD int(11) unsigned not null default '0', LAST_TOPIC_TIME int(11) unsigned not null default '0', CACHE_TIME int(9) unsigned not null default '30', TITLE_PREFIX varchar(32), BODY_FORMAT text, FEED_IS_ENABLED tinyint(1) default '1', FEED_WAS_ESCAPED tinyint(1) default '0', PARSE_BBCODE tinyint(1) default '0', TOPIC_ICON varchar(30), REGEXP_SPECIAL text ) TYPE=MyISAM
Into my Query window...resulting in this:
Code
Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 14 STR: %% SQL: CREATE TABLE %%TABLE_PREFIX%%TOPIC_FEEDS ( FEED_ID int(4) unsigned not null auto_increment primary key, USER_ID int(9) unsigned not null, FORUM_ID int(9) unsigned not null, FEED_URL varchar(255), LAST_BUILD int(11) unsigned not null default '0', LAST_TOPIC_TIME int(11) unsigned not null default '0', CACHE_TIME int(9) unsigned not null default '30', TITLE_PREFIX varchar(32), BODY_FORMAT text, FEED_IS_ENABLED tinyint(1) default '1', FEED_WAS_ESCAPED tinyint(1) default '0', X PARSE_BBCODE tinyint(1) default '0', TOPIC_ICON varchar(30), REGEXP_SPECIAL text ) TYPE=MyISAM
SQL query:
CREATE TABLE %%TABLE_PREFIX%%TOPIC_FEEDS ( FEED_ID int(4) unsigned not null auto_increment primary key, USER_ID int(9) unsigned not null, FORUM_ID int(9) unsigned not null, FEED_URL varchar(255), LAST_BUILD int(11) unsigned not null default '0', LAST_TOPIC_TIME int(11) unsigned not null default '0', CACHE_TIME int(9) unsigned not null default '30', TITLE_PREFIX varchar(32), BODY_FORMAT text, FEED_IS_ENABLED tinyint(1) default '1', FEED_WAS_ESCAPED tinyint(1) default '0', PARSE_BBCODE tinyint(1) default '0', TOPIC_ICON varchar(30), REGEXP_SPECIAL text ) TYPE=MyISAM
MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%%TABLE_PREFIX%%TOPIC_FEEDS ( FEED_ID int(4) unsigned not null
I look at this and it is 100% Greek to me. It is exactly what I am looking for, but have no clue as to what to do. I downloaded the zip file, and man I feel dumber than an ox.
Then open the txt file and follow the instructions in there. You'll run the one query, replacing %%TABLE_PREFIX%% with the table prefix used at your forums.
You'll then use your trusty text editor (notepad if you have nothing better) to edit a couple of files specified, and then you upload the modified files.
Go to your control panel, click "Topic Feeds" in the left bar, and set the feeds up
I have the tables created and files uploaded / modified. I can use the admin panel to add feeds to forums, but nothing is actually taking place / nothing is bieng added to the forum.
I type in the url of script which triggers things. It executes just fine, but does not add any informaiton to the DB about the new topics it finds.
Is it possible that the changes made between 7.1 and 7.2 (some tables changed) and this mod simply do not work well togeather?
After install, i had a problem where only some feeds would work. It looks like if the feed does not provide a date for each topic, the mod will not work. If that sounds right, why not change it so that it defaults to todays date?
One thing that sucks is that sites with popular editors will take and rename the feed topic several times sometimes... Which will be grabbed each time, which is entertaining to say the least (reuters tech is what I'm viewing)
Just noticed on this one I set up - I have two new articles - each have been repeated 10 times LOL - this is hidden at the moment from users, so it is not an issue - but it also means I can not use this script in real time yet.
With some help from SD I have this up and running again...
Change:
Code
// Setup the smarty class require_once('../libs/smarty/Smarty.class.php'); $smarty = new Smarty(); $smarty->template_dir = 'templates/default'; $smarty->compile_dir = 'templates/compile'; // include all of the required libraries require_once( "../libs/phpmailer/class.phpmailer.php" ); require_once( "../includes/config.inc.php" ); require_once( "../libs/mysql.inc.php" ); require_once( "../libs/ubbthreads.inc.php" );
/** * Should each new item increase the user's post count? */ $config['TOPIC_FEED_INC_POSTCOUNT'] = true;
$html =& new html;
To:
Code
// Setup the smarty class require('../libs/smarty/Smarty.class.php'); $smarty = new Smarty();
// include all of the required libraries require_once("../libs/phpmailer/class.phpmailer.php"); require_once("../includes/config.inc.php"); require_once("../libs/mysql.inc.php"); require_once("../libs/bbcode.inc.php"); require_once("../styles/wrappers.php"); require_once("../libs/html.inc.php"); require_once("../libs/mailer.inc.php"); require_once("../libs/user.inc.php"); require_once("../libs/ubbthreads.inc.php");
/** * Should each new item increase the user's post count? */ $config['TOPIC_FEED_INC_POSTCOUNT'] = true;
Actually, I think I know the cause of that... Once I took it out of the footer (to where it's loaded every page load) and put it in the forum stats island so it's cached it only pulls one copy...
I think it's the occasional X amout of people hitting it at the same time when it's supposed to refresh that gets doubles...
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.