vb.org Archive

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)

GrendelKhan{TSU 04-23-2008 04:27 AM

yah! no errors this time. :) thx

993ti 04-26-2008 05:25 PM

For those who want to redirect the Zoints taglinks in searchengines to the vbulletin tags:
Open tags/.htaccess and replace
Code:

RewriteRule ^(.+)/$ index.php?tag=$1 [NC,QSA,L]
With
Code:

RewriteRule ^(.+)/$ http://www.DOMAINNAME.com/tags.php?tag=$1 [R=301,L]

Keyser Soze 04-26-2008 08:14 PM

Quote:

Originally Posted by 993ti (Post 1499940)
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 04-26-2008 08:27 PM

how would i put that for vbseo?

993ti 04-26-2008 08:32 PM

Quote:

Originally Posted by Keyser Soze (Post 1500070)
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 :)
Quote:

Originally Posted by MissKalunji (Post 1500082)
how would i put that for vbseo?

Don't know, i don't use VBseo.

tpearl5 04-29-2008 01:41 PM

Subscribed to this for when I upgrade.

Sal Collaziano 04-30-2008 03:54 PM

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 04-30-2008 04:15 PM

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

having connect error?

or you mean that the spiders are getting 404?

FleaBag 05-01-2008 04:41 PM

Just ran it and it worked flawlessly! Thanks.

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

MissKalunji 05-01-2008 04:52 PM

Quote:

Originally Posted by FleaBag (Post 1504760)
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 05-01-2008 05:33 PM

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 05-01-2008 05:44 PM

great thanks :)

Sal Collaziano 05-02-2008 05:48 AM

Quote:

Originally Posted by MissKalunji (Post 1503558)
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 05-02-2008 04:15 PM

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 05-11-2008 03:23 AM

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

imranbaig 05-12-2008 05:47 AM

Thanks, Tried on 3.7 Gold Worked like Charm

Fırtına 05-15-2008 09:30 PM

Error: Thread 5236 of 6221


Code:

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 05-16-2008 10:56 AM

wow seems that it converted alllllllllll the TAGS !!

Thanks alot man :)

RC. 05-16-2008 09:57 PM

wowww great, works very fine... thanks.

Mecho 05-17-2008 10:52 AM

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

Fırtına 05-18-2008 08:40 AM

Quote:

Originally Posted by Fırtına (Post 1521072)
Error: Thread 5236 of 6221


Code:

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 05-18-2008 09:53 PM

Quote:

Originally Posted by Mecho (Post 1522473)
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 ??

Quote:

Originally Posted by Fırtına (Post 1523252)
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 05-19-2008 10:30 AM

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 05-19-2008 11:47 AM

That settings about interesting with vbseo plugin.

Go
www.vbseo.com Turkish Section :)

Amenadiel 05-21-2008 02:05 PM

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

Quote:

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 05-23-2008 10:05 PM

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 05-24-2008 12:16 PM

Quote:

Originally Posted by chadi (Post 1529459)
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....6&postcount=65

web_styler 05-30-2008 01:14 AM

3.7.0 Turkish karakter problems

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

libertylounge 06-03-2008 07:52 AM

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

delinetciler 06-04-2008 02:15 PM

T?rk?e karakter sorunun ??z?m? burada

suvari1794 06-04-2008 07:45 PM

thank you.

briansol 06-07-2008 04:58 AM

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 06-07-2008 08:38 AM

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 06-22-2008 02:33 AM

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 06-22-2008 02:45 AM

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 06-24-2008 04:02 AM

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 06-24-2008 08:45 AM

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 06-24-2008 08:56 AM

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 07-09-2008 11:55 AM

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/...eal/search.php
Referrer :
IP Address : 76.189.85.129
Username : **********
Classname : vb_database
MySQL Version : 4.1.22-standard

zappsan 07-09-2008 01:41 PM

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.


All times are GMT. The time now is 01:08 AM.

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.01331 seconds
  • Memory Usage 1,830KB
  • 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
  • (4)bbcode_code_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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