PDA

View Full Version : Administrative and Maintenance Tools - Convert Zoints Thread Tags to vB 3.7 tagging system


zappsan
12 Feb 2008, 15:15
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
12 Feb 2008, 16:44
looked soo promising until it gave a Mysql error will processing 370 of 5550 tags.

zappsan
12 Feb 2008, 16:51
Which error did you get?

Zaiaku
12 Feb 2008, 18:12
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
12 Feb 2008, 19:11
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
12 Feb 2008, 21:00
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
13 Feb 2008, 03:36
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
13 Feb 2008, 07:30
Database error in vBulletin 3.7.0 Beta 4:

at the end of the converting.

FleaBag
13 Feb 2008, 22:21
I will hold off for now with an install, but hope to install soon! :)

kafi
14 Feb 2008, 11:14
GREAT GREAT, please fix the issue!!!

Milion Thanks!!!

zappsan
14 Feb 2008, 12:45
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
16 Feb 2008, 00:57
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
18 Feb 2008, 01:07
it works fine, thanks

just some words are bad like quotvbulletin :)

ZiG
20 Feb 2008, 06:32
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
09 Mar 2008, 21:01
Tried it out during my update to a heavily modded beta6, worked flawlessly!

FleaBag
10 Mar 2008, 00:47
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
21 Mar 2008, 07:16
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
21 Mar 2008, 08:24
Hi,

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

Tks and good job !

Basit
22 Mar 2008, 01:47
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
02 Apr 2008, 17:35
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
12 Apr 2008, 17:34
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
13 Apr 2008, 03:29
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
13 Apr 2008, 03:53
worked perfectly :) thanks again!

skiseiju
13 Apr 2008, 14:19
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
13 Apr 2008, 15:23
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
16 Apr 2008, 23:13
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
17 Apr 2008, 02:08
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
17 Apr 2008, 15:44
Nothing happens here?
I just see :
Converting...



Updating threads...



Done!

sensimilla
18 Apr 2008, 15:48
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
19 Apr 2008, 03:33
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
20 Apr 2008, 02:38
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
20 Apr 2008, 23:26
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
21 Apr 2008, 01:36
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
21 Apr 2008, 17:45
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
21 Apr 2008, 22:01
Ok, tonite ill run the new version :)

Thanks zappsan!

elmati
22 Apr 2008, 02:49
Hey Zappsan i run the converter again and everything works fine!

Thanks a lot for your help :)

Very usefull, ty a lot!

bada_bing
22 Apr 2008, 03:13
Will this work for the zoints thread tags for vb 3.5.x ?

elmati
22 Apr 2008, 06:03
i think u first need to upgrade to vbulletin 3.7 in order to use this converter...
new version works perfect!

zappsan
22 Apr 2008, 14:24
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
23 Apr 2008, 04:17
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
23 Apr 2008, 05:27
yah! no errors this time. :) thx

993ti
26 Apr 2008, 18:25
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
26 Apr 2008, 21:14
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
26 Apr 2008, 21:27
how would i put that for vbseo?

993ti
26 Apr 2008, 21:32
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
29 Apr 2008, 14:41
Subscribed to this for when I upgrade.

Sal Collaziano
30 Apr 2008, 16:54
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
30 Apr 2008, 17:15
uh? you were getting loads of database message about what?

having connect error?

or you mean that the spiders are getting 404?

FleaBag
01 May 2008, 17:41
Just ran it and it worked flawlessly! Thanks.

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

MissKalunji
01 May 2008, 17:52
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
01 May 2008, 18:33
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
01 May 2008, 18:44
great thanks :)

Sal Collaziano
02 May 2008, 06:48
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
02 May 2008, 17:15
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
11 May 2008, 04:23
Works flawlessly!! Now i can remove zoints finally. Though i love Zoints. It served my forums a great deal.

imranbaig
12 May 2008, 06:47
Thanks, Tried on 3.7 Gold Worked like Charm

Fırtına
15 May 2008, 22:30
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
16 May 2008, 11:56
wow seems that it converted alllllllllll the TAGS !!

Thanks alot man :)

RC.
16 May 2008, 22:57
wowww great, works very fine... thanks.

Mecho
17 May 2008, 11:52
EDIT : "Everything is FINE and this mod works like a charm ."

Fırtına
18 May 2008, 09:40
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
18 May 2008, 22:53
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
19 May 2008, 11:30
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
19 May 2008, 12:47
That settings about interesting with vbseo plugin.

Go
www.vbseo.com Turkish Section :)

Amenadiel
21 May 2008, 15:05
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
23 May 2008, 23:05
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
24 May 2008, 13:16
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 -> http://www.vbulletin.org/forum/showpost.php?p=1526896&postcount=65

web_styler
30 May 2008, 02:14
3.7.0 Turkish karakter problems

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

libertylounge
03 Jun 2008, 08:52
Worked perfectly for me with 3.7.1 ..thank you SO MUCH for writing this.

delinetciler
04 Jun 2008, 15:15
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
04 Jun 2008, 20:45
thank you.

briansol
07 Jun 2008, 05:58
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
07 Jun 2008, 09:38
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
22 Jun 2008, 03:33
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
22 Jun 2008, 03:45
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
24 Jun 2008, 05:02
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
24 Jun 2008, 09:45
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
24 Jun 2008, 09:56
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
09 Jul 2008, 12:55
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
09 Jul 2008, 14:41
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
09 Jul 2008, 15:01
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
04 Sep 2008, 17:52
Seems it worked perfect, thanks! :D

msm_eg
13 Sep 2008, 18:30
what i can do if i already uninstall zoint is there anyway to fix the databais error of zoint???

saxahan
13 Oct 2008, 14:21
Installed.Thanks for share.

caliman
15 Dec 2008, 01:22
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
24 Jan 2009, 23:52
I convert from zoints 1.2.1 to vb3.8.0 successfully.

tefon
15 Feb 2009, 16:49
converttags.php starting but is not completed...

No error but, tag 317223 or 1261904 stopped end.

pls help me.

mykkal
23 Feb 2009, 20:58
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
12 Mar 2009, 01:31
worked great for me... I'm just working on a rewrite rule for the old tags.

tarionyx
12 Mar 2009, 02:09
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
10 May 2009, 19:51
edit. : solved

veyissen
20 May 2009, 08:18
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
14 Sep 2009, 17:52
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
07 Jan 2010, 12:55
Nothing for vBulletin 4.0?

Domenico
15 Jun 2010, 21:05
Will this work with 3.6.8 ?

Domenico
09 Sep 2010, 16:21
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
18 Sep 2012, 08:14
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?