Database error when accessing AdminCP

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Sunka
    Senior Member
    • Nov 2008
    • 131
    • 3.8.x

    [Forum] Database error when accessing AdminCP

    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,\n  \'maxresults\' => 500,\n  \'searchperpage\' => 25,\n  \'searchfloodtime\' => 0,\n  \'searchqueueupdates\' => 0,\n  \'enablesearches\' => 1,\n  \'votechange\' => 0,\n  \'showvotes\' => 1,\n  \'updatelastpost\' => 0,\n  \'maxpolllength\' => 200,\n  \'advimagepopup_enable\' => 0,\n  \'maxpolloptions\' => 20,\n  \'vbasset_perpage\' => 20,\n  \'vbasset_enable\' => 1,\n  \'lightboxenabled\' => 1,\n  \'thumbcolor\' => \'#000000\',\n  \'attachrow\' => 5,\n  \'thumbquality\' => 75,\n  \'attachthumbssize\' => 150,\n  \'attachthumbs\' => 1,\n  \'attachresize\' => 1,\n  \'viewattachedimages\' => 1,\n  \'allowclosedattachdel\' => 0,\n  \'allowduplicates\' => 1,\n  \'pemdata37\' => \'a:3:{s:12:\"paulm_fci_37\";a:8:{s:9:\"productid\";s:12:\"paulm_fci_37\";s:5:\"title\";s:23:\"Flashchat 5 Integration\";s:11:\"description\";s:44:\"Integration of Flashchat 5 and vBulletin 3.7\";s:7:\"version\";s:7:\"3.7.009\";s:6:\"active\";s:1:\"1\";s:3:\"url\";s:0:\"\";s:15:\"versioncheckurl\";s:0:\"\";s:3:\"cvs\";s:4:\"3.19\";}s:12:\"paulm_wrt_37\";a:8:{s:9:\"productid\";s:12:\"paulm_wrt_37\";s:5:\"title\";s:22:\"Who Has Read a Thread.\";s:11:\"description\";s:39:\"Display members who have read a thread.\";s:7:\"version\";s:7:\"3.7.007\";s:6:\"active\";s:1:\"1\";s:3:\"url\";s:0:\"\";s:15:\"versioncheckurl\";s:0:\"\";s:3:\"cvs\";s:4:\"3.21\";}s:12:\"paulm_mux_37\";a:8:{s:9:\"productid\";s:12:\"paulm_mux_37\";s:5:\"title\";s:15:\"Miserable Users\";s:11:\"description\";s:64:\"A way to really annoy anyone you don\\\'t want visiting your forum.\";s:7:\"version\";s:7:\"3.7.002\";s:6:\"active\";s:1:\"1\";s:3:\"url\";s:0:\"\";s:15:\"versioncheckurl\";s:0:\"\";s:3:\"cvs\";s:4:\"3.14\";}}\',\n  \'phpkd_free37_data\' => \'a:1:{s:9:\"phpkd_aqe\";a:9:{s:9:\"productid\";s:9:\"phpkd_aqe\";s:5:\"title\";s:19:\"Advanced Quick Edit\";s:11:\"description\";s:151:\"This product extends \\\'Quick Edit\\\' functionality to allow most \"Advanced Editor mode\" options [ All Built-In BBCodes ] (with full control from AdminCP).\";s:7:\"version\";s:5:\"1.0.0\";s:6:\"active\";s:1:\"1\";s:3:\"url\";s:76:\"http://www.phpkd.net/forum/misc.php?do=mods&action=producthelp&pid=phpkd_aqe\";s:15:\"versioncheckurl\";s:77:\"http://www.phpkd.net/forum/misc.php?do=mods&action=productcheck&pid=phpkd_aqe\";s:8:\"revision\";s:3:\"115\";s:8:\"released\";s:44:\"2008-07-11 03:03:37 +0300 (Fri, 11 Jul 2008)\";}}\',\n  \'dl2namesugg\' => \'disabled\',\n  \'dl2allowcomments\' => 1,\n  \'dl2showthumbs\' => 1,\n  \'dl2allowimages\' => 1,\n  \'dl2wordwrap\' => 25,\n  \'dl2subcatsdepth\' => 1,\n  \'dl2smalldesc\' => 150,\n  \'dl2perpage\' => 15,\n  \'dl2showtops\' => 39,\n  \'dl2maxtopcontributors\' => 5,\n  \'dl2maxmostpopularfiles\' => 5,\n  \'dl2maxlatestfiles\' => 4,\n  \'dl2folderpath\' => \'./downloads\',\n  \'pemdata38\' => \'a:17:{s:12:\"paulm_mux_38\";a:8:{s:9:\"productid\";s:12:\"paulm_mux_38\";s:5:\"title\";s:15:\"Miserable Users\";s:11:\"description\";s:64:\"A way to really annoy anyone you don\\\'t want visiting your forum.\";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.3\";}s:12:\"paulm_wrt_38\";a:8:{s:9:\"productid\";s:12:\"paulm_wrt_38\";s:5:\"title\";s:22:\"Who Has Read a Thread.\";s:11:\"description\";s:39:\"Display members who have read a thread.\";s:7:\"version\";s:7:\"3.8.003\";s:6:\"active\";s:1:\"1\";s:3:\"url\";s:0:\"\";s:15:\"versioncheckurl\";s:0:\"\";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  \'global_bootstrap_init_complete\' => \'$products = array();\r\nforeach ((array)$vbulletin->dbtech_copyright[\\\'products\\\'] as $optionkey => $productinfo)\r\n{\r\n	if (!isset($vbulletin->options[$optionkey]))\r\n	{\r\n		// Product not installed\r\n		continue;\r\n	}\r\n\r\n	if ($vbulletin->options[$optionkey] == $productinfo[\\\'key\\\'])\r\n	{\r\n		// Already branding free\r\n		continue;\r\n	}\r\n\r\n	// Fake branding free ;D\r\n	$vbulletin->options[$optionkey] = $productinfo[\\\'key\\\'];\r\n\r\n	// Store product title\r\n	$products[] = \\\'<a href=\"http://www.dragonbyte-tech.com/vbecommerce.php?do=product&productid=\\\' . $productinfo[\\\'productid\\\'] . \\\'\">\\\' . $productinfo[\\\'title\\\'] . \\\'</a>\\\';\r\n}\r\n\r\nif (count($products))\r\n{\r\n	$str = implode(\\\', \\\', $products) . \\\' - <a href=\"http://www.dragonbyte-tech.com\" target=\"_blank\">vBulletin Mods & Addons</a> Copyright © \\\' . date(\\\'Y\\\') . \\\' DragonByte Technologies Ltd.\\\' . (!$vbulletin->options[\\\'dbtech_copyright_nohivel\\\'] ? \\\' Runs best on <a href=\"http://www.hivelocity.net/?utm_source=Iain%2BKidd&utm_medium=back%2Blink&utm_term=Dedicated%2BServer%2BSponsor&utm_campaign=Back%2BLinks%2Bfrom%2BIain%2BKidd\" target=\"_blank\">HiVelocity Hosting</a>.\\\' : \\\'\\\');\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 . \"\\\' WHERE forumid = \" . $foruminfo[\\\'forumid\\\'] . \"\");\r\n	unset($forumarraycache, $vbulletin->forumcache);\r\n	require_once(\\\'./includes/adminfunctions.php\\\');\r\n	build_forum_permissions();\r\n	log_moderator_action($threadinfo, \\\'LAM_BanFromThread\\\', $vbphrase[\\\'LAM_BanFromThread_ForumTitle\\\']);\r\n\r\n	unset($LAM_BanFromThread_Query, $LAM_BanFromThread_SQL, $LAM_BanFromThread_Names, $LAM_BanFromThread_UIDs);\r\n\r\n	$vbulletin->url = fetch_seo_url(\\\'forum\\\', $foruminfo);\r\n	eval(print_standard_redirect(\\\'redirect_LAM_BanFromThread_Redirect\\\', true, true));\r\n}\r\n\r\n\',\n  \'cron_script_cleanup_hourly\' => \'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 :
  • HMBeaty
    Senior Member
    • Mar 2005
    • 1105
    • 4.2.5

    #2
    This is a server error. See this page in the manual - http://www.vbulletin.com/docs/html/t...t_mysql_errors
    "Our greatest weakness lies in giving up. The most certain way to succeed is always to try just one more time!"
    "It's important to only think about what you desire, not what you fear to achieve your ultimate goal!!"
    "When doors close, tear down the walls. Never give up!"

    Comment

    • Sunka
      Senior Member
      • Nov 2008
      • 131
      • 3.8.x

      #3
      But this error come when tried to install product from MOD.
      Even with disabled hooks I can not open AdminCP

      Comment

      • HMBeaty
        Senior Member
        • Mar 2005
        • 1105
        • 4.2.5

        #4
        Originally posted by Sunka
        But this error come when tried to install product from MOD.
        Even with disabled hooks I can not open AdminCP
        See post #2
        "Our greatest weakness lies in giving up. The most certain way to succeed is always to try just one more time!"
        "It's important to only think about what you desire, not what you fear to achieve your ultimate goal!!"
        "When doors close, tear down the walls. Never give up!"

        Comment

        • BirdOPrey5
          Senior Member
          • Jul 2008
          • 9613
          • 5.6.3

          #5
          The specific relevant part is:

          Error code 1153: Got a packet bigger than 'max_allowed_packet' bytes
          It means that a query is sent that is larger than your host allows for.

          MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes

          You need to ask your host to increase the 'max_allowed_packet' variable in the my.cnf file and restart MySQL. The default is 1Mb, but most hosts run 8-16 Mb without problems.

          More info here: http://dev.mysql.com/doc/refman/5.0/...too-large.html

          If you feel the mod is responsible you should post a warning/question in the mod thread on vbulletin.org- the mod author may have a clue as to why you would encounter this error.

          Comment

          • Sunka
            Senior Member
            • Nov 2008
            • 131
            • 3.8.x

            #6
            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!

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...