vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   error (https://vborg.vbsupport.ru/showthread.php?t=216816)

Stormraven 06-22-2009 04:21 PM
error
 
Hello there. I keep getting an error when editing a certain post. It's this post:

http://www.codershangout.co.uk/marke...ink-backs.html

This is the error I'm getting:

Code:
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 - DMOZ \r\n\r\nPR 7 Websites / Blogs / Forums\r\n\r\nPR 6 Websites / Blogs / Forums\r\n\r\nRanda Clay Design (Post to get a linkback)[Blog]\r\n\r\nRock, Paper, Shotgun: The Force is The Method - PR6\r\n\r\nWonderland - PR6\r\n\r\nJay is Games - Flash and Casual Game reviews, walkthroughs, room escape games, point and click games, puzzle games and more! - PR6\r\n\r\n------------------------------------------------\r\n\r\nPR 5 Websites / Blogs / Forums\r\n------------------------------------------------\r\n\r\nBritishGaming | BritishGaming.co.uk - PR5\r\n\r\nFlashgamer - 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 - Remarkablogger (Post to get linkback)[Blog]\r\n\r\nAffordable Internet Marketing[Blog]\r\n\r\nKeen and Graev?s Gaming Blog - PR4\r\n\r\nGamersGame.com: Your Online Game Blog and Gaming Resource - PR4\r\n\r\nEvo?s PC Gaming Blog - PR4\r\n\r\nMordiceius' Gaming Blog - PR4\r\n\r\nAddicting Games, Flash Games, Free Games, Free Online Games - PR4\r\n\r\n------------------------------------------------\r\n\r\n\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! - PR3\r\n\r\nVideo Gaming Blog - PR3\r\n\r\n Game Addicts - PR3\r\n\r\nFlash games Blog - PR3\r\n\r\nDoogog.com - Casual Games for the Hardcore - 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/editp...atepost&p=8432
Referrer      : http://www.codershangout.co.uk/editp...ditpost&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 06-22-2009 04:47 PM
This is a server issue. See this: http://www.vbulletin.com/docs/html/t...mysql_goneaway and this: http://www.vbulletin.com/forum/showt...265#post310265

Stormraven 06-22-2009 04:54 PM
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 06-22-2009 05:20 PM
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 06-23-2009 10:53 AM
I contacted my host and they said this:

Quote:
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 06-23-2009 02:09 PM
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 06-23-2009 02:21 PM
Hmmmm, I have edited two template pages recently, called postbit_legacy and forumdisplay. Could this be something to do with the error? :-/

Lynne 06-23-2009 02:45 PM
It's doubtful that editing a couple of templates is going to cause a MySQL Server has gone away error.


All times are GMT. The time now is 04:07 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01061 seconds
  • Memory Usage 1,741KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete