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.