Thread: Miscellaneous Hacks - vBsociable
View Single Post
  #52  
Old 08-27-2007, 06:59 PM
tribedude tribedude is offline
 
Join Date: Feb 2002
Posts: 39
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I am having difficulty installing this product in our 3.58 test forum. When I import the product it generates this error in the vBulletin product manager:

Database error in vBulletin 3.5.8:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'vBSociable', 'showthread_complete', '// ################################################## ###############################\r\n// vBsociable\r\n$vBsociable = array(\r\n \'del.icio.us\' => array(\r\n \'img\' => \'delicious.png\',\r\n \'url\' => \'http://del.icio.us/post?url=LINK&title=TITLE\'\r\n ),\r\n \'Digg\' => array(\r\n \'img\' => \'digg.png\',\r\n \'url\' => \'http://digg.com/submit?phase=2&url=LINK&title=TITLE\'\r\n ),\r\n \'Facebook\' => array(\r\n \'img\' => \'facebook.png\',\r\n \'url\' => \'http://www.facebook.com/share.php?u=LINK\'\r\n ),\r\n \'feedmelinks\' => array(\r\n \'img\' => \'feedmelinks.png\',\r\n \'url\' => \'http://feedmelinks.com/categorize?from=toolbar&op=submit&url=LINK &name=TITLE\'\r\n ),\r\n \'Furl\' => array(\r\n \'img\' => \'furl.png\',\r\n \'url\' => \'http://www.furl.net/storeIt.jsp?u=LINK&t=TITLE\'\r\n ),\r\n \'Ma.gnolia\' => array(\r\n \'img\' => \'magnolia.png\',\r\n \'url\' => \'http://ma.gnolia.com/bookmarklet/add?url=LINK&title=TITLE\'\r\n ),\r\n \'NewsVine\' => array(\r\n \'img\' => \'newsvine.png\',\r\n \'url\' => \'http://www.newsvine.com/_tools/seed&save?u=LINK&h=TITLE\'\r\n ),\r\n \'Netscape\' => array(\r\n \'img\' => \'netscape.gif\',\r\n \'url\' => \'http://www.netscape.com/submit/?U=LINK&T=TITLE\'\r\n ),\r\n \'Reddit\' => array(\r\n \'img\' => \'reddit.png\',\r\n \'url\' => \'http://reddit.com/submit?url=LINK&title=TITLE\'\r\n ),\r\n \'Slashdot\' => array(\r\n \'img\' => \'slashdot.png\',\r\n \'url\' => \'http://slashdot.org/bookmark.pl?title=TITLE&url=LINK\'\r\n ),\r\n \'SphereIt\' => array(\r\n \'img\' => \'sphere.png\',\r\n \'url\' => \'http://www.sphere.com/search?q=sphereit:LINK&title=TITLE\'\r\n ),\r\n \'Spurl\' => array(\r\n \'img\' => \'spurl.png\',\r\n \'url\' => \'http://www.spurl.net/spurl.php?url=LINK&title=TITLE\'\r\n ),\r\n \'StumbleUpon\' => array(\r\n \'img\' => \'stumbleupon.png\',\r\n \'url\' => \'http://www.stumbleupon.com/submit?url=LINK&title=TITLE\'\r\n ),\r\n \'Technorati\' => array(\r\n \'img\' => \'technorati.png\',\r\n \'url\' => \'http://technorati.com/faves?add=LINK\'\r\n ),\r\n \'YahooMyWeb\' => array(\r\n \'img\' => \'yahoomyweb.png\',\r\n \'url\' => \'http://myweb2.search.yahoo.com/myresults/bookmarklet?u=LINK&=TITLE\'\r\n )\r\n);\r\n\r\nif ($vbulletin->options[\'vBsociable_enabled\'])\r\n{\r\n // Are we wanting to exclude certain forums?\r\n if (!empty($vbulletin->options[\'vBsociable_excluded\']))\r\n {\r\n if (strpos($vbulletin->options[\'vBsociable_excluded\'], \',\') === false)\r\n {\r\n $excluded_forums = array($vbulletin->options[\'vBsociable_excluded\']);\r\n }\r\n else\r\n {\r\n $excluded_forums = explode(\',\', $vbulletin->options[\'vBsociable_excluded\']);\r\n }\r\n }\r\n else\r\n {\r\n $excluded_forums = array();\r\n }\r\n\r\n $excluded = false;\r\n\r\n foreach ($excluded_forums AS $excluded_forum)\r\n {\r\n if ($thread[\'forumid\'] == $excluded_forum)\r\n {\r\n $excluded = true;\r\n break;\r\n }\r\n }\r\n unset($excluded_forums);\r\n\r\n // Let\'s go..\r\n if ($excluded)\r\n {\r\n $show[\'vBsociable\'] = false;\r\n }\r\n else\r\n {\r\n $show[\'vBsociable\'] = true;\r\n $threadurl = urlencode($vbulletin->options[\'bburl\'] . \"/showthread.php?t=$thread[threadid]\");\r\n $threadtitle = urlencode($thread[\'title\']);\r\n\r\n foreach ($vBsociable AS $name => $values)\r\n {\r\n $vBsociable_img = $values[\'img\'];\r\n $vBsociable_phrase = $vbphrase[\'vBsociable_\' . strtolower(str_replace(\'.\', \'\', $name))];\r\n $vBsociable_url = str_replace(array(\r\n \'LINK\',\r\n \'TITLE\'\r\n ), \r\n array(\r\n $threadurl,\r\n $threadtitle\r\n ), $values[\'url\']);\r\n eval(\'$vBsociablebits .= \"\' . fetch_template(\'vBsociable_bits\') . \'\";\');\r\n }\r\n }\r\n}\r\nelse\r\n{\r\n $show[\'vBsociable\'] = false;\r\n}\r\nunset($vBsociable);\r\n// ################################################## ###############################', 'vBsociable');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Monday, August 27th 2007 @ 03:54:18 PM
Script : http://www.velocity.to/forums/admincp/plugin.php

.......


Then the product seems to partially install (it doesn't work but shows up in the installed products). what can I do to solve it?

Thanks for your help.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01217 seconds
  • Memory Usage 1,791KB
  • 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)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