Database Error while making or editing new forums

[FReeSTER]

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

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

[Lynne]

That is a server issue. You need to contact your hosting provider and request them to increase the value for your mysql setting: max_allowed_packet

You can see more about the error in the manual here - http://www.vbulletin.com/docs/html/t...t_mysql_errors

[FReeSTER]

Thank you Lynne sure it helped me a lot. problem fixed. :-)

[FReeSTER]

Lynne can you please help me do this by myself? the hosting dont or cant give me support because I have dedicated hosting

[Lynne]

I'm not sure what you mean about your hosting, but it's not anything I can do for you. You will need to edit the my.cnf file and then restart mysql.

[FReeSTER]

Originally Posted by Lynne

I'm not sure what you mean about your hosting, but it's not anything I can do for you. You will need to edit the my.cnf file and then restart mysql.

I asked my hosting to do this for me and they replied back to me saying they charge $50 euros per 15 mins. That Im the one responsible for doing any changes to server.

I been searching everywhere on google where to find that file and I cant see a good answer that tells me how to do that or even stop the mysql and restart it back on

[Lynne]

Why did you get unmanaged hosting if you have no idea how to do anything on your server? I would strongly suggest spending some time googling the OS your server is running and practicing some simple commands on your server to get to 'know' it. You should at least know how to restart the various services (apache, mysql) and restart your server. And, of course, how to backup and reimport your database. The commands to do this are different depending on what OS you are running. Who installed the mysql/php/apache on your server? If it was your host, then they should at least tell you were the configuration files are for those applications and I don't understand why they can't tell you how to restart those services. However, once you find out the OS, you should be able to google to figure that out.