Convert Zoints Thread Tags to vB 3.7 tagging system

[zappsan]

Description

This will convert all tags from the Zoints thread tags hack to vB 3.7's tagging system.

Use

Simply upload the converttags.php to your forums root folder and run it in your browser. Once the script is done, delete it. Don't refresh the page after running it (this would give you an MySQL error).

Note:
vB 3.7's tagging system has a few additional settings which Zoints thread tags doesn't have, so it couldn't be converted.

UserID: vB 3.7 saves the ID of the user who added the tag in the database. In my converter, the ID will always be '1'. If you want to use a different one, let me know.
(I think the only time this is used is when you edit the tags of the thread: The tags added by you will be displayed in bold.)

Date: Whenever a tag is added, vB will save the date in the database. In my converter, it will always be the date you ran my script.

Once again, I'm putting this under beta stage for a while, until more people have tested it and got it to work.

I myself have been testing this many times and hope everything is working fine :)
Use at your own risk, I suggest running this on a test forum before.

Updates
22/6/2008: Security issues fixed. Everyone who got database errors should give this another try, the update will fiy this issue.
19/4/2008: version 1.0.1: Made some changes which will hopefully fix some problems the users have had.

[dirtycrow]

looked soo promising until it gave a Mysql error will processing 370 of 5550 tags.

[zappsan]

Which error did you get?

[Zaiaku]

You know original I was going to do without importing them over since it asn't really that big of a deal but then since you just helped me out here 1 less thing to do without. Thx!

[birdie]

THANK YOU. My use of Zoints tags in 3.6 is the reason I was not going to update to 3.7! I will get back to considering it now!

[FleaBag]

Zoints Tags works just fine with vB 3.7, as I use it myself! :)

But this is great, I wanted to move over to the vB system but this is what was holding me back. I'll give this a whirl later tonight.

Thanks.

[dirtycrow]

Which error did you get?
this one

Database error in vBulletin 3.7.0 Beta 4:

Invalid SQL:
INSERT INTO `tagthread` (`tagid`, `threadid`, `userid`, `dateline` ) VALUES ('142','47370','1','1202835441');

MySQL Error : Duplicate entry '142-47370' for key 1
Error Number : 1062
Date : Tuesday, February 12th 2008 @ 11:57:21 AM
Script : http://forums.xxx.com/converttags.php
Referrer :
IP Address : xxx
Username : xxx
Classname : vb_database
MySQL Version : 4.1.22-standard~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

[hckby]

Database error in vBulletin 3.7.0 Beta 4:

at the end of the converting.

[FleaBag]

I will hold off for now with an install, but hope to install soon! :)

[kafi]

GREAT GREAT, please fix the issue!!!

Milion Thanks!!!

[zappsan]

Database error in vBulletin 3.7.0 Beta 4:

at the end of the converting.
Which error did you get? The same dirtycrow got?
GREAT GREAT, please fix the issue!!!

Milion Thanks!!!
I will try to fix it.
I must have missed something.
It seemed to work fine for my forums though (around 900 tags).

[pipedreams]

thanks you for this!

It worked perfectlfy for me, though I did have to use
set_time_limit(0);
to make sure the script ran fully :D

[maxicep]

it works fine, thanks

just some words are bad like quotvbulletin :)

[ZiG]

crashed for me at tag 758


Database error in vBulletin 3.7.0 Beta 5:

Invalid SQL:
INSERT INTO `tagthread` (`tagid`, `threadid`, `userid`, `dateline` ) VALUES ('1','1082','1','1203492601');

MySQL Error : Duplicate entry '1-1082' for key 1
Error Number : 1062
Date : Wednesday, February 20th 2008 @ 01:30:01 PM
Script : http://www.xxx.com/xxx/xxx/converttags.php
Referrer :
IP Address : xxx
Username : xxx
Classname : vb_database
MySQL Version : 4.1.22-standard

[Zaiaku]

Tried it out during my update to a heavily modded beta6, worked flawlessly!

[FleaBag]

I'm looking forward to using this, too - I just need to wait for the final version of vB (which will give me the new version of vBSEO). :)

[MissKalunji]

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 :)


$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?

[yakusasc]

Hi,

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

Tks and good job !

[Basit]

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 :>

[Keyser Soze]

What about urls like forums/tags/mytag/ ? Does your script redirect them to the VB tag system ? I am also interested in how to solve this issue. My forum is ranking very good in Google with some of the forum.mydomain.com/tags/tagname pages. I definitely need to find a solution how I can rewrite all links to tags.php on showthread.php etc.

[skiseiju]

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?

[zappsan]

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 :)


$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.
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.
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.
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?
Are you sure everything is right with your zoints tags table?

[MissKalunji]

worked perfectly :) thanks again!

[skiseiju]

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?

[sensimilla]

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!

[GrendelKhan{TSU]

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



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

[elmati]

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

[993ti]

Nothing happens here?
I just see :
Converting...



Updating threads...



Done!

[sensimilla]

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

[zappsan]

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.
got this error towards the end of running the script (at Tag 5139 of 5153)



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.
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
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.
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?

[FleaBag]

Thanks for the update, I will be able to give this a run through soon (when vB is released, and thus the new vBSEO).

[993ti]

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

Not empty: 15,712 records
Strange though, no errors

Edit: Tried it on another site of mine and it works.
Strange, why doesn't it work on my main site :?

Edit 2:
Found what's causing it.
In config.php i had database type set to Mysqli, i changed that to Mysql and it works ;)

[elmati]

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.


ok, tags disapear in every thread, but if a click "edit tags" there are tags in thread and i need to add new tag to see olders, i think i have to update the database...

i dont find in update counters an update tags link...
see my attachments, same thread when i click in edit tags they are some tags there! :)

[zappsan]

Not empty: 15,712 records
Strange though, no errors

Edit: Tried it on another site of mine and it works.
Strange, why doesn't it work on my main site :?

Edit 2:
Found what's causing it.
In config.php i had database type set to Mysqli, i changed that to Mysql and it works ;)
Good to know you managed to fix it :)
ok, tags disapear in every thread, but if a click "edit tags" there are tags in thread and i need to add new tag to see olders, i think i have to update the database...

i dont find in update counters an update tags link...
see my attachments, same thread when i click in edit tags they are some tags there! :)
Like already said, my script will update the threads so you'll see older tags when you view a thread. It isn't showing up for you, because you got an error message while running the script so it didn't get to the part where the threads get updated. Try running the new version. If you don't get any errors, the threads should all be updated.

[elmati]

Ok, tonite ill run the new version :)

Thanks zappsan!

[elmati]

Hey Zappsan i run the converter again and everything works fine!

Thanks a lot for your help :)

Very usefull, ty a lot!

[bada_bing]

Will this work for the zoints thread tags for vb 3.5.x ?

[elmati]

i think u first need to upgrade to vbulletin 3.7 in order to use this converter...
new version works perfect!

[zappsan]

Will this work for the zoints thread tags for vb 3.5.x ?

i think u first need to upgrade to vbulletin 3.7 in order to use this converter...
new version works perfect!
That's correct.
You need to upgrade 3.7 first, so you've got the new tag tables in your database. You also need to keep the Zoints tag table.

Glad to see the new version is working :)

[Rik Brown]

We de-Zointed our forums several months ago. But I did like how the Zoints tagging created new tags since we use the NNTP Gateway that imports Usenet Newsgroup messages. We then ran the Zoints tagging against those imported messages.

Question: Can both the Zoints tagging and new vb 3.7 tagging systems co-exist on an ongoing basis where we first run Zoints tagging and then run vb tagging via this mod (say, weekly)? Or, is this mod normally to be run on a one-time basis and then discontinue the prior Zoints tagging?

Please advise. Thanks. -- Rik

[GrendelKhan{TSU]

yah! no errors this time. :) thx

[993ti]

For those who want to redirect the Zoints taglinks in searchengines to the vbulletin tags:
Open tags/.htaccess and replace
RewriteRule ^(.+)/$ index.php?tag=$1 [NC,QSA,L]
With
RewriteRule ^(.+)/$ http://www.DOMAINNAME.com/tags.php?tag=$1 [R=301,L]

[Keyser Soze]

For those who want to redirect the Zoints taglinks in searchengines to the vbulletin tags...I think the other way around would be better (in terms of SEO) ;)

[MissKalunji]

how would i put that for vbseo?

[993ti]

I think the other way around would be better (in terms of SEO) ;)
Yeah, but i have no idea how to rewrite the vbtags properly :o
Maybe someone with knowledge knows how to do that :)
how would i put that for vbseo?
Don't know, i don't use VBseo.

[tpearl5]

Subscribed to this for when I upgrade.

[Sal Collaziano]

Am I understanding correctly that even if you use this conversion method, you cannot uninstall Zoints Tags without having issues? I just installed 3.7 and uninstalled Zoints tags. I found that I had more traffic than I thought coming from these tags - because I was getting loads of Database Error emails. So, I reinstalled the Zoints Tags - and that remedied the problem.

This conversion tool will place all the zoints tags into the vB system - but it doesn't do any kind of rewrite or redirect - so you still need to keep the Zoints Tag system in place...

[MissKalunji]

uh? you were getting loads of database message about what?

having connect error?

or you mean that the spiders are getting 404?

[FleaBag]

Just ran it and it worked flawlessly! Thanks.

For your search engine problems, vBSEO will fix your problem.

[MissKalunji]

Just ran it and it worked flawlessly! Thanks.

For your search engine problems, vBSEO will fix your problem.

i've searched and haven't find what to put?

[FleaBag]

Make sure you are running 3.2.0 RC4. Enable the 2nd tag structure rewrite. Perform the file edits in the below thread.

http://www.vbseo.com/f9/how-rewrite-tag-url-22739/

[MissKalunji]

great thanks :)

[Sal Collaziano]

uh? you were getting loads of database message about what?

having connect error?

or you mean that the spiders are getting 404?
My zoints tags were spidered and listed in the search engines. When people clicked the links (from the search engines), they'd get a database error (which I was informed of) because the page didn't exist.

I reinstalled Zoints Tags. Once you use them, you cannot stop using them. This conversion will only convert Zoints tags to the new system. You cannot disable the Zoints tags - unless you're not receiving any traffic through them. If that's the case, than they didn't do anything for you anyway...

[MissKalunji]

it shouldn't give them no database error unless you still have the zoint files on your server?

it should give them a 404 error or if you have vbseo or i think you're able to set that in htaccess forwarding back to your main forum.

I had zoint tag installed i used this and took of zoint i had a bunch of tags indexed they went straight to the main forum page til vbseo updated and now supports the old zoint tag url format

[Neutral Singh]

Works flawlessly!! Now i can remove zoints finally. Though i love Zoints. It served my forums a great deal.

[imranbaig]

Thanks, Tried on 3.7 Gold Worked like Charm

[Fırtına]

Error: Thread 5236 of 6221


Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE `thread` SET taglist='dİsk'e, emre ak?z, ergenekon'dan, ka?arken, yakalanmak' WHERE threadid=5356;

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 'e, emre ak?z, ergenekon'dan, ka?arken, yakalanmak' WHERE threadid=5356' at line 1
Error Number : 1064
Request Date : Friday, May 16th 2008 @ 01:25:54 AM
Error Date : Friday, May 16th 2008 @ 01:26:14 AM
Script : http://www.********.net/converttags.php
Referrer :
IP Address : 77.****************
Username : Fırtına
Classname : vB_Database
MySQL Version : 4.1.22-standard

[Mecho]

wow seems that it converted alllllllllll the TAGS !!

Thanks alot man :)

[RC.]

wowww great, works very fine... thanks.

[Mecho]

EDIT : "Everything is FINE and this mod works like a charm ."

[Fırtına]

Error: Thread 5236 of 6221


Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE `thread` SET taglist='dİsk'e, emre ak?z, ergenekon'dan, ka?arken, yakalanmak' WHERE threadid=5356;

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 'e, emre ak?z, ergenekon'dan, ka?arken, yakalanmak' WHERE threadid=5356' at line 1
Error Number : 1064
Request Date : Friday, May 16th 2008 @ 01:25:54 AM
Error Date : Friday, May 16th 2008 @ 01:26:14 AM
Script : http://www.********.net/converttags.php
Referrer :
IP Address : 77.****************
Username : Fırtına
Classname : vB_Database
MySQL Version : 4.1.22-standard
This post not replyed? please help...

[zappsan]

just one weird problem !

i have prefixes in all threads and sections now expect just one section !!!!! and we have tons of threads in that section . what shall i do ??
Prefixes? Do you mean tags?
Any idea ??

This post not replyed? please help...
I will take a look at this, I didn't have time yet, sorry for the late response.

[Fırtına]

After converting all pages indexed in google for my web site redirected as + symbol.

http://www.sisligece.net/tags/ne-oldugu-uzerine/ < Please click is URL (error resolved). http://www.sisligece.net/tags/ne+oldugu+uzerine/ < or click this URL (error not resolved).



All pages indexed in Google for - . How do changing + is to this -

[maxicep]

That settings about interesting with vbseo plugin.

Go
www.vbseo.com Turkish Section :)

[Amenadiel]

for some odd reason, this plugin does nothing on my forum

Converting...



Updating threads...



Done!

And nothing's changed :(

Edit: Solved! this script only works if you configure your db connection to use mysql instead of mysqli.

[Chadi]

I ran this, uninstalled zoints and then checked a few threads. No tags are found. I did not encounter any errors during the file run. The default VB tags was also enabled prior to the run as well. I even ran Rebuild Thread Information too.

[zappsan]

I ran this, uninstalled zoints and then checked a few threads. No tags are found. I did not encounter any errors during the file run. The default VB tags was also enabled prior to the run as well. I even ran Rebuild Thread Information too.
Did you check if there are any tabs in the database?
Maybe you are having the same problem as this person -> https://vborg.vbsupport.ru/showpost.php?p=1526896&postcount=65

[web_styler]

3.7.0 Turkish karakter problems

alexa-s-ralamas-neye-gore-t problem ö,ı,ç,ü, vsvs Carecters problem

[libertylounge]

Worked perfectly for me with 3.7.1 ..thank you SO MUCH for writing this.

[delinetciler]

T?rk?e karakter sorunun ??z?m? burada (http://www.delinetciler.net/forum/zoints-tags-3-7-turkce-karekter-sorunun-cozumu-t51814/index.html)

[suvari1794]

thank you.

[briansol]

Tag 329389 of 375620

Fatal error: Maximum execution time of 30 seconds exceeded in /home/xxxxxxx/public_html/includes/class_core.php on line 408

lol

i guess that's good enough

[Auron]

lve just noticed after converting the tags over that when you use the "show tag" search page, that all threads listed with the tag you searched for.. for example sake:

http://site.com/forum/tags.php?tag=stuff

you should get all threads that were tagged with word "stuff" that works well enough, HOWEVER all "thread titles" link to my main forum page (the /forum/ directory) none of the thread titles go anywhere except there, however the page numbers "do" link to the threads they are supposed to.

what l need is a way to fix this as l didnt find any references within this thread for the problem.. the weird thing is it has affected all forums l recently upgraded by the looks of it.

[Auron]

does this update fix the above issue? and how can l rebuild tags since due to the original issues and not noticing until it was too late?

[Auron]

just to update, lve retested the conversion, didnt seem to cause issues re-running altho l did the usual backup database etc just in case and it still doesnt convert the locations of the the threads, and also the forum locations of threads doesnt update either.

page numbers are fine however if the thread contains no pages you are redirected to the forum root.

[Auron]

sorry for adding another post, lve found the issue, but no closer to a solution.

l need to find a way to exclude the tags script executing zoints seo options, the url rewriting seems to break the tags links when disabled it works again.

[zappsan]

Sorry for the late response but I can't help you there.
All my hack does is convert the data to vB's tag system, it doesn't apply any template changes.

[Auron]

sadly my guess is right T_T looks like l wont be getting a fix then thanks for taking a look tho..

and just to reiterate, its a url rewriting issue, assumed template originally but its actually an issue because its trying to rewrite the urls.

[TacticalNuke]

I disabled the Zoints tags in the product manager prior to upgrade, then did this conversion, then uninstalled it, now I'm getting this error (by, I presume, google searches):

Warning: main([path]/includes/class_zointstags.php) [function.main]: failed to open stream: No such file or directory in [path]/tags/index.php on line 304

Fatal error: main() [function.require]: Failed opening required '/home/*****/public_html/includes/class_zointstags.php' (include_path='/usr/lib/php:.:/usr/php4/lib/php:/usr/local/php4/lib/php') in /home/*****/public_html/tags/index.php on line 304

By the way, I only copied the tags folder over from my old forum directory to the new one after the upgrade, I didn't put all the Zoints stuff back since it was disabled.

Also, this is what I get e-mailed (the above is from the browser):

Invalid SQL:

SELECT zoints_tag.tag, COUNT(*) count FROM zoints_tag zoints_tag
LEFT JOIN thread thread ON(zoints_tag.threadid = thread.threadid)
WHERE thread.forumid IN(43,44,1,2,3,4,5,6,13,21,19,20,26,27,31,15,39,14 ,41,22,47,29,23,38,16,33,18,45,36,37)

AND autogen != 1
GROUP BY zoints_tag.tag
ORDER BY count DESC
LIMIT 30;

MySQL Error : Table '*****_forum2.zoints_tag' doesn't exist
Error Number : 1146
Request Date : Wednesday, July 9th 2008 @ 08:49:08 AM
Error Date : Wednesday, July 9th 2008 @ 08:49:08 AM
Script : http://www.serviceacademyforums.com/tags/index.php/real/search.php
Referrer :
IP Address : 76.189.85.129
Username : **********
Classname : vb_database
MySQL Version : 4.1.22-standard

[zappsan]

You think Google search produces this error? Maybe this could be the case, if people are trying to access tags on your site by using yourdomain.com/tags/sometag. If you would have everything removed from the Zoints tags system, you'd get a 404 error, but since some files are still there, it's trying to make use of the tag system (which has been partially removed) and so you get the error.
I suggest you delete the Zoints tags folder and redirect yourdomain.com/tags/sometag to the vB tag system format which is yourdomain.com/tags.php?tag=sometag so people won't get a 404 error when they try to access your page by using the old tag link.
I hope you understand what you mean.

[TacticalNuke]

It's from a Google search, I forgot to add that but impressive that you know.

Alright, so I'll delete the Zoints folder.

I don't really understand how to do the redirects. I know a site where I can read up on it (and I will), but how do I make sure that every Google search that is looking for Zoints tags is redirected to the new tags system.

Thanks for all the help. :)

EDIT: I think I got it, here is the code I use in my forum root .htaccess:

Redirect /tags http://www.serviceacademyforums.com/tags.php

Anyway, for SEO purposes and for general user friendliness, should I direct to the tags or just to the homepage? I'm tempted to direct to the homepage.

[obmob]

Seems it worked perfect, thanks! :D

[msm_eg]

what i can do if i already uninstall zoint is there anyway to fix the databais error of zoint???

[saxahan]

Installed.Thanks for share.

[caliman]

BIG THANKS FOR THIS MOD.
WORKED PERFECTLY.

FYI vbseo users:

1) You will need to enable this option in config_vbseo.php:

define('VBSEO_URL_TAGS_FILTER', 1);
(change 0 to 1 to enable as shown)

2) Remove old tags folder (forums/tags) completely.

[LoveStream]

I convert from zoints 1.2.1 to vb3.8.0 successfully.

[tefon]

converttags.php starting but is not completed...

No error but, tag 317223 or 1261904 stopped end.

pls help me.

[mykkal]

My site is www.mymodeltalk.com/jobs/ (http://www.mymodeltalk.com/jobs/)

Since installing Zoints I've had problems with the template. THe Zoints tag cloud page doesn't make user of the template i'm using. Any Ideas?

You can see the tag cloud here and compare the difference to the site url above.
www.mymodeltalk.com/jobs/tags/

[tarionyx]

worked great for me... I'm just working on a rewrite rule for the old tags.

[tarionyx]

Ok here's what I did for redirection of the old zoints tag links...

In the vbSEO control panel, under "Define Custom 301 Redirects" put this in there:
'^tags/index\.php/([^/]+)/?$' => 'tags/$1.html'

[veyissen]

edit. : solved

[veyissen]

hi. .. I need a little change in the code . in vbulletin tag options panel, my choice is "max tag on a thread" is 30. But when I convert from zoints to vb with your script, this max number is not important. some threads have 50 or more tags. is it possible to limit if a thread has the max number of tags, dont add the tag to thread... is it possible? .. Thanks a lot

[dutchbb]

I'm having this error after switching to vb tags, anyone please? :(

Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT zoints_tag.tag, COUNT(*) count FROM zoints_tag zoints_tag
LEFT JOIN thread thread ON(zoints_tag.threadid = thread.threadid)
WHERE thread.forumid IN(44,2,6,7,12,10,22,32,41,25,11,42,5,45,31,30,39, 43,46,8,29,50,36,33,9,35,53,27,20,34)

AND autogen != 1
GROUP BY zoints_tag.tag
ORDER BY count DESC
LIMIT 30;

MySQL Error : Table 'forum.zoints_tag' doesn't exist
Error Number : 1146
Request Date : Monday, September 14th 2009 @ 01:24:35 PM
Error Date : Monday, September 14th 2009 @ 01:24:35 PM
Script : http://www.mydomain.com/tags/
Referrer :
IP Address : 81.52.143.33
Username : Niet geregistreerd
Classname : vB_Database
MySQL Version :

[giorgiotave]

Nothing for vBulletin 4.0?

[Domenico]

Will this work with 3.6.8 ?

[Domenico]

I just tested it and I can confirm that it worked for vB 3.6.8. More then 200000 tags were converted easily on our 100% identical testboard and I'm hapy. :)

[birdie]

I still using 3.6 and never upgraded to >3.7 or 4.0 because I extensively used the Zoints tags and still do; they are integral to the running of my forum. Now with 5.0 on the horizon, its time I consider the move.

Is this mod likely to be any use going to 5.0?
Anyone know what my options are?