The Arcive of Official vBulletin Modifications Site.

FReeSTER · #1 05-29-2011, 03:15 PM

Hey guys Im getting this error when editing an existing forum or making/adding a new forum through Forum Manager.

Code:

Database error in vBulletin 4.0.8:

Invalid SQL:

			REPLACE INTO datastore
				(title, data, unserialize)
			VALUES
				('forumcache', 'a:824:{i:798;a:34:{s:7:\"forumid\";i:798;s:7:\"styleid\";i:0;s:5:\"title\";s:14:\"vBCms Comments\";s:11:\"title_clean\";s:14:\"vBCms Comments\";s:11:\"description\";N;s:17:\"description_clean\";N;s:7:\"options\";i:24262;s:11:\"showprivate\";i:0;s:12:\"displayorder\";i:0;s:10:\"lastpostid\";i:11296;s:9:\"daysprune\";i:-1;s:12:\"newpostemail\";s:0:\"\";s:14:\"newthreademail\";s:0:\"\";s:8:\"parentid\";i:-1;s:10:\"parentlist\";s:6:\"798,-1\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\";s:9:\"childlist\";s:6:\"798,-1\";s:16:\"defaultsortfield\";s:8:\"lastpost\";s:16:\"defaultsortorder\";s:4:\"desc\";s:11:\"imageprefix\";s:0:\"\";s:6:\"banner\";s:0:\"\";s:10:\"bannerlink\";s:0:\"\";s:9:\"banneralt\";s:0:\"\";s:10:\"bannercode\";s:0:\"\";s:12:\"bannerthread\";i:0;s:23:\"vbseo_moderatepingbacks\";i:1;s:24:\"vbseo_moderatetrackbacks\";i:1;s:22:\"vbseo_moderaterefbacks\";i:1;s:10:\"hhroptions\";i:415;s:12:\"iconlocation\";s:0:\"\";s:7:\"podcast\";i:0;s:5:\"depth\";i:0;s:11:\"permissions\";a:14:{i:12;i:16777215;i:6;i:16777215;i:8;i:0;i:13;i:12451831;i:7;i:12582143;i:5;i:16777215;i:1;i:655363;i:3;i:655363;i:4;i:655367;i:15;i:12316919;i:17;i:12316919;i:16;i:12316919;i:14;i:12308727;i:2;i:12308727;}}i:800;a:34:{s:7:\"forumid\";i:800;s:7:\"styleid\";i:0;s:5:\"title\";s:8:\"FTA Spot\";s:11:\"title_clean\";s:8:\"FTA Spot\";s:11:\"description\";s:0:\"\";s:17:\"description_clean\";s:0:\"\";s:7:\"options\";i:97985;s:11:\"showprivate\";i:0;s:12:\"displayorder\";i:3;s:10:\"lastpostid\";i:0;s:9:\"daysprune\";i:-1;s:12:\"newpostemail\";s:0:\"\";s:14:\"newthreademail\";s:0:\"\";s:8:\"parentid\";i:-1;s:10:\"parentlist\";s:6:\"800,-1\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\";s:9:\"childlist\";s:1298:\"800,137,809,810,813,814,815,816,817,868,818,336,138,340,746,806,459,483,745,164,341,342,343,747,807,458,482,748,344,345,346,347,749,808,457,481,750,348,349,350,351,751,460,352,354,412,411,410,355,407,408,409,413,188,880,881,882,883,653,654,655,656,136,845,145,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,141,545,546,547,548,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,549,550,551,552,149,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,755,153,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,176,613,614,615,616,617,618,619,620,621,622,623,624,326,398,397,396,192,659,660,661,662,657,658,663,664,665,666,667,668,669,670,671,672,180,718,719,720,721,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,819,820,821,822,722,864,865,866,867,184,641,642,643,644,645,646,647,648,649,650,651,652,196,673,674,675,676,677,678,679,680,200,681,682,683,684,685,686,687,688,689,690,691,692,693,694,695,696,204,703,704,416,705,706,707,417,708,709,710,418,711,712,713,415,714,715,716,414,717,723,724,725,697,698,699,700,701,830,831,832,833,208,702,211,210,209,470,229,230,228,844,431,231,232,769,825,213,225,395,224,827,828,829,770,771,776,772,474,275,276,824,826,-1\";s:16:\"defaultsortfield\";s:8:\"lastpost\";s:16:\"defaultsortorder\";s:4:\"desc\";s:11:\"imageprefix\";s:0:\"\";s:6:\"banner\";s:0:\"\";s:10:\"bannerlink\";s:0:\"\";s:9:\"banneralt\";s:0:\"\";s:10:\"bannercode\";s:0:\"\";s:12:\"bannerthread\";i:0;s:23:\"vbseo_moderatepingbacks\";i:1;s:24:\"vbseo_moderatetrackbacks\";i:1;s:22:\"vbseo_moderaterefbacks\";i:1;s:10:\"hhroptions\";i:479;s:12:\"iconlocation\";s:0:\"\";s:7:\"podcast\";i:0;s:5:\"depth\";i:0;s:11:\"permissions\";a:14:{i:12;i:16777215;i:6;i:16777215;i:8;i:0;i:13;i:12451831;i:7;i:12582143;i:5;i:16777215;i:1;i:655363;i:3;i:655363;i:4;i:655367;i:15;i:12316919;i:17;i:12316919;i:16;i:12316919;i:14;i:12308727;i:2;i:12308727;}}i:137;a:34:{s:7:\"forumid\";i:137;s:7:\"styleid\";i:0;s:5:\"title\";s:53:\"Sonicview - Akai Japan 800+ Channels BEV &amp; DN UP!\";s:11:\"title_clean\";s:53:\"Sonicview - Akai Japan 800+ Channels BEV &amp; DN UP!\";s:11:\"description\";s:0:\"\";s:17:\"description_clean\";s:0:\"\";s:7:\"options\";i:97989;s:11:\"showprivate\";i:0;s:12:\"displayorder\";i:1;s:10:\"lastpostid\";i:0;s:9:\"daysprune\";i:-1;s:12:\"newpostemail\";s:0:\"\";s:14:\"newthreademail\";s:0:\"\";s:8:\"parentid\";i:800;s:10:\"parentlist\";s:10:\"137,800,-1\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\";s:9:\"childlist\";s:210:\"137,809,810,813,814,815,816,817,868,818,336,138,340,746,806,459,483,745,164,341,342,343,747,807,458,482,748,344,345,346,347,749,808,457,481,750,348,349,350,351,751,460,352,354,412,411,410,355,407,408,409,413,-1\";s:16:\"defaultsortfield\";s:8:\"lastpost\";s:16:\"defaultsortorder\";s:4:\"desc\";s:11:\"imageprefix\";s:0:\"\";s:6:\"banner\";s:0:\"\";s:10:\"bannerlink\";s:0:\"\";s:9:\"banneralt\";s:0:\"\";s:10:\"bannercode\";s:0:\"\";s:12:\"bannerthread\";i:1;s:23:\"vbseo_moderatepingbacks\";i:1;s:24:\"vbseo_moderatetrackbacks\";i:1;s:22:\"vbseo_moderaterefbacks\";i:1;s:10:\"hhroptions\";i:479;s:12:\"iconlocation\";s:0:\"\";s:7:\"podcast\";i:0;s:5:\"depth\";i:1;s:11:\"permissions\";a:14:{i:12;i:16777215;i:6;i:16777215;i:8;i:0;i:13;i:12451831;i:7;i:12582143;i:5;i:16777215;i:1;i:655363;i:3;i:655363;i:4;i:655367;i:15;i:12316919;i:17;i:12316919;i:16;i:12316919;i:14;i:12308727;i:2;i:12308727;}}i:809;a:34:{s:7:\"forumid\";i:809;s:7:\"styleid\";i:0;s:5:\"title\";s:31:\"SVLan/WizHub - Akai Japan Group\";s:11:\"title_clean\";s:31:\"SVLan/WizHub - Akai Japan Group\";s:11:\"description\";s:0:\"\";s:17:\"description_clean\";s:0:\"\";s:7:\"options\";i:97989;s:11:\"showprivate\";i:0;s:12:\"displayorder\";i:1;s:10:\"lastpostid\";i:0;s:9:\"daysprune\";i:-1;s:12:\"newpostemail\";s:0:\"\";s:14:\"newthreademail\";s:0:\"\";s:8:\"parentid\";i:137;s:10:\"parentlist\";s:14:\"809,137,800,-1\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\";s:9:\"childlist\";s:38:\"809,810,813,814,815,816,817,868,818,-1\";s:16:\"defaultsortfield\";s:8:\"lastpost\";s:16:\"defaultsortorder\";s:4:\"desc\";s:11:\"imageprefix\";s:0:\"\";s:6:\"banner\";s:0:\"\";s:10:\"bannerlink\";s:0:\"\";s:9:\"banneralt\";s:0:\"\";s:10:\"bannercode\";s:0:\"\";s:12:\"bannerthread\";i:1;s:23:\"vbseo_moderatepingbacks\";i:1;s:24:\"vbseo_moderatetrackbacks\";i:1;s:22:\"vbseo_moderaterefbacks\";i:1;s:10:\"hhroptions\";i:479;s:12:\"iconlocation\";s:0:\"\";s:7:\"podcast\";i:0;s:5:\"depth\";i:2;s:11:\"permissions\";a:14:{i:12;i:16777215;i:6;i:16777215;i:8;i:0;i:13;i:12451831;i:7;i:12582143;i:5;i:16777215;i:1;i:655363;i:3;i:655363;i:4;i:655367;i:15;i:12316919;i:17;i:12316919;i:16;i:12316919;i:14;i:12308727;i:2;i:12308727;}}i:810;a:34:{s:7:\"forumid\";i:810;s:7:\"styleid\";i:0;s:5:\"title\";s:23:\"SVLan/WizHub Discussion\";s:11:\"title_clean\";s:23:\"SVLan/WizHub Discussion\";s:11:\"description\";s:0:\"\";s:17:\"description_clean\";s:0:\"\";s:7:\"options\";i:97991;s:11:\"showprivate\";i:0;s:12:\"displayorder\";i:1;s:10:\"lastpostid\";i:25960;s:9:\"daysprune\";i:-1;s:12:\"newpostemail\";s:0:\"\";s:14:\"newthreademail\";s:0:\"\";s:8:\"parentid\";i:809;s:10:\"parentlist\";s:18:\"810,809,137,800,-1\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\";s:9:\"childlist\";s:6:\"810,-1\";s:16:\"defaultsortfield\";s:8:\"lastpost\";s:16:\"defaultsortorder\";s:4:\"desc\";s:11:\"imageprefix\";s:0:\"\";s:6:\"banner\";s:0:\"\";s:10:\"bannerlink\";s:0:\"\";s:9:\"banneralt\";s:0:\"\";s:10:\"bannercode\";s:0:\"\";s:12:\"bannerthread\";i:1;s:23:\"vbseo_moderatepingbacks\";i:1;s:24:\"vbseo_moderatetrackbacks\";i:1;s:22:\"vbseo_moderaterefbacks\";i:1;s:10:\"hhroptions\";i:415;s:12:\"iconlocation\";s:0:\"\";s:7:\"podcast\";i:0;s:5:\"depth\";i:3;s:11:\"permissions\";a:14:{i:12;i:16777215;i:6;i:16777215;i:8;i:0;i:13;i:12451831;i:7;i:12582143;i:5;i:16777215;i:1;i:655363;i:3;i:655363;i:4;i:655367;i:15;i:12316919;i:17;i:12316919;i:16;i:12316919;i:14;i:12308727;i:2;i:12308727;}}i:813;a:34:{s:7:\"forumid\";i:813;s:7:\"styleid\";i:0;s:5:\"title\";s:73:\"<font color=\"#DA0203\" size=\"2\"><strong>SVLan/WizHub Files</strong></font>\";s:11:\"title_clean\";s:18:\"SVLan/WizHub Files\";s:11:\"description\";s:64:\"Files and Downloads only! Do not post questions in this section.\";s:17:\"description_clean\";s:64:\"Files and Downloads only! Do not post questions in this section.\";s:7:\"options\";i:97989;s:11:\"showprivate\";i:0;s:12:\"displayorder\";i:2;s:10:\"lastpostid\";i:0;s:9:\"daysprune\";i:-1;s:12:\"newpostemail\";s:0:\"\";s:14:\"newthreademail\";s:0:\"\";s:8:\"parentid\";i:809;s:10:\"parentlist\";s:18:\"813,809,137,800,-1\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\";s:9:\"childlist\";s:30:\"813,814,815,816,817,868,818,-1\";s:16:\"defaultsortfield\";s:8:\"lastpost\";s:16:\"defaultsortorder\";s:4:\"desc\";s:11:\"imageprefix\";s:0:\"\";s:6:\"banner\";s:0:\"\";s:10:\"bannerlink\";s:0:\"\";s:9:\"banneralt\";s:0:\"\";s:10:\"bannercode\";s:0:\"\";s:12:\"bannerthread\";i:1;s:23:\"vbseo_moderatepingbacks\";i:1;s:24:\"vbseo_moderatetrackbacks\";i:1;s:22:\"vbseo_moderaterefbacks\";i:1;s:10:\"hhroptions\";i:415;s:12:\"iconlocation\";s:0:\"\";s:7:\"podcast\";i:0;s:5:\"depth\";i:3;s:11:\"permissions\";a:14:{i:12;i:16777215;i:6;i:16777215;i:8;i:0;i:13;i:12451831;i:7;i:12582143;i:5;i:16777215;i:1;i:655363;i:3;i:655363;i:4;i:655367;i:15;i:12316919;i:17;i:12316919;i:16;i:12316919;i:14;i:12308727;i:2;i:12308727;}}i:814;a:34:{s:7:\"forumid\";i:814;s:7:\"styleid\";i:0;s:5:\"title\";s:30:\"iHub/Newlink upgrade to SV Lan\";s:11:\"title_clean\";s:30:\"iHub/Newlink upgrade to SV Lan\";s:11:\"description\";s:41:\"Convert your iHub or NewLink to a SV Lan.\";s:17:\"description_clean\";s:41:\"Convert your iHub or NewLink to a SV Lan.\";s:7:\"options\";i:97991;s:11:\"showprivate\";i:0;s:12:\"displayorder\";i:1;s:10:\"lastpostid\";i:13810;s:9:\"daysprune\";i:-1;s:12:\"newpostemail\";s:0:\"\";s:14:\"newthreademail\";s:0:\"\";s:8:\"parentid\";i:813;s:10:\"parentlist\";s:22:\"814,813,809,137,800,-1\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\";s:9:\"childlist\";s:6:\"814,-1\";s:16:\"defaultsortfield\";s:8:\"lastpost\";s:16:\"defaultsortorder\";s:4:\"desc\";s:11:\"imageprefix\";s:0:\"\";s:6:\"banner\";s:0:\"\";s:10:\"bannerlink\";s:0:\"\";s:9:\"banneralt\";s:0:\"\";s:10:\"bannercode\";s:0:\"\";s:12:\"bannerthread\";i:0;s:23:\"vbseo_moderatepingbacks\";i:1;s:24:\"vbseo_moderatetrackbacks\";i:1;s:22:\"vbseo_moderaterefbacks\";i:1;s:10:\"hhroptions\";i:479;s:12:\"iconlocation\";s:0:\"\";s:7:\"podcast\";i:0;s:5:\"depth\";i:4;s:11:\"permissions\";a:14:{i:12;i:16777215;i:6;i:16777215;i:8;i:0;i:13;i:12451831;i:7;i:12582143;i:5;i:16777215;i:1;i:655363;i:3;i:655363;i:4;i:655367;i:15;i:12316919;i:17;i:12316919;i:16;i:12316919;i:14;i:12308727;i:2;i:12308727;}}i:815;a:34:{s:7:\"forumid\";i:815;s:7:\"styleid\";i:0;s:5:\"title\";s:34:\"SVLan/WizHub - SV360 Premier Files\";s:11:\"title_clean\";s:34:\"SVLan/WizHub - SV360 Premier Files\";s:11:\"description\";s:76:\"SV 360 Premier Receiver bin files used with the SVLan/WizHub serial adaptor.\";s:17:\"description_clean\";s:76:\"SV 360 Premier Receiver bin files used with the SVLan/WizHub serial adaptor.\";s:7:\"options\";i:97991;s:11:\"showprivate\";i:0;s:12:\"displayorder\";i:3;s:10:\"lastpostid\";i:19876;s:9:\"daysprune\";i:-1;s:12:\"newpostemail\";s:0:\"\";s:14:\"newthreademail\";s:0:\"\";s:8:\"parentid\";i:813;s:10:\"parentlist\";s:22:\"815,813,809,137,800,-1\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\";s:9:\"childlist\";s:6:\"815,-1\";s:16:\"defaultsortfield\";s:8:\"lastpost\";s:16:\"defaultsortorder\";s:4:\"desc\";s:11:\"imageprefix\";s:0:\"\";s:6:\"banner\";s:0:\"\";s:10:\"bannerlink\";s:0:\"\";s:9:\"banneralt\";s:0:\"\";s:10:\"bannercode\";s:0:\"\";s:12:\"bannerthread\";i:0;s:23:\"vbseo_moderatepingbacks\";i:1;s:24:\"vbseo_moderatetrackbacks\";i:1;s:22:\"vbseo_moderaterefbacks\";i:1;s:10:\"hhroptions\";i:479;s:12:\"iconlocation\";s:0:\"\";s:7:\"podcast\";i:0;s:5:\"depth\";i:4;s:11:\"permissions\";a:14:{i:12;i:16777215;i:6;i:16777215;i:8;i:0;i:13;i:12451831;i:7;i:12582143;i:5;i:16777215;i:1;i:655363;i:3;i:655363;i:4;i:655367;i:15;i:12316919;i:17;i:12316919;i:16;i:12316919;i:14;i:12308727;i:2;i:12308727;}}i:816;a:34:{s:7:\"forumid\";i:816;s:7:\"styleid\";i:0;s:5:\"title\";s:32:\"SVLan/WizHub - SV360 Elite Files\";s:11:\"title_clean\";s:32:\"SVLan/WizHub - SV360 Elite Files\";s:11:\"description\";s:74:\"SV 360 Elite Receiver bin files used with the SVLan/WizHub serial adaptor.\";s:17:\"description_clean\";s:74:\"SV 360 Elite Receiver bin files used with the SVLan/WizHub serial adaptor.\";s:7:\"options\";i:97991;s:11:\"showprivate\";i:0;s:12:\"displayorder\";i:4;s:10:\"lastpostid\";i:19878;s:9:\"daysprune\";i:-1;s:12:\"newpostemail\";s:0:\"\";s:14:\"newthreademail\";s:0:\"\";s:8:\"parentid\";i:813;s:10:\"parentlist\";s:22:\"816,813,809,137,800,-1\";s:8:\"password\";s:0:\"\";s:4:\"link\";s:0:\"\";s:9:\"childlist\";s:6:\"816,-1\";s:16:\"defaultsortfield\";s:8:\"lastpost\";s:16:\"defaultsortorder\";s:4:\"desc\";s:11:\"imageprefix\";s:0:\"\";s:6:\"banner\";s:0:\"\";s:10:\"bannerlink\";s:0:\"\";s:9:\"banneralt\";s:0:\"\";s:10:\"bannercode\";s:0:\"\";s:12:\"bannerthread\";i:0;s:23:\"vbseo_moderatepingbacks\";i:1;s:24:\"vbseo_moderatetrackbacks\";i:1;s:22:\"vbseo_moderaterefbacks\";i:1;s:10:\"hhroptions\";i:479;s:12:\"iconlocation\";s:0:\"\";s:7:\"podcast\";i:0;s:5:\"depth\";i:4;s:11:\"permissions\";a:14:

MySQL Error   : Got a packet bigger than 'max_allowed_packet' bytes
Error Number  : 1153
Request Date  : Sunday, May 29th 2011 @ 04:00:40 PM
Error Date    : Sunday, May 29th 2011 @ 04:00:53 PM
Script        : http://www.mydomain.com/forums/@ccess_admin_cp@/forum.php?do=update
Referrer      : http://www.mydomain.com/forums/@ccess_admin_cp@/forum.php?do=edit&f=906&s=
IP Address    : 87.200.169.118
Username      : FReeSTER
Classname     : vB_Database
MySQL Version : 5.0.92-community

Any ideas how to fix this? I was thinking deleting the datastore table but Im trying to make sure before screw up more.

--------------- Added [DATE]1306685780[/DATE] at [TIME]1306685780[/TIME] ---------------

the error just keep going very long so I shorten it by 90,000 characters

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05974 seconds Memory Usage 2,521KB Queries Executed 12 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_code (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (7)post_thanks_box (7)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (7)post_thanks_postbit_info (7)postbit (7)postbit_onlinestatus (7)postbit_wrapper (1)showthread_list (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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_threadedmode.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids_threaded showthread_threaded_construct_link showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory 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 tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!