PDA

View Full Version : Solved db errors



tsak76
07-05-11, 15:10
Database error in vBulletin 3.8.2:

Invalid SQL:

UPDATE vbsession
SET lastactivity = 1304777118, location = '/forums/showthread.php?t=36391', inforum = 131, inthread = 36391, incalendar = 0, badlocation = 0
WHERE sessionhash = '388d9ba3f7f2ce204e81624e25d24b1a';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Saturday, May 7th 2011 @ 10:05:18 AM
Error Date : Saturday, May 7th 2011 @ 10:06:49 AM
Script : http://www.site.com/forums/36391-%CF%83%CE%B5%CE%B2%CE%B1%CF%83%CE%BC%CF%8C%CF%82-%CE%B9%CF%83%CF%8C%CF%84%CE%B7%CF%84%CE%B1-%CF%83%CF%8D%CE%B3%CF%87%CF%81%CE%BF%CE%BD%CE%BF-bdsm.html
Referrer : http://www.site.com/forums/es/

i am getting many of these .. wait timeout is 90 sec

kamilkurczak
09-05-11, 08:32
hello,
maybe set wait timeout to the higher value.
http://www.vbenterprisetranslator.com/forum/vbet4-troubleshooting/413-faq-2.html#post3105

secondly, ther is a vB database table, so please wrint about this request on vBulletin support forum too.

tsak76
09-05-11, 13:16
it only happenes when vbet plugin is on

vBET
09-05-11, 21:47
Hello :) Kamil already gave you solution in FAQ link. Please go there and fallow the instructions. Please note that it is only your database configuration issue. This is not any bug (nor vBulletin nor vBET - sorry Kamil didn't make it clear).

On your server it happens only when vBET is on, because only then translations happens. If translation is not yet cached then it goes to Google. Google gives you results in long time (that is why we are caching it – to get it fast next time) and it appears that often whole request execution time is longer that your database connection time. So this is easy configuration issue which only requires to change your database connection time to longer. Please fallow instructions in FAQ for more details :)

If you need some more information please just write :)

AfrikaansAlbanianArabicBelarusianBulgarianCatalanChineseCroatianCzechDanishDutchEnglishEstonianFilipinoFinnishFrenchGalicianGermanGreekHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKoreanLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishTaiwaneseThaiTurkishUkrainianVietnameseWelshYiddish
Multilingual forum supported by vBET Translator 4.10.1