Thread: Administrative and Maintenance Tools - Convert Zoints Thread Tags to vB 3.7 tagging system
View Single Post
  #31  
Old 04-19-2008, 01:33 AM
zappsan's Avatar
zappsan zappsan is offline
 
Join Date: Sep 2004
Posts: 188
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by skiseiju View Post
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 View Post
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 View Post
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.
Quote:
Originally Posted by 993ti View Post
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?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01600 seconds
  • Memory Usage 1,776KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (4)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete