Thread: Integration with vBulletin - Zoints Thread Tags - GREAT for SEO
View Single Post
  #450  
Old 12-29-2006, 01:34 PM
vppremier vppremier is offline
 
Join Date: Dec 2006
Posts: 68
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I've made a mistake I believe. I think that I selected all forums to not display the tags, thinking I was enabling tags on them. So I then went and tried to reupload the xml file via the mange products option and I got the following error
-------------------------
Quote:
Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'Zoints Thread Tags', 'admin_options_processing', 'if ($oldsetting[\'varname\'] == \'zointstags_disable_forums\')\r\n{\r\n $vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']] = array_filter(array_map(\'intval\', $vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']]));\r\n # verify existence of forums\r\n foreach ($vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']] as $key => $forumid)\r\n {\r\n if (!isset($vbulletin->forumcache[$forumid]))\r\n {\r\n unset($vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']][$key]);\r\n }\r\n }\r\n \r\n if (count($vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']]))\r\n {\r\n $vbulletin->input->clean_gpc(\'p\', \'zointstags_auto_delete_invalid_tags\', TYPE_BOOL);\r\n if ($vbulletin->GPC[\'zointstags_auto_delete_invalid_tags\'])\r\n {\r\n # get threadids\r\n $threadids = array();\r\n $_threadids = $vbulletin->db->query_read(\"\r\n SELECT DISTINCT thread.threadid FROM \" . TABLE_PREFIX . \"thread thread\r\n LEFT JOIN \" . TABLE_PREFIX . \"zoints_tag zoints_tag ON(zoints_tag.threadid = thread.threadid)\r\n WHERE zoints_tag.tag IS NOT NULL\r\n AND thread.forumid IN(\" . implode(\',\', $vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']]) . \")\r\n \");\r\n while (list($threadid) = $vbulletin->db->fetch_row($_threadids))\r\n {\r\n $threadids[] = $threadid;\r\n }\r\n \r\n if (count($threadids))\r\n {\r\n $vbulletin->db->query_write(\"DELETE FROM \" . TABLE_PREFIX . \"zoints_tag WHERE threadid IN(\" . implode(\',\', $threadids) . \")\");\r\n # also delete tags from zoints\r\n $bits = array();\r\n foreach ($threadids as $id)\r\n {\r\n $bits[] = \"($id, \" . TIMENOW . \")\";\r\n }\r\n $vbulletin->db->query_write(\"REPLACE INTO \" . TABLE_PREFIX . \"zoints_tag_update (threadid, dateline) VALUES \" . implode(\',\', $bits));\r\n }\r\n }\r\n }\r\n \r\n $vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']] = serialize($vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']]);\r\n}', 'zointstags');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Friday, December 29th 2006 @ 08:31:36 AM
Script : http://stepinthezone.com/forum/admincp/plugin.php
Referrer : http://stepinthezone.com/forum/admin...?do=productadd
IP Address : Mp ip
Username : My username
Classname : vb_database
How can I fix this? How can I reinstall?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01072 seconds
  • Memory Usage 1,773KB
  • 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_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