vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   New Posting Features - Automatic Thread Tagger From Post Content and Title (https://vborg.vbsupport.ru/showthread.php?t=218350)

NLP-er 09-22-2009 12:57 AM

Quote:

Originally Posted by turbosatan (Post 1888637)
how do i delete the tags?

this seems to have just created hundreds and hundreds of totally nonsense tags .

the options menu item doesn't show anything in the backend either

How do i remove all the tags it has created?

This mod creates only tags which you approve - manually or setting quarantine time. So you have only what you approved :)

Please read configuration options descriptions carefully and set mod to work as you want it to work. You can easily configure it to not create any new tags and only associate already existing with new posts. Also read mod description where you have noted which vB native options are respected by this mod :)

You can delete tags by Admin CP, or by SQL. In 2nd case you can use query like this (I didn't check it so do corrections yourself if there is some typo or syntax issue):
Code:

DELETE tag FROM tag INNER JOIN tag_proposition WHERE tag_proposition.status=4 and tag_proposition.tagtext=tag.tagtext
This will remove only tags which was made automatically after quarantine (status = 4). If you want to remove also propositions (will be proposed again if occurs in new posts), then execute this query:
Code:

DELETE tag, tag_proposition FROM tag INNER JOIN tag_proposition WHERE tag_proposition.status=4 and tag_proposition.tagtext=tag.tagtext
Note that it is wise to clear all tags associations after that and generate it again (see mod options). And it it even wiser to close forum for minute, clear all associations, delete automatically created tags, generate association again and turn forum on :)

turbosatan 09-22-2009 07:28 AM

Quote:

Originally Posted by NLP-er (Post 1888743)
This mod creates only tags which you approve - manually or setting quarantine time. So you have only what you approved :)

i just clicked on the tag all previous threads one to tag all the previous threads but clearly there is a lot more sertup to do first.

Update

I have run both sql queries and it says rows affected = 0 on both of them

You mention that tags can be removed in admin cp. Where?

The options menu in the thread tagger doesnt seemn to work at all it is just blank on my install

NLP-er 09-22-2009 07:20 PM

Quote:

Originally Posted by turbosatan (Post 1888823)
i just clicked on the tag all previous threads one to tag all the previous threads but clearly there is a lot more sertup to do first.

Update

I have run both sql queries and it says rows affected = 0 on both of them

You mention that tags can be removed in admin cp. Where?

The options menu in the thread tagger doesnt seemn to work at all it is just blank on my install

You wrote that my mod creates you lot of new tags - and now you are writing that no tag was created by this mod. I think that you mislead tag with tag association. You can clear all associations easily by mod in Admin CP. Note that it will not remove any tag, but no tag will be associated to any thread anymore. You can then set max tags limit for thread and after that generate associations by mod :)

turbosatan 09-22-2009 09:16 PM

Quote:

Originally Posted by NLP-er (Post 1889076)
You wrote that my mod creates you lot of new tags - and now you are writing that no tag was created by this mod. I think that you mislead tag with tag association. You can clear all associations easily by mod in Admin CP. Note that it will not remove any tag, but no tag will be associated to any thread anymore. You can then set max tags limit for thread and after that generate associations by mod :)

no what i said was it has created a lot of tags and that the sql queries you gave me to remove the tags affected 0 rows

that is different to not creating any tags.

i have turned tags off in my forum for now as there are currently 201 Pages in teh tags list which mostly consist of thigns like 001 and 888 and 1yr etc etc

i want to remove the tags which this mod has created. how do i do that???

Edit just to be clear i do not mean tag associations or any other feature in the mod i just mean how to get rid of tags because there is no delet all button or way of cliking all the tickboxes at once and im not about to sit there through 2 jhundred pages clicking one at a time

http://www.thetattooforum.com/untitled.bmp

NLP-er 09-23-2009 10:40 AM

Quote:

Originally Posted by turbosatan (Post 1889125)
no what i said was it has created a lot of tags and that the sql queries you gave me to remove the tags affected 0 rows

that is different to not creating any tags.

You are right :) Sorry for confusion - at the end I mislead what you was writing about ;)

Ok - I'm investigating this. I will send another message in a minutes :)

NLP-er 09-23-2009 10:46 AM

I just looked in the code and now I'm sure that I didn't miss to set status code for tag_propositions. So now I need 2 information from you:

1. Please give me result of this query:
Code:

SELECT count(*) FROM tag_proposition WHERE status=4
2. Please tell me are you using some other tagging mod?

EDIT:
Also I made tests on my test board and everything is ok - also SQL which I gave you works fine.
I'm still waiting for your answers, but at this particular moment I can tell that those tags which you have created are not created by my mod :)

turbosatan 09-23-2009 01:50 PM

Execute SQL Query

Query
SELECT count(*) FROM tag_proposition WHERE status=4

Results: 1 (0.0003s), Page 1 of 1
count(*)
0

i did use an automatic thread tagger about 1 year ago when first one was released but i could not get it to work properly so i scrapped it and did nto use it.

it may have been that that other mod created the tags and then your mod applied them to all of the threads. i guess that is possible.

the issue i have is that i want to get rid of all the tags and start again from scratch now

Your mod did process a lot of threads when i first click on the add tags to all threads option in admin cp

EDIT:- i foudn the answer here http://www.vbulletin.com/forum/showthread.php?t=317440

to delete all tags

TRUNCATE TABLE tag
TRUNCATE TABLE tagthread

NLP-er 09-23-2009 02:22 PM

Quote:

Originally Posted by turbosatan (Post 1889389)
Execute SQL Query

Query
SELECT count(*) FROM tag_proposition WHERE status=4

Results: 1 (0.0003s), Page 1 of 1
count(*)
0

i did use an automatic thread tagger about 1 year ago when first one was released but i could not get it to work properly so i scrapped it and did nto use it.

it may have been that that other mod created the tags and then your mod applied them to all of the threads. i guess that is possible.

the issue i have is that i want to get rid of all the tags and start again from scratch now

Your mod did process a lot of threads when i first click on the add tags to all threads option in admin cp

EDIT:- i foudn the answer here http://www.vbulletin.com/forum/showthread.php?t=317440

to delete all tags

TRUNCATE TABLE tag
TRUNCATE TABLE tagthread

Man - this mod have no 1 year yet. You wrote that this mod made you lot of tags - it is not this mod. You are writing on wrong thread.

Also - those 2 queries will remove all tags and tags associations you have - also those tags which you made manually.

Please go to author of mod which made this mess in your tags and ask him does he marks tags added automatically - this way you will be able to remove only garbage tags by appropriate condition in WHERE clause.

Also - 2nd query is not needed - my mod gives you possibility to clear all tags associations and it makes it nicely, because it made cleaning after that using vb function (note that tags association are cached in thread table).

turbosatan 09-23-2009 03:17 PM

i really wish you understood me a little better.

Can we get vborg to install the enterprise translator maybe??

so about 1 year ago i installed a plugin to try and auto tag my threads. it caused errors with other plugins so i turned it off.

That plugin must have made the tags which we saw in my screenshot earlier.

Your Plugin which i installed days ago applied hundreds of nonsense tags to all of my threads. i do not know if the tags which it applied to the threads were from your mod or the previous one but the actual tags themselves were added to the threads by your mod.

thats it end of story.

i have used the truncate sql above to remove all the tags from the tags fields and then tried again from scratch to use your mod.

this time it seems to have done some pretty good tags. although it does still have a load which are not really applicable so it looks like i will need to just add the tags i want manually after all.

NEW PROBLEM
none of the tag clouds work as this mod puts all the tags into a different database table.

Any way to fix that?

NLP-er 09-23-2009 06:37 PM

Quote:

Originally Posted by turbosatan (Post 1889464)
i really wish you understood me a little better.

Can we get vborg to install the enterprise translator maybe??

so about 1 year ago i installed a plugin to try and auto tag my threads. it caused errors with other plugins so i turned it off.

That plugin must have made the tags which we saw in my screenshot earlier.

Your Plugin which i installed days ago applied hundreds of nonsense tags to all of my threads. i do not know if the tags which it applied to the threads were from your mod or the previous one but the actual tags themselves were added to the threads by your mod.

thats it end of story.

i have used the truncate sql above to remove all the tags from the tags fields and then tried again from scratch to use your mod.

this time it seems to have done some pretty good tags. although it does still have a load which are not really applicable so it looks like i will need to just add the tags i want manually after all.

NEW PROBLEM
none of the tag clouds work as this mod puts all the tags into a different database table.

Any way to fix that?

Mod is working fine :) Just like it is designed - applies existing tags to threads which have this tag word in content or title. You wrote that mod is assigning nonsense tags to threads. You want to tell me that you have nonsense content in your threads?...

My mod applies only tags which you already have created. Garbage in - garbage out. You had garbage tags, so garbage tags was assigned to threads. And was assigned in appropriate places - it means in threads which are using tag words. It is clearly described in mod description that mod is adding existing tags to threads according to its content and title. So why did you expect it will not do this?...

About new problem - what table are you writing about? Mod handles tags in default vB tables (tag and tagthread) - maybe you have some problems with prefixes, but it shouldn't happen, cause variable for prefixes is used in SQL queries.

Also please read mod description cause I have a thought that perhaps you still don't understood how this mod is working.


All times are GMT. The time now is 04:22 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01303 seconds
  • Memory Usage 1,786KB
  • 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
  • (3)bbcode_code_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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