vb.org Archive - Administrative and Maintenance Tools - Convert Zoints Thread Tags to vB 3.7 tagging system

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

- vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)

- - Administrative and Maintenance Tools - Convert Zoints Thread Tags to vB 3.7 tagging system (https://vborg.vbsupport.ru/showthread.php?t=170314)

i have some error like

"
Converting...

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /converttags.php on line 14

Updating threads...

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /converttags.php on line 44
"
what should i do?

Quote:

Originally Posted by MissKalunji (Post 1470465)

Thanks for this i tested it in a test format it works perfectly. But i'de like to change the userid from 1 to 6 (since 6 is me and i'm the one who added all those tags)

Thanks :)

Code:

    $db->query_write("INSERT INTO `" . TABLE_PREFIX . "tagthread` (`tagid`, `threadid`, `userid`, `dateline` ) VALUES ('$tagid','$threadid','1','$dateline')");

I suppose i just change the "1" in there for 6 right?

Yeah. Also don't forget to change it twice. The query is mentioned in the script twice.

Quote:

Originally Posted by yakusasc (Post 1470490)

Hi,

What about urls like forums/tags/mytag/ ? Does your script redirect them to the VB tag system ?

Tks and good job !

Nope, all it does is convert the database entries to the new system.

Quote:

Originally Posted by Basit (Post 1471216)

Tried but didn't worked for some reasons, get error just before the end (total tags are 25,000), but get error around 23,000 :>

I assume you got the same error like the ones posted before?
I'll try to fix it, but I haven't had time to look at it yet and don't know when I will.

Quote:

Originally Posted by skiseiju (Post 1489156)

Are you sure everything is right with your zoints tags table?

worked perfectly :) thanks again!

Quote:

Originally Posted by zappsan (Post 1489468)

Are you sure everything is right with your zoints tags table?

Sorry, i don't understand what's that mean.
My zoints tags is work fine , everything should be ok.
May something wrong i couldn't see?

Outstanding! worked like a charm, I have been waiting for it for sooo long, You just made my day.

After removing zoints profile now this I am completly deZoinded now free and happy :D

MOTM for sure!

got this error towards the end of running the script (at Tag 5139 of 5153)

Code:

Database error in vBulletin 3.7.0 Release Candidate 1:



Invalid SQL:

INSERT INTO `tagthread` (`tagid`, `threadid`, `userid`, `dateline` ) VALUES ('1','20590','1','1208387534');



MySQL Error   : Duplicate entry '1-20590' for key 1

Error Number  : 1062

Date          : Wednesday, April 16th 2008 @ 07:12:14 PM

Script        : http://ww ************* .com/forums/converttags.php

Referrer      : 

IP Address    : **************

Username      : GrendelKhan{TSU}

Classname     : vB_Database

MySQL Version : 4.1.22-standard-log

i run the converter but i have the same issue than others Duplicate entry '1-20590' for key 1...
the converter add the tags but the tags dont appear in the threads, so what i have to do?

EDIT: when i edit the tags in some thread the tags appear and i need to add some new tag to see the others...
i dont understand LOL :P

Nothing happens here?
I just see :

Quote:

Converting...

Updating threads...

Done!

It went smooth but my tags are still sent to zoints :) even while Ive uninstalled zoints plugin..
default vbulletin tags are now sent to zoints! :D :D

Quote:

Originally Posted by skiseiju (Post 1489703)

Sorry, i don't understand what's that mean.
My zoints tags is work fine , everything should be ok.
May something wrong i couldn't see?

It's hard to say what it is, I added some code which will display a better error message, you can try it again.

Quote:

Originally Posted by GrendelKhan{TSU (Post 1492527)

got this error towards the end of running the script (at Tag 5139 of 5153)

Code:

Database error in vBulletin 3.7.0 Release Candidate 1:



Invalid SQL:

INSERT INTO `tagthread` (`tagid`, `threadid`, `userid`, `dateline` ) VALUES ('1','20590','1','1208387534');



MySQL Error   : Duplicate entry '1-20590' for key 1

Error Number  : 1062

Date          : Wednesday, April 16th 2008 @ 07:12:14 PM

Script        : http://ww ************* .com/forums/converttags.php

Referrer      : 

IP Address    : **************

Username      : GrendelKhan{TSU}

Classname     : vB_Database

MySQL Version : 4.1.22-standard-log

I have looked at this error (since you haven't been the only one) and couldn't really find out why this is happening. The error would happen whenever the same tag is added to the same thread twice, but Zoints actually doesn't let you do that. Anyway, I've added something which should most likely prevent this, but I can't be certain it does, since I've never had that problem with my own forums' tags. Try running the newer version file which I'm going to add right now.

Quote:

Originally Posted by elmati (Post 1492607)

You don't have to do anything. The tags usually get added to the threads and will show up automatically after the script has been run, but since you got the error message before it finished, they aren't going to show up on most threads.

Quote:

Originally Posted by 993ti (Post 1493010)

Nothing happens here?
I just see :

Seems like it doesn't find any tags to convert. Are you sure your Zoints tags table isn't empty?

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 (3)bbcode_code_printable (10)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (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.01268 seconds Memory Usage 1,750KB 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 (10)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (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: