Status
Not open for further replies.

Sunka

Customer
Same problem discribed in this thread.

When tried to install this MOD, when click in AdminCP to install MOD product xml file shows this vBulletin database error.
I can not go back to AdminCP any more. I have tried disabling my modifications/plugins by editing includes/config.php but still same database error.
I can not say for sure is this MOD installed or not?


Code:
Database error in vBulletin 4.1.5:

Invalid SQL:

                REPLACE INTO adminutil
                    (title, text)
                VALUES
                    ('datastore', '<?php\n### start options ###\n$options = array (\n  \'tagcloud_tags\' => 70,\n  \'tagforcelower\' => 1,\n  \'tagmaxuser\' => 2,\n  \'tagmaxstarter\' => 5,\n  \'tagmaxthread\' => 25,\n  \'tagdelimiter\' => \'\',\n  \'taggoodwords\' => \'\',\n  \'tagbadwords\' => \'\',\n  \'tagmaxlen\' => 25,\n  \'tagminlen\' => 3,\n  \'threadtagging\' => 1,\n  \'ratefunc\' => \'none\',\n  \'ratescore\' => 0.5,\n  \'viewfunc\' => \'none\',\n  \'viewscore\' => 0.01,\n  \'replyfunc\' => \'none\',\n  \'replyscore\' => 0.1,\n  \'posttitlescore\' => 5,\n  \'threadtitlescore\' => 5,\n  \'datescore\' => 15,\n  \'multimatchscore\' => 15,\n  \'allowwildcards\' => 1,\n  \'goodwords\' => \'vb vbb php sql\',\n  \'badwords\' => \'riba ribe biljka biljke vrtlarstvo ribolov\',\n  \'similarthreadthreshold\' => 3.5,\n  \'searchsharing\' => 1,\n  \'similarthreadsearch\' => 0,\n  \'maxsearchlength\' => 20,\n  \'minsearchlength\' => 4,"\";s:3:\"cvs\";s:3:\"1.8\";}s:12:\"paulm_dup_38\";a:8:{s:9:\"productid\";s:12:\"paulm_dup_38\";s:5:\"title\";s:44:\"Display Unread Posts and Reputation Comments\";s:11:\"description\";s:105:\"Display the number of posts you have marked as unread and the number of new (unread) reputation comments.\";s:7:\"version\";s:7:\"3.8.004\";s:6:\"active\";s:1:\"1\";s:3:\"url\";s:0:\"\";s:15:\"versioncheckurl\";s:0:\"\";s:3:\"cvs\";s:4:\"1.11\";}s:12:\"paulm_mpr_38\";a:8:{s:9:\"productid\";s:12:\"paulm_mpr_38\";s:5:\"title\";s:33:\"Member Profile Reputation Display\";s:11:\"description\";s:55:\"Display a members reputation comments in their profile.\";s:7:\"version\";s:7:\"3.8.001\";s:6:\"active\";s:1:\"1\";s:3:\"url\";s:0:\"\";s:15:\"versioncheckurl\";s:0:\"\";s:3:\"cvs\";s:3:\"1.5\";}s:12:\"paulm_trg_38\";a:8:{s:9:\"productid\";s:12:\"paulm_trg_38\";s:5:\"title\";s:14:\"Guest Tracking\";s:11:\"description\";s:18:\"Track Guest Visits\";s:7:\"version\";s:7:\"3.8.002\";s:6:\"active\";s:1:\"1\";s:3:\"url\";s:0:\"\";s:15:\"versioncheckurl\";s:0:\"\";s:3:\"cvs\";s:3:\"1.9\";}s:12:\"paulm_trm_38\";a:8:{s:9:\"productid\";s:12:\"paulm_trm_38\";s:5:\"title\";s:15:\"Member Tracking\";s:11:\"description\";s:19:\"Track Member Visits

MANY SIMILARLY TEXTS...


;\r\n                if ($_SERVER[\\\'HTTP_REFERER\\\'])\r\n                {\r\n                    $vsacb_redto = $_SERVER[\\\'HTTP_REFERER\\\'];\r\n                }\r\n                else\r\n                {\r\n                    $vsacb_redto = \\\'misc.php?\\\'.$vbulletin->session->vars[\\\'sessionurl\\\'].\\\'do=cchatbox\\\';\r\n                }\r\n                exec_header_redirect($vsacb_redto);\r\n            }\r\n\r\n            if (($_REQUEST[\\\'do\\\']==\\\'vsacb_banuser\\\') AND $vsacb_canmod)\r\n            {\r\n                $vbulletin->db->hide_errors();\r\n                $vsacb_usertoban = $vbulletin->input->clean_gpc(\\\'r\\\', \\\'u\\\', TYPE_UINT);\r\n                $vsacb_banuser = $vbulletin->options[\\\'vsachatbox_excluded_users\\\'].\\\',\\\'.$vsacb_usertoban;\r\n                $vsacb_banuser = str_replace(\\\',,\\\',\\\',\\\',$vsacb_banuser);\r\n                $vsacb_banuser = trim($vsacb_banuser, \\\',\\\');\r\n                $vbulletin->db->query_write(\"UPDATE \" . TABLE_PREFIX . \"setting SET value = \\\'\".$vsacb_banuser.\"\\\' WHERE varname = \\\'vsachatbox_excluded_users\\\' \");\r\n                $vbulletin->db->show_errors();\r\n                require_once(DIR . \\\'/includes/adminfunctions.php\\\');\r\n                build_options();\r\n                exec_header_redirect(\\\'misc.php?\\\'.$vbulletin->session->vars[\\\'sessionurl\\\'].\\\'do=ccarc\\\');\r\n            }\r\n\r\n            if (($_REQUEST[\\\'do\\\']==\\\'vsacb_unbanuser\\\') AND $vsacb_canmod)\r\n            {\r\n                $vbulletin->db->hide_errors();\r\n                $vsacb_usertounban = $vbulletin->input->clean_gpc(\\\'r\\\', \\\'u\\\', TYPE_UINT);\r\n                $vsacb_unbanuser = str_replace($vsacb_usertounban,\\\'\\\',$vbulletin->options[\\\'vsachatbox_excluded_users\\\']);\r\n                $vsacb_unbanuser = str_replace(\\\',,\\\',\\\',\\\',$vsacb_unbanuser);\r\n                $vsacb_unbanuser = trim($vsacb_unbanuser, \\\',\\\');\r\n                $vbulletin->db->query_write(\"UPDATE \" . TABLE_PREFIX . \"setting SET value = \\\'\".$vsacb_unbanuser.\"\\\' WHERE varname = \\\'vsachatbox_excluded_users\\\' \");\r\n                $vbulletin->db->show_errors();\r\n                require_once(DIR . \\\'/includes/adminfunctions.php\\\');\r\n                build_options();\r\n                exec_header_redirect(\\\'misc.php?\\\'.$vbulletin->session->vars[\\\'sessionurl\\\'].\\\'do=ccarc\\\');\r\n            }\r\n\r\n            if (($_REQUEST[\\\'do\\\']==\\\'vsacb_deluser\\\') AND $vsacb_canmod)\r\n            {\r\n                $vbulletin->db->hide_errors();\r\n                $vsacb_usertodel = $vbulletin->input->clean_gpc(\\\'r\\\', \\\'u\\\', TYPE_UINT);\r\n                $vbulletin->db->query_write(\" DELETE FROM \" . TABLE_PREFIX . \"vsa_chatbox WHERE userid = \\\'\".$vsacb_usertodel.\"\\\' \");\r\n                $vbulletin->db->show_errors();\r\n                exec_header_redirect(\\\'misc.php?\\\'.$vbulletin->session->vars[\\\'sessionurl\\\'].\\\'do=ccarc\\\');\r\n            }\r\n\r\n            if ($_REQUEST[\\\'do\\\']==\\\'vsacb_delmess\\\')\r\n            {\r\n                $vbulletin->db->hide_errors();\r\n                $vsacb_messtodel = $vbulletin->input->clean_gpc(\\\'r\\\', \\\'m\\\', TYPE_UINT);\r\n                $vsacb_getmessinfo = $vbulletin->db->query_first(\"SELECT id, userid from \" . TABLE_PREFIX . \"vsa_chatbox WHERE id = \\\'\".$vsacb_messtodel.\"\\\' \");\r\n                if ((($vsacb_getmessinfo[\\\'userid\\\']==$vbulletin->userinfo[\\\'userid\\\']) AND $vbulletin->options[\\\'vsachatbox_users_candelete\\\']) OR $vsacb_canmod)\r\n                {\r\n                    $vbulletin->db->query_write(\" DELETE FROM \" . TABLE_PREFIX . \"vsa_chatbox WHERE id = \\\'\".$vsacb_messtodel.\"\\\' \");\r\n                }\r\n                $vbulletin->db->show_errors();\r\n                exec_header_redirect(\\\'misc.php?\\\'.$vbulletin->session->vars[\\\'sessionurl\\\'].\\\'do=ccarc\\\');\r\n            }\r\n        }\r\n\',\n  tr = implode(\\\', \\\', $products) . \\\' - <a href=\"http://www.dragonbyte-tech.com\" target=\"_blank\">vBulletin Mods & Addons</a> Copyright © \\\' . date(\\\'Y\\\') . \\\' DragonByte Technologies Ltd.\\\';\r\n    $vbulletin->options[\\\'copyrighttext\\\'] = (trim($vbulletin->options[\\\'copyrighttext\\\']) != \\\'\\\' ? $str . \\\'<br />\\\' . $vbulletin->options[\\\'copyrighttext\\\'] : $str);\r\n}\r\nrequire(DIR . \\\'/dbtech/infopanels/hooks/global_start.php\\\');\r\nrequire(DIR . \\\'/dbtech/bookmark/hooks/global_start.php\\\');\r\nrequire(DIR . \\\'/dbtech/thanks/hooks/global_start.php\\\');\r\nif (isset($GLOBALS[\\\'vbulletin\\\']->bf_ugp_genericoptions[\\\'isbannedgroup\\\']))\r\n{\r\n    $GLOBALS[\\\'show\\\'][\\\'is_banned_user\\\'] = ($GLOBALS[\\\'vbulletin\\\']->usergroupcache[$GLOBALS[\\\'vbulletin\\\']->userinfo[\\\'usergroupid\\\']][\\\'genericoptions\\\'] & $GLOBALS[\\\'vbulletin\\\']->bf_ugp_genericoptions[\\\'isbannedgroup\\\'] ? true : false);\r\n}\r\nelse\r\n{\r\n    $GLOBALS[\\\'show\\\'][\\\'is_banned_user\\\'] = ($GLOBALS[\\\'vbulletin\\\']->usergroupcache[$GLOBALS[\\\'vbulletin\\\']->userinfo[\\\'usergroupid\\\']][\\\'genericoptions\\\'] & $GLOBALS[\\\'vbulletin\\\']->bf_ugp_genericoptions[\\\'isnotbannedgroup\\\'] ? false : true);\r\n}\r\n\r\nif ($GLOBALS[\\\'show\\\'][\\\'is_banned_user\\\'])\r\n{\r\n    if ((THIS_SCRIPT == \\\'login\\\') && isset($_REQUEST[\\\'do\\\']) && ($_REQUEST[\\\'do\\\'] == \\\'logout\\\'))\r\n    {\r\n        exit;\r\n    }\r\n}\r\n\',\n  \'forumhome_complete\' => \'require(DIR . \\\'/dbtech/infopanels/hooks/forumhome_complete.php\\\');\r\nif (is_array($vbulletin->blogstats) AND $vbulletin->userinfo[\\\'permissions\\\'][\\\'vbblog_general_permissions\\\'] & $vbulletin->bf_ugp_vbblog_general_permissions[\\\'blog_canviewothers\\\'])\r\n{\r\n    if ($latestentry = $vbulletin->blogstats[\\\'lastentry.....


MANY SIMILARLY TEXTS...

        unset($LAM_BanFromThread_SQL, $LAM_BanFromThread_UIDs);\r\n\r\n        foreach ($LAM_BanFromThread_Names AS $LAM_BanFromThread_Name) {\r\n            $LAM_BanFromThread_Name = $db->escape_string(htmlspecialchars_uni(trim($LAM_BanFromThread_Name)));\r\n\r\n            if (!empty($LAM_BanFromThread_Name)) {\r\n                $LAM_BanFromThread_Query = $db->query_first(\"SELECT userid FROM \" . TABLE_PREFIX .\"user AS user WHERE username = \\\'$LAM_BanFromThread_Name\\\'\");\r\n\r\n                if ($LAM_BanFromThread_Query) {\r\n                    $LAM_BanFromThread_UIDs .= \",\" . $LAM_BanFromThread_Query[\\\'userid\\\'];\r\n                    $db->free_result($LAM_BanFromThread_Query);\r\n                } else {\r\n                    eval(standard_error(fetch_error(\\\'LAM_BanFromThread_UnknownUserName\\\', $LAM_BanFromThread_Name)));\r\n                }\r\n            }\r\n        }\r\n\r\n        $LAM_BanFromThread_UIDs = substr($LAM_BanFromThread_UIDs, 1);\r\n\r\n    }\r\n\r\n    $db->query_write(\"UPDATE \" . TABLE_PREFIX . \"forum SET LAM_BanFromThread = \\\'\" . $LAM_BanFromThread_UIDs . \'require_once(DIR . \\\'/includes/class_bootstrap_framework.php\\\');\r\nvB_Bootstrap_Framework::init();\r\nvB_Cache::instance()->clean(true);\r\n\r\n\r\n                    require_once(DIR . \\\'/includes/class_bootstrap_framework.php\\\');\r\n                    vB_Bootstrap_Framework::init();\r\n                    vB_Cache::instance()->clean(true);\r\n\r\n\r\n\',\n  \'mail_send\' => \'if ($vbulletin->session->vars[\\\'CRONTASK_REMINDERMAIL\\\'] == 1 )\r\n{\r\n\r\n  if (strtolower($vbulletin->options[\\\'reminder_emailformat\\\']) == \\\'html\\\')\r\n  {\r\n     $headers = str_replace(\\\'Content-Type: text/plain\\\', \\\'Content-Type: text/html\\\', $headers);\r\n  }\r\n\r\n}\r\n\',\n  \'profile_editoptions_start\' => \'require_once(DIR . \\\'/packages/skimlinks/hooks/profile_editoptions_start.php\\\');\r\n\',\n  \'profile_updateoptions\' => \'require_once(DIR . \\\'/packages/skimlinks/hooks/profile_updateoptions.php\\\');\r\n\',\n  \'editor_toolbar_end\' => \'############################################################\r\n#                      Marco Mamdouh                       #\r\n#        Advanced CKEditor For vBulletin Powered Forums    #\r\n############################################################\r\nif ($editor_type == \\\'qr\\\' ||  $editor_type == \\\'qe\\\')\r\n{\r\n\r\n               if($vbulletin->options[\\\'MARCO1_format\\\']){\r\n        if (!isset($checked[\\\'disablesmilies\\\']))\r\n        {\r\n            $vbulletin->input->clean_gpc(\\\'r\\\', \\\'disablesmilies\\\', TYPE_BOOL);\r\n            $checked[\\\'disablesmilies\\\'] = iif($vbulletin->GPC[\\\'disablesmilies\\\'], \\\'checked=\"checked\"\\\');\r\n        }\r\n        $templater = vB_Template::create(\\\'newpost_disablesmiliesoption\\\');\r\n            $templater->register(\\\'checked\\\', $checked);\r\n        $disablesmiliesoption = $templater->render();\r\n\r\n        if ($toolbartype AND ($vbulletin->options[\\\'smtotal\\\'] > 0 OR $vbulletin->options[\\\'wysiwyg_smtotal\\\'] > 0))\r\n        {\r\n\r\n            $smilies = $vbulletin->db->query_read_slave(\"\r\n                SELECT smilieid, smilietext, smiliepath, smilie.title,\r\n                    imagecategory.title AS category\r\n                FROM \" . TABLE_PREFIX . \"smilie AS smilie\r\n                LEFT JOIN \" . TABLE_PREFIX . \"imagecategory AS imagecategory USING(imagecategoryid)\r\n                ORDER BY imagecategory.displayorder, imagecategory.title, smilie.displayorder\r\n            \");\r\n\r\n\r\n            $totalsmilies = $vbulletin->db->num_rows($smilies);\r\n\r\n            if ($totalsmilies > 0)\r\n            {\r\n                if ($vbulletin->options[\\\'wysiwyg_smtotal\\\'] > 0)\r\n                {\r\n                    $show[\\\'wysiwygsmilies\\\'] = true;\r\n\r\n                if ($vbulletin->options[\\\'smtotal\\\'])\r\n                {\r\n                    $vbulletin->db->data_seek($smilies, 0);\r\n                    $i = 0;\r\n                    $smiliebits = \\\'\\\';\r\n                    while ($smilie = $vbulletin->db->fetch_array($smilies) AND $i++ < $vbulletin->options[\\\'smtotal\\\'])\r\n                    {\r\n                        $templater = vB_Template::create(\\\'editor_smilie\\\');\r\n                            $templater->register(\\\'smilie\\\', $smilie);\r\n                            $templater->register(\\\'editorid\\\', $editorid);\r\n                        $smiliebits .= $templater->render();\r\n                    }\r\n\r\n                    $show[\\\'moresmilieslink\\\'] = ($totalsmilies > $vbulletin->options[\\\'smtotal\\\']);\r\n                    $show[\\\'smiliebox\\\'] = true;\r\n                }\r\n\r\n                $vbulletin->db->free_result($smilies);\r\n            }\r\n        }\r\n        if ($vbulletin->options[\\\'smtotal\\\'] > 0)\r\n        {\r\n            $templater = vB_Template::create(\\\'editor_smiliebox\\\');\r\n                $templater->register(\\\'editorid\\\', $editorid);\r\n                $templater->register(\\\'smiliebits\\\', $smiliebits);\r\n                $templater->register(\\\'totalsmilies\\\', $totalsmilies);\r\n            $smiliebox = $templater->render();\r\n        }\r\n        else\r\n        {\r\n            $smiliebox = \\\'\\\';\r\n        }\r\n    }\r\n    }\r\n\r\n    }\r\nrequire(DIR . \\\'/dbtech/thanks/hooks/editor_toolbar_end.php\\\');\r\n\',\n  \'private_complete\' => \'if ($vbulletin->options[\\\'bop5cspms_en\\\'] AND $vbulletin->options[\\\'bop5cspms_reply\\\'] AND is_member_of($vbulletin->userinfo, explode(\\\',\\\',$vbulletin->options[\\\'bop5cspms_secondary\\\'])) AND !is_member_of($vbulletin->userinfo, explode(\\\',\\\',$vbulletin->options[\\\'bop5cspms_whitelist\\\'])))\r\n{\r\n    $show[\\\'quickreply\\\'] = false;\r\n}\r\n\r\nif ($vbulletin->options[\\\'bop5cspms_en\\\'] AND $vbulletin->options[\\\'bop5cspms_reply\\\'] AND in_array($vbulletin->userinfo[\\\'usergroupid\\\'], explode(\\\',\\\',$vbulletin->options[\\\'bop5cspms_primary\\\'])) AND !is_member_of($vbulletin->userinfo, explode(\\\',\\\',$vbulletin->options[\\\'bop5cspms_whitelist\\\'])))\r\n{\r\n    $show[\\\'quickreply\\\'] = false;\r\n}\r\n\r\nif ($vbulletin->options[\\\'bop5cspms_en\\\'] AND $vbulletin->options[\\\'bop5cspms_reply\\\'] AND in_array($vbulletin->userinfo[\\\'userid\\\'], explode(\\\',\\\',$vbulletin->options[\\\'bop5cspms_users\\\'])))\r\n{\r\n    $show[\\\'quickreply\\\'] = false;\r\n}\r\n$includecss[\\\'pmpreview\\\'] = \\\'pmpreview.css\\\';\r\n\',\n  \'global_bootstrap_complete\' => \'require(DIR . \\\'/dbtech/thanks/hooks/process_templates_complete.php\\\');\r\n\',\n  \'editpost_edit_start\' => \'require(DIR . \\\'/dbtech/thanks/hooks/newreply_form_start.php\\\');\r\n\',\n  \'editpost_update_process\' => \'require(DIR . \\\'/dbtech/thanks/hooks/editpost_update_process.php\\\');\r\n\',\n  \'blog_post_newentry_start\' => \'require(DIR . \\\'/dbtech/thanks/hooks/blog_post_newentry_start.php\\\');\r\n\',\n  \'announcement_query\' => \'require(DIR . \\\'/dbtech/thanks/hooks/statistics.php\\\');\r\n\',\n  \'private_messagelist_messagebit\' => \'$pm[\\\'preview\\\'] = strip_quotes($pm[\\\'message\\\']);\r\n$pm[\\\'preview\\\'] = htmlspecialchars_uni(fetch_censored_text(fetch_trimmed_title(strip_bbcode($pm[\\\'preview\\\'], false, true, true, true), $vbulletin->options[\\\'threadpreview\\\'])));\r\n\',\n  \'private_messagelist_start\' => \'require_once(DIR . \\\'/includes/class_template_parser.php\\\');\r\n$parser = new vB_TemplateParser(\\\'{vb:raw pm.title}</a>\\\');\r\n$parser->dom_doc = new vB_DomDocument($parser->fetch_dom_compatible());\r\n$find = trim($parser->_parse_nodes($parser->dom_doc->childNodes()));\r\n\r\n$parser = new vB_TemplateParser(\\\'{vb:raw pm.title}</a> <span class=\"pmpreview\">{vb:raw pm.preview}</span>\\\');\r\n$parser->dom_doc = new vB_DomDocument($parser->fetch_dom_compatible());\r\n$replace = trim($parser->_parse_nodes($parser->dom_doc->childNodes()));\r\n$vbulletin->templatecache[\\\'pm_messagelistbit\\\'] = str_replace($find, $replace, $vbulletin->templatecache[\\\'pm_messagelistbit\\\']);\r\n\',\n);\n### end pluginlist ###\n\n?>');

MySQL Error   : Got a packet bigger than 'max_allowed_packet' bytes
Error Number  : 1153
Request Date  : Sunday, January 22nd 2012 @ 07:31:55 AM
Error Date    : Sunday, January 22nd 2012 @ 07:31:55 AM
Script        : http://www.pijanitvor.com/admincp/index.php
Referrer      :
IP Address    : xxxxxxxxxxx
Username      :
Classname     : vB_Database
MySQL Version :
 
You need to contact your host and tell them to increase your max_allowed_packet size. You got that error due to it being set to small.
 
Yep...
Solved by the host.

Error number clearly indicate to server error, but it happend straight with instalation with this MOD, so I think it could be related to this MOD installation.

Problem solved!
 
Status
Not open for further replies.

Legacy Copyright Management

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
134
Customer rating
0.00 star(s) 0 ratings
Back
Top