New Posting Features - Automatic Thread Tagger

Automatic Thread Tagger


Description
When a user submits a new thread this modification will automatically take keywords from the thread title and use these as tags. You can use Automatic Thread Tagger to propose the user AJAX tags for his new thread, or it assigns new tags after saving the new thread. It can add the translated thread prefix to the tags.
Additionally, you can tag existing threads via maintenance and also scheduled tasks.

This modification is a successor to the terminated Automatic Thread Tagger by MrEyes:
https://vborg.vbsupport.ru/showthread.php?t=179927

As an example, if a user submits a thread with a title of:
"Fish Food for Cats!"

The thread will be automatically tagged with:

- Fish
- Food
- Cats

If the user also submits an actual tag of "Fish" this will not be duplicated. Any rules you have setup for tagging will be respected.
If you choose to do so this product will also automatically tag threads created by incoming RSS feeds.

Demo
I cannot show you the process of creation, but here is a list of tags generated by Auto Thread Tagger:
http://www.insideearth.net/tags.php?langid=5
http://www.insidesupcom.de/tags.php?langid=1


Automatic Tagging of existing threads
You can tag existing threads via maintenance or scheduled task/cron. They will be created with a special flag so they can be easily identified and deleted. Manual assigned tags are not touched. Maintenance is also working if Automatic Tagging is disabled via settings. Great if you want to test some settings. Automatic Tagging will take the date of the thread creation and also the userid of the creator. This process can be automated by running a scheduled job once a night.

Please keep in mind that tags that were proposed via AJAX are not tagged as auto tagged and therefore cannot be identified as such (and therefore not deleted automatically). If you want to retain the auto tagged flag you should disable AJAX and enable the tagging after the thread has been saved. As an alternative way you can also disable this and let new threads be tagged in the night from the scheduled job.


Installation / Upgrade
1. Upload all files from "upload" to your server, take care of the directory structure
2. Import "product-auto_thread_tagger110.xml" as a product, overwrite if it's already installed
3. Check settings
4. Run maintenance / Auto Tag Threads to tag existing threads (needed if you want to use the cron)

After install, and by default the modification is disabled, this will allow you to play around with configuration before switching it on.


Troubleshooting
If you report a bug please post the thread title that created it, without this I cannot test it and improve the language parsers.

* If no threads are tagged you will have to check the following:
- Is the modification enabled? Is the action you are testing enabled? (vBulletin tagging, whole auto thread tagger system, AJAX, new threads)
- Are the words you are using badwords or filtered out?

* Cron/Scheduled Task is not tagging all threads.
- The cron is limited to 500 (you can change this via settings) threads per run to avoid heavy impact on server. Make sure you run maintenance auto tagger before this to tag old threads. You can check the scheduled tasks log to see if it is running correctly.
Important: If a thread title does not meet minimum requirements to be included in tags (f.e. one word thread titles, too short words), it will be forever in this queue.

* I'm using polish, arabic, turkish, etc.. language and the tagger is not working like it should.
- If not already replaced, replace the filter replacement '&'=>'and' with ' & '=>'and' (a space before and after &)



Todo
What comes next? You decide. Tell me what you are missing and I'll look if it can be integrated.


Why thread title and not thread text?
Parsing the thread text for tags is an extremely unlikely addition as this would require some fairly heavy processing to ensure quality of tags.


What are Stopwords?
Stopwords is the name given to words which are filtered out prior to processing of tags.
The user Hostboard on vBulletin.org posted some resources regardings this:
https://vborg.vbsupport.ru/showpost....&postcount=380



History
1.2.0, 9th August 2008
- Fixed error with missing threadid's
- Fixed error with AJAX and prefix
- Fixed error with not indexing tags via cron
- Added polish, spain, english stopwords
- Compatibel with vBulletin 3.8

[Spinball]

First I got a database error saying that the MySQL server had gone away.
Then when I refreshed:

Warning: Invalid argument supplied for foreach() in [path]/includes/functions_cron.php on line 95

and

Database error in vBulletin 3.7.2:

Invalid SQL:

UPDATE cron
SET nextrun = 1217714340
WHERE cronid = 62 AND nextrun =;

MySQL Error : 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 '' at line 3
Error Number : 1064
Request Date : Thursday, July 31st 2008 @ 11:57:46 PM
Error Date : Thursday, July 31st 2008 @ 11:57:46 PM
Script : http://nocache.avforums.com/forums/a...=productimport
Referrer : http://nocache.avforums.com/forums/a...?do=productadd
IP Address : 82.37.224.84
Username : Stuart Wright
Classname : vB_Database_Slave
MySQL Version : 5.0.51a-community-log

[Edit : follow up to this - I installed again and everything appeared to work second time through]

[Skavenger]

Originally Posted by Skavenger

Everything works fine for me except one thing.
I ran "Delete Auto Tags" maintenance option, then "Auto Tag Threads" maintenance option and when I went to check tags, I found I have duplicated tags in a single thread.
Is there a way to fix this?

Thanks

I can confirm this is not happening anymore in 1.1.0 gold

You forgot to remove this text from settings:

In order for RSS tagging to work you will have to manually edit one of the default vbulletin files. Please refer to the product page on vBulletin.org for further information.

Thanks for the mod!

[masterross]

Originally Posted by Phalynx

Please keep in mind to replace the filter replacement '&'=>'and' with ' & '=>'and'


Which browser are you using?

Both FF and IE

[Phalynx]

Originally Posted by Spinball

First I got a database error saying that the MySQL server had gone away.
Then when I refreshed:

Reduce the amount of tags per page, there is a setting for that.

Originally Posted by Skavenger

I can confirm this is not happening anymore in 1.1.0 gold

Glad to hear that.

Originally Posted by Skavenger

You forgot to remove this text from settings:

Oh yes, thanks for pointing me to this.

Originally Posted by masterross

Both FF and IE

Hmmm, cannot confirm this. Running smooth on FF2, FF3, IE6 and IE7.

[Phalynx]

Automatic Thread Tagger has been nominated for Mod of the Month.
You can vote here: https://vborg.vbsupport.ru/showthread.php?t=186918

Thanks for all people who nominated this modification!

[slowphantom]

my forum is gone dude since i install it
i cant go to admincp or log in forum

it give
Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT rssfeedid
FROM rsslog
WHERE itemid= AND itemtype='thread';

MySQL Error : 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 'AND itemtype='thread'' at line 3
Error Number : 1064

any idea to fix

[PGAmerica]

I have this installed and it seems to work fine. However, when you click on one of the tags that are generated, I get an error message that says "No input file specified".

Ideas?

[Charlie98902]

Originally Posted by slowphantom

my forum is gone dude since i install it
i cant go to admincp or log in forum

it give
Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT rssfeedid
FROM rsslog
WHERE itemid= AND itemtype='thread';

MySQL Error : 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 'AND itemtype='thread'' at line 3
Error Number : 1064

any idea to fix

Did you remove the old template edit for the RSS Feeds that was added?

[slowphantom]

Originally Posted by Charlie98902

Did you remove the old template edit for the RSS Feeds that was added?

no i didnt
shoud i do ?

[Skavenger]

Yes, and it was a file, not a template edit.