error

[Stormraven]

Hello there. I keep getting an error when editing a certain post. It's this post:

http://www.codershangout.co.uk/marketing-and-site-promotion/1051-high-pr-link-backs.html

This is the error I'm getting:

Database error in vBulletin 3.8.3:

Invalid SQL:
UPDATE post SET
showsignature = 1,
allowsmilie = 1,
title = 'High PR Link backs.',
pagetext = 'Ok, so we all want them? Yes we do! Lets work as a community to find websites (when we come across them) not just go searching... But when someone comes across the website where you could receive a linkback, post the link here and we will make a list soirted by PR. Thanks! :D\r\n\r\nPR 10 Websites / Blogs / Forums\r\n------------------------------------------------\r\n\r\n\r\n None Yet\r\n\r\n\r\n------------------------------------------------\r\n\r\nPR 9 Websites / Blogs / Forums\r\n------------------------------------------------\r\n\r\n\r\n None Yet\r\n\r\n\r\n------------------------------------------------\r\n\r\nPR 8 Websites / Blogs / Forums\r\n------------------------------------------------\r\n\r\nODP - Open Directory Project (http://www.dmoz.org/) - DMOZ \r\n\r\nPR 7 Websites / Blogs / Forums\r\n\r\nPR 6 Websites / Blogs / Forums\r\n\r\nRanda Clay Design (http://randaclay.com/) (Post to get a linkback)\r\n\r\nRock, Paper, Shotgun: The Force is The Method (http://www.rockpapershotgun.com/) - PR6\r\n\r\nWonderland (http://www.wonderlandblog.com/) - PR6\r\n\r\nJay is Games - Flash and Casual Game reviews, walkthroughs, room escape games, point and click games, puzzle games and more! (http://jayisgames.com/) - PR6\r\n\r\n------------------------------------------------\r\n\r\n[B]PR 5 Websites / Blogs / Forums\r\n------------------------------------------------\r\n\r\nBritishGaming | BritishGaming.co.uk (http://www.britishgaming.co.uk/) - PR5\r\n\r\nFlashgamer (http://www.flashgamer.com/) - PR5\r\n\r\n------------------------------------------------\r\n\r\n\r\nPR 4 Websites / Blogs / Forums\r\n------------------------------------------------\r\n\r\nRemarkablogger ? Remarkable Blog Consulting and Coaching (http://michaelmartine.com/) - Remarkablogger (Post to get linkback)\r\n\r\nAffordable Internet Marketing (\"http://www.affordable-internet-marketing.com/\")[Blog]\r\n\r\nKeen and Graev?s Gaming Blog (http://www.keenandgraev.com/) - PR4\r\n\r\nGamersGame.com: Your Online Game Blog and Gaming Resource (http://www.gamersgame.com/) - PR4\r\n\r\nEvo?s PC Gaming Blog (http://evo-gamer.com/) - PR4\r\n\r\nMordiceius' Gaming Blog (http://mordiceius.com/) - PR4\r\n\r\nAddicting Games, Flash Games, Free Games, Free Online Games (http://funflashgames.com/) - PR4\r\n\r\n------------------------------------------------\r\n\r\n[B]\r\nPR 3 Websites / Blogs / Forums\r\n------------------------------------------------\r\n\r\nGeekTown - Dave Elliott & Daryl Williams Blog, PC Gaming, Warhammer Online, LotRO, Sci-fi, Gagdets, Movies, and other Geeky Stuff! (http://www.geektown.co.uk/) - PR3\r\n\r\nVideo Gaming Blog (http://www.videogamingblog.net/) - PR3\r\n\r\n Game Addicts (http://www.game-addicts.com/) - PR3\r\n\r\nFlash games Blog (http://www.fncgamesblog.com/) - PR3\r\n\r\nDoogog.com - Casual Games for the Hardcore (http://doogog.com/) - PR3\r\n\r\n------------------------------------------------',
iconid = 0,
attach = 0
WHERE postid = 8432;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, June 22nd 2009 @ 02:20:01 PM
Error Date : Monday, June 22nd 2009 @ 02:20:20 PM
Script : http://www.codershangout.co.uk/editpost.php?do=updatepost&p=8432
Referrer : http://www.codershangout.co.uk/editpost.php?do=editpost&p=8432
IP Address : ## IP REMOVED ##
Username : ElseAndrew
Classname : vB_Database
MySQL Version :


I have tried removing plugin's but no such luck. Can someone help me out please?

[Lynne]

This is a server issue. See this: http://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway and this: http://www.vbulletin.com/forum/showthread.php?s=&postid=310265#post310265

[Stormraven]

Should I contact my host about this? I have noticed that my host has reset the mysql server or apache or something over the last couple of days, could this be the reason why? Thankyou Lynne.

Kind Regards
Stormraven.

[Lynne]

If he restarted mysql, then you would get errors like that during the restart. You should contact your host if you are getting a lot of these errors.

[Stormraven]

I contacted my host and they said this:

Hello,

MySQL is indeed working fine on the server. I have looked at your error and could this be an issue-:

----------------------------------',
iconid = 0,
attach = 0
WHERE postid = 8432;

Should there be a semicolon behind the 'attach'?

If you need any more help, please let me know.

Regards,

Justin

Could that be the problem? I'd like confirmation before I do anything, I don't understand why the error is just with one thread :-/

[Lynne]

No, there should not be a semi-colon after attach. However, I cannot find a query like that at all in the default vb files. You may want to find that query and disable that modification and perhaps you wont' get those errors anymore. Very often, when I see that error on my site, it's a timeout things. However, if you are on shared hosting, I would guess they won't be willing to up that value.

[Stormraven]

Hmmmm, I have edited two template pages recently, called postbit_legacy and forumdisplay. Could this be something to do with the error? :-/

[Lynne]

It's doubtful that editing a couple of templates is going to cause a MySQL Server has gone away error.