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?
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 :
