PDA

Visa fullständig version: Löste Ta emot SQL-error från vBulletin refererar vBET



brubros
02-10-11, 18:23
Jag får följande fel (jag är bara kopierar ett exempel här) mailade till mig hela dagen från vBulletin referera vBET. Detta fel började först efter den senaste uppgraderingen till vBET:


Database error in vBulletin 4.0.7:

Invalid SQL:
SELECT translated FROM vbenterprisetranslator_cache_ WHERE originaltext='bubbles+deluxe+%26%231056%3B%26%231108%3B%26%231057%3B%26%231026%3B%26%231057%3B%26%231039%3B%26%231056%3B%26%231108%3B+%26%231056%3B%26%231169%3B%26%231057%3B%26%231026%3B%26%231056%3B%C2%B0%26%231056%3B%26%238470%3B%26%231056%3B%26%231030%3B%26%231056%3B%C2%B5%26%231057%3B%26%231026%3B%26%231056%3B%C2%B0+%26%231056%3B%26%231169%3B%26%231056%3B%C2%BB%26%231057%3B%26%231039%3B+nvidia+geforce+7900+gs++%0D%0A%5Burl%3Dhttp%3A%2F%2Fmts666.narod****%2F272748.html%5D%26%231072%3B%26%231089%3B%26%231100%3B%26%231082%3B%26%231072%3B+%26%231076%3B%26%231083%3B%26%231103%3B+*****+2700%5B%2Furl%5D++%0D%0A%26%231056%3B%26%231169%3B%26%231057%3B%26%231026%3B%26%231056%3B%C2%B0%26%231056%3B%26%238470%3B%26%231056%3B%26%231030%3B%26%231056%3B%C2%B5%26%231057%3B%26%231026%3B%26%231056%3B%C2%B0+%26%231057%3B%26%231107%3B%26%231057%3B%26%231027%3B%26%231057%3B%26%238218%3B%26%231057%3B%26%231026%3B%26%231056%3B%26%231109%3B%26%231056%3B%26%238470%3B%26%231057%3B%26%231027%3B%26%231057%3B%26%238218%3B%26%231056%3B%26%231030%3B+%26%231056%3B%26%231169%3B%26%231056%3B%C2%BB%26%231057%3B%26%231039%3B+****+k40in+%26%231057%3B%26%231027%3B%26%231056%3B%26%231108%3B%26%231056%3B%C2%B0%26%231057%3B%26%238225%3B%26%231056%3B%C2%B0%26%231057%3B%26%238218%3B%26%231057%3B%26%231034%3B+%26%231057%3B%26%231026%3B%26%231056%3B%C2%B5%26%231057%3B%26%238222%3B%26%231056%3B%C2%B5%26%231057%3B%26%231026%3B%26%231056%3B%C2%B0%26%231057%3B%26%238218%3B+%2B+%26%231056%3B%26%231111%3B%26%231056%3B%26%231109%3B+%26%231056%3B%26%231111%3B%26%231057%3B%26%231026%3B%26%231056%3B%26%231109%3B%26%231056%3B%26%231110%3B%26%231057%3B%26%231026%3B%26%231056%3B%C2%B0%26%231056%3B%26%231112%3B%26%231056%3B%26%231112%3B%26%231056%3B%26%231029%3B%26%231056%3B%26%231109%3B%26%231056%3B%26%231112%3B%26%231057%3B%26%231107%3B+%26%231056%3B%26%231109%3B%26%231056%3B%C2%B1%26%231056%3B%C2%B5%26%231057%3B%26%231027%3B%26%231056%3B%26%231111%3B%26%231056%3B%C2%B5%26%231057%3B%26%238225%3B%26%231056%3B%C2%B5%26%231056%3B%26%231029%3B%26%231056%3B%26%231105%3B%26%231057%3B%26%231035%3B++%0D%0A%5Burl%3Dhttp%3A%2F%2Fsmasja.narod****%2F989709.html%5D%26%231085%3B%26%231086%3B%26%231074%3B%26%231099%3B%26%231081%3B+jimm+%26%231089%3B%26%231082%3B%26%231072%3B%26%231095%3B%26%231072%3B%26%231090%3B%26%231100%3B%5B%2Furl%5D++%0D%0A%26%231057%3B%26%231027%3B%26%231056%3B%26%231108%3B%26%231056%3B%C2%B0%26%231057%3B%26%238225%3B%26%231056%3B%C2%B0%26%231057%3B%26%238218%3B%26%231057%3B%26%231034%3B+%26%231057%3B%26%231026%3B%26%231056%3B%C2%B5%26%231057%3B%26%238222%3B%26%231056%3B%C2%B5%26%231057%3B%26%231026%3B%26%231056%3B%C2%B0%26%231057%3B%26%238218%3B+%26%231057%3B%26%238222%3B%26%231056%3B%26%231105%3B%26%231056%3B%26%231029%3B%26%231056%3B%C2%B0%26%231056%3B%26%231029%3B%26%231057%3B%26%231027%3B%26%231056%3B%26%231109%3B%26%231056%3B%26%231030%3B%26%231056%3B%C2%B0%26%231057%3B%26%231039%3B+%26%231056%3B%26%231111%3B%26%231056%3B%26%231109%3B%26%231056%3B%C2%BB%26%231056%3B%26%231105%3B%26%231057%3B%26%238218%3B%26%231056%3B%26%231105%3B%26%231056%3B%26%231108%3B%26%231056%3B%C2%B0+%26%231057%3B%26%238222%3B%26%231056%3B%26%231105%3B%26%231057%3B%26%231026%3B%26%231056%3B%26%231112%3B%26%231057%3B%26%238249%3B+%26%231057%3B%26%231027%3B%26%231056%3B%26%231108%3B%26%231056%3B%C2%B0%26%231057%3B%26%238225%3B%26%231056%3B%C2%B0%26%231057%3B%26%238218%3B%26%231057%3B%26%231034%3B+%26%231056%3B%26%231169%3B%26%231057%3B%26%231026%3B%26%231056%3B%C2%B0%26%231056%3B%26%238470%3B%26%231056%3B%26%231030%3B%26%231056%3B%C2%B5%26%231057%3B%26%231026%3B%26%231057%3B%26%238249%3B+%26%231056%3B%26%231169%3B%26%231056%3B%C2%BB%26%231057%3B%26%231039%3B+real+tek+ac97++%0D%0A%5Burl%3Dhttp%3A%2F%2Fmishailboon.narod****%2F513710.html%5Dgt+s3650+*******+%26%231072%3B%26%231089%3B%26%231100%3B%26%231082%3B%26%231072%3B+%26%231076%3B%26%231083%3B%26%231103%3B%5B%2Furl%5D++%0D%0A%26%231057%3B%26%231026%3B%26%231057%3B%26%231107%3B%26%231057%3B%26%231027%3B%26%231057%3B%26%231027%3B%26%231056%3B%26%231108%3B%26%231056%3B%26%231109%3B%26%231056%3B%26%231112%3B+%26%231057%3B%26%231027%3B+%26%231056%3B%26%231108%3B%26%231057%3B%26%231026%3B%26%231057%3B%26%231039%3B%26%231056%3B%26%231108%3B%26%231056%3B%26%231109%3B%26%231056%3B%26%231112%3B+%26%231057%3B%26%231027%3B%26%231056%3B%26%231108%3B%26%231056%3B%C2%B0%26%231057%3B%26%238225%3B%26%231056%3B%C2%B0%26%231057%3B%26%238218%3B%26%231057%3B%26%231034%3B+%26%231056%3B%26%231169%3B%26%231057%3B%26%231026%3B%26%231056%3B%C2%B0%26%231056%3B%26%238470%3B%26%231056%3B%26%231030%3B%26%231056%3B%C2%B5%26%231057%3B%26%231026%3B%26%231056%3B%C2%B0+%26%231056%3B%26%231169%3B%26%231056%3B%C2%BB%26%231057%3B%26%231039%3B+nvidia+8500gt++%0D%0A%5Burl%3Dhttp%3A%2F%2Fsidor-fedor.narod****%2F740779.html%5D%26%231089%3B%26%231082%3B%26%231072%3B%26%231095%3B%26%231072%3B%26%231090%3B%26%231100%3B+icq+%26%231076%3B%26%231083%3B%26%231103%3B+*****+6300+%26%231073%3B%26%231077%3B%26%231089%3B%26%231087%3B%26%231083%3B%26%231072%3B%26%231090%3B%26%231085%3B%26%231086%3B%5B%2Furl%5D++%0D%0A%26%231056%3B%C2%B1%26%231056%3B%C2%B5%26%231057%3B%26%231027%3B%26%231056%3B%26%231111%3B%26%231056%3B%C2%BB%26%231056%3B%C2%B0%26%231057%3B%26%238218%3B%26%231056%3B%26%231029%3B%26%231057%3B%26%238249%3B%26%231056%3B%C2%B5+%26%231056%3B%26%231112%3B%26%231056%3B%26%231105%3B%26%231056%3B%26%231029%3B%26%231057%3B%26%231107%3B%26%231057%3B%26%231027%3B%26%231056%3B%26%231109%3B%26%231056%3B%26%231030%3B%26%231056%3B%26%231108%3B%26%231056%3B%26%231105%3B+%26%231057%3B%26%238222%3B%26%231056%3B%C2%B0%26%231056%3B%C2%B1%26%231057%3B%26%231026%3B%26%231056%3B%26%231105%3B%26%231056%3B%26%231108%3B%26%231056%3B%26%231105%3B+realtek+%26%231056%3B%C2%B7%26%231056%3B%26%231030%3B%26%231057%3B%26%231107%3B%26%231056%3B%26%231108%3B%26%231056%3B%26%231109%3B%26%231056%3B%26%231030%3B%26%231056%3B%C2%B0%26%231057%3B%26%231039%3B+%26%231056%3B%26%231108%3B%26%231056%3B%C2%B0%26%231057%3B%26%231026%3B%26%231057%3B%26%238218%3B%26%231056%3B%C2%B0+%26%231056%3B%26%231169%3B%26%231057%3B%26%231026%3B%26%231056%3B%C2%B0%26%231056%3B%26%238470%3B%26%231056%3B%26%231030%3B%26%231056%3B%C2%B5%26%231057%3B%26%231026%3B+%26%231057%3B%26%231027%3B%26%231056%3B%26%231108%3B%26%231056%3B%C2%B0%26%231057%3B%26%238225%3B%26%231056%3B%C2%B0%26%231057%3B%26%238218%3B%26%231057%3B%26%231034%3B++%0D%0A%5Burl%3Dhttp%3A%2F%2Fmishailboon.narod****%2F513710.html%5Dgt+s3650+*******+%26%231072%3B%26%231089%3B%26%231100%3B%26%231082%3B%26%231072%3B+%26%231076%3B%26%231083%3B%26%231103%3B%5B%2Furl%5D++%0D%0Amicrosoft+wihdows+xp+%26%231056%3B%26%231169%3B%26%231057%3B%26%231026%3B%26%231056%3B%C2%B0%26%231056%3B%26%238470%3B%26%231056%3B%26%231030%3B%26%231056%3B%C2%B5%26%231057%3B%26%231026%3B+%26%231056%3B%26%231029%3B%26%231056%3B%C2%B0+%26%231056%3B%C2%B7%26%231056%3B%26%231030%3B%26%231057%3B%26%231107%3B%26%231056%3B%26%231108%3B+%26%231056%3B%C2%B7%26%231056%3B%C2%B0%26%231056%3B%26%231110%3B%26%231057%3B%26%231026%3B%26%231057%3B%26%231107%3B%26%231056%3B%C2%B7%26%231056%3B%26%231105%3B%26%231057%3B%26%238218%3B%26%231057%3B%26%231034%3B+%26%231056%3B%C2%B7%26%231056%3B%C2%B0%26%231056%3B%C2%BB%26%231056%3B%26%231105%3B%26%231056%3B%26%231030%3B%26%231056%3B%26%231029%3B%26%231056%3B%26%231109%3B%26%231056%3B%C2%B5+%26%231056%3B%26%231105%3B%26%231056%3B%C2%B7+%26%231057%3B%26%231039%3B%26%231056%3B%C2%B7%26%231057%3B%26%238249%3B%26%231056%3B%26%231108%3B%26%231056%3B%C2%B0+%26%231057%3B%26%231026%3B%26%231056%3B%C2%B5%26%231057%3B%26%238222%3B%26%231056%3B%C2%B5%26%231057%3B%26%231026%3B%26%231056%3B%C2%B0%26%231057%3B%26%238218%3B+%26%231057%3B%26%231027%3B%26%231056%3B%26%231108%3B%26%231056%3B%C2%B0%26%231057%3B%26%238225%3B%26%231056%3B%C2%B0%26%231057%3B%26%238218%3B%26%231057%3B%26%231034%3B++%0D%0A%5Burl%3Dhttp%3A%2F%2Fsidor-fedor.narod****%2F740779.html%5D%26%231089%3B%26%231082%3B%26%231072%3B%26%231095%3B%26%231072%3B%26%231090%3B%26%231100%3B+icq+%26%231076%3B%26%231083%3B%26%231103%3B+*****+6300+%26%231073%3B%26%231077%3B%26%231089%3B%26%231087%3B%26%231083%3B%26%231072%3B%26%231090%3B%26%231085%3B%26%231086%3B%5B%2Furl%5D++%0D%0A%26%231056%3B%26%231108%3B%26%231057%3B%26%231026%3B%26%231057%3B%26%231039%3B%26%231056%3B%26%231108%3B+%26%231056%3B%26%231169%3B%26%231056%3B%C2%BB%26%231057%3B%26%231039%3B+archicad+11+%26%231057%3B%26%231027%3B%26%231056%3B%26%231108%3B%26%231056%3B%C2%B0%26%231057%3B%26%238225%3B%26%231056%3B%C2%B0%26%231057%3B%26%238218%3B%26%231057%3B%26%231034%3B+%26%231056%3B%C2%B1%26%231056%3B%C2%B5%26%231057%3B%26%231027%3B%26%231056%3B%26%231111%3B%26%231056%3B%C2%BB%26%231056%3B%C2%B0%26%231057%3B%26%238218%3B%26%231056%3B%26%231029%3B%26%231056%3B%C2%B0%26%231057%3B%26%231039%3B+%26%231056%3B%26%231112%3B%26%231056%3B%26%231105%3B%26%231056%3B%26%231029%3B%26%231057%3B%26%231107%3B%26%231057%3B%26%231027%3B%26%231056%3B%26%231109%3B%26%231056%3B%26%231030%3B%26%231056%3B%26%231108%3B%26%231056%3B%C2%B0+%26%231056%3B%26%231110%3B%26%231057%3B%26%231026%3B%26%231056%3B%26%231109%3B%26%231057%3B%26%231027%3B%26%231057%3B%26%231027%3B%26%231057%3B%26%231107%3B+%26%231056%3B%26%231112%3B%26%231056%3B%C2%B0%26%231056%3B%26%231112%3B%26%231056%3B%C2%B0++%0D%0A%5Burl%3Dhttp%3A%2F%2Fvuvuzely.narod****%2F251905.html%5Dicq+%26%231076%3B%26%231083%3B%26%231103%3B+%26%231082%3B%26%231087%3B%26%231082%3B%5B%2Furl%5D++%0D%0A%26%231057%3B%26%231027%3B%26%231057%3B%26%238218%3B%26%231057%3B%26%231107%3B%26%231056%3B%26%231169%3B%26%231056%3B%26%231105%3B%26%231057%3B%26%231039%3B+%26%231057%3B%26%231036%3B%26%231057%3B%26%238222%3B%26%231057%3B%26%238222%3B%26%231056%3B%C2%B5%26%231056%3B%26%231108%3B%26%231057%3B%26%238218%3B%26%231056%3B%26%231109%3B%26%231056%3B%26%231030%3B+1' LIMIT 1;

MySQL Error : Table 'actup.vbenterprisetranslator_cache_' doesn't exist
Error Number : 1146
Request Date : Sunday, October 2nd 2011 @ 11:13:04 AM
Error Date : Sunday, October 2nd 2011 @ 11:13:04 AM

vBET
03-10-11, 14:15
Kan ni ge oss exakta webbadressen som orsakar detta fel? Problemet är att det inte finns någon språkkod med, men vi måste invesrtigate varför koden inte är förbi.

brubros
03-10-11, 14:48
Tyvärr fick jag inte helt fel meesage innan. Detta är vad det står på botten av fel:

MySQL-Fel : Table 'actup.vbenterprisetranslator_cache_' finns inte
Fel Nummer : 1146
Begäran Datum : måndag, 3 oktober 2011 @ 01:48:23 AM
Fel Datum : måndag, 3 oktober 2011 @ 01:48:24 AM
Manus : http://www.actup.org/forum/newreply.php?do=postreply&t=22081
Värvare : en NY tredje person smittsamma RETROVIRUS - vi ska hjälpa! Snälla****** För att svara på ämnet (http://www.actup.org/forum/ru/newreply.php?do=newreply&p=22596)
IP-Adress : 24.213.192.62
Användarnamn : SvetlanSehjs
Classname : vB_Database



Även översättningar fortfarande inte fungerar på vår webbplats sedan uppgraderingen. När en kolleger i Frankrike eller Argentina klickar på (de flesta) någon artikel i CMS från första sidan säger de att de inte längre kan se den översatta texten. Detta var aldrig något problem före uppgradering.

r.dziadusz
03-10-11, 15:27
Hej,
Från och med nu skall jag gärna hjälpa dig, om översättning du gör dessa tester alla api du använder: http://www.vbenterprisetranslator.com/forum/vbet4-troubleshooting/413-faq-2.html # post1729. Google apiv1 har satt nya strikta gräns, så antagligen du når den - jag vet det säkert efter test-, för hur man inte ska undvika det: Läs denna FAQ: http://www.vbenterprisetranslator.com/forum/vbet4- troubleshooting/413-faq-2.html # post10411

Om databasen fel: jag kommer invastigate det, och jag kommer att meddela dig så fort som möjligt

brubros
03-10-11, 15:56
Tack! Efter att ha granskat länkarna du gav till FAQ, jag har minskat språk till engelska, franska och spanska. Inga andra översättningar. Förhoppningsvis som kommer att minska översättningsvolym betydligt. Jag försökte också (igår) att köra koden föreslog att återgår Google Translate API testresultat som visar om TOS eller andra frågor kan finnas. Du kan se den fil jag använt (GT-test.php) under min html katalogen. Men jag kunde inte få den att springa efter FTPing den till platsen så jag hoppas ni har bättre tur. Jag ska sluta komma åt cp-admin nu tills jag får ytterligare instruktioner från er här på denna tråd. Tack igen för din hjälp.

brubros
04-10-11, 05:03
UPPDATERING: På grund av de frågor vi stött på, bestämde vi oss för att återställa vår hemsida tillbaka till sitt ursprungliga skick och med onsdag 28 september. Vi PMD Michal med mer information.

vBET
04-10-11, 10:31
Ja - vi fick PM. Jag har inte tänkt tidigare, men detta kan vara biverkning av fel uppgradering som händer på din server (vi fick tillgång detaljer för att fel FTP-plats). Så vi kommer att hålla den här frågan för ett ögonblick. Du har redan frisk och arbeta uppdatering. Tala om problemet händer igen. Om inte i ungefär en vecka kommer vi anser att det bara var bieffekt av fel uppgradering. Om det händer bara skriva här även om det blir redan som löst.

vBET
06-10-11, 02:58
Löst - se här: http://www.vbenterprisetranslator.com/forum/vbet4-bug-reporting/2471-sql-error-containing-reference-vbet-has-started-again.html#post10513

Automatic Translations (Powered by Google, Microsoft®, Yandex, SDL Language Cloud, IBM Watson and Apertium):
AfrikaansAlbanianArabicBelarusianBulgarianCatalanChineseCroatianCzechDanishDutchEnglishEstonianFilipinoFinnishFrenchGalicianGermanGreekHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKoreanLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishTaiwaneseThaiTurkishUkrainianVietnameseWelshYiddish
Translated to other languages supported by vB Enterprise Translator 4.10.1