vb.org Archive - Article Bot

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - Article Bot (https://vborg.vbsupport.ru/showthread.php?t=67078)

Hi,

I'm having a problem that has only occured recently.

See:
http://www.bigbrotherwebsite.net/for...splay.php?f=34

The bot is starting to post up news stories from the RSS feed that are days or sometimes weeks old as new... why is this? It is not coming up in the actual RSS feed as recent news stories, only in the forum...

Can anyone help?

- Joe

Quote:

Originally Posted by mrpotatohead

Check the RSS feed/origin site - I have found that some feeds/sites will recycle older stories if there has not been much traffic.

Nope it's not that, because it's my own website that I am including the feed from in to the forum... it's very strange!?

- Joe

Quote:

Originally Posted by mrpotatohead

Have you noted that the old posts are duplicates, e.g. that they are identical in every way to prior posts? Same post title, content, etc?

Have you noted that the old articles have exceptionally long titles?

Mine was doing that and I edited the code to fix it. If you're having the same problem let me know and I'll post (re-post? can't remember . ..) the fix.

Kenny

Quote:

Originally Posted by kyouens

Yup, yes to both those Kenny... they do have long titles and yes the duplicates are exactly the same... if you could would you be able to post the fix, I'd be extremely grateful!! :)

- Joe

Quote:

Yup, yes to both those Kenny... they do have long titles and yes the duplicates are exactly the same... if you could would you be able to post the fix, I'd be extremely grateful!!

Hey Joe, below I've attatched my description of and workaround for this problem. The shorthand answer, which does involve mucking with the database (so make a backup):

Go into PHPmyadmin (or whatever mySQL client you've got and change the column type of the "title" row of the articlebot_rss_cache table from Varchar(255) to "text". That eliminates a 255 character limit for titles in the feed cache and stops the doubleposting. Note that the thread title ON THE POST will still be limited to 254 characters, but this shouldn't be a problem at all for most people.

I did this about a month ago and I've had no problems at all since that time with doubleposting.

Here's the original stuff below:

Quote:

Originally Posted by kyouens

Check this out: In my forum, the longest threads have names like this:

Immunohistochemical Stains for p63 and alpha-Methylacyl-CoA Racemase, Versus a Cocktail Comprising Both, in the Diagnosis of Prostatic Carcinoma: A Comparison of the Immunohistochemical Staining of 430 Foci in Radical Prostatectomy and Needle Biopsy

However, the feed itself gives the title as this (ignore the html characters):

Immunohistochemical%20Stains%20for%20p63%20and%20
alpha-Methylacyl-CoA%20Racemase%2C%20Versus%20a%20
Cocktail%20Comprising%20Both%2C%20in%20the%20Diagn osis%20
of%20Prostatic%20Carcinoma%3A%20A%20Comparison%20o f%20
the%20Immunohistochemical%20Staining%20of%20430%20 Foci
%20in%20Radical%20Prostatectomy%20and%20Needle%20
Biopsy%20Tissues.

These are not identical. If you look, the last part of the feed's title has a few extra words. For some reason, the title is getting truncated as it is being written into the forum, which is why the script, which I believe uses the title and postdate to determine identical-ness, fails to see these as identical.

Now to find the responsible code and drop a major load of hurt on this stupid bug.

Update: The problem is that the title row in the post table (of vbulletin) is of type varchar(250), and some of the full titles are >250 characters. To include the full titles, I may need to change the column type to TEXT. I wonder if this will wreck my vbulletin due to unforeseen badness...I will ask around before I try it and will update the thread.

Update: Fixed the doubleposting of articles with long titles issue. Go into PHPmyadmin and change the column type of the "title" row of the articlebot_rss_cache table from Varchar(255) to "text". That eliminates the 255 character limit for titles in the feed cache and stops the doubleposting. Note that the thread title ON THE POST will still be limited to 254 characters, but this shouldn't be a problem at all for most people.

Thanks kyouens!! Fingers crossed it works... thanks for your help, much appreciated!

- Joe

my cron gets these errors any ideas tried changing the files permissions

Quote:

/home/benj/www/articlebot/articlebot.php: line 1: ?php: No such file or
directory
/home/benj/www/articlebot/articlebot.php: line 5: /aquota.user: Permission
denied
/home/benj/www/articlebot/articlebot.php: line 6: syntax error near unexpected
token `|'
/home/benj/www/articlebot/articlebot.php: line 6: ` | articlebot.php, v1.1,
07/25/04

I am getting the cron error, even though I have set the script to report to /dev/null

Code:

/usr/bin/php /var/www/html/football-forums/forums/articlebot/articlebot.php >> /dev/null

my error email I get is:

Code:

junk after document element at line 161, column 16

I followed earlier instruction, to change the table type of 'title' in 'articlebot_rss_cache' from 'varchar' to 'text' which eleminated 1 line of the error. What am I missing to fix this?

Thanks
-Zach

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02051 seconds Memory Usage 1,752KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: