[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!!

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:

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.