PDA

View Full Version : Solved Receive SQL error from vBulletin referencing vBET



brubros
02-10-11, 18:23
I get the following errors (I am only copying one example here) emailed to me throughout the day from vBulletin referencing vBET. This error only began after the latest upgrade to 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
Can you provide us exact URL which causes this error? The issue is that there is no language code included, but we have to invesrtigate why the code is not passed.

brubros
03-10-11, 14:48
Sorry - I did not get the whole error meesage before. This is what it says at the bottom of the error:

MySQL Error : Table 'actup.vbenterprisetranslator_cache_' doesn't exist
Error Number : 1146
Request Date : Monday, October 3rd 2011 @ 01:48:23 AM
Error Date : Monday, October 3rd 2011 @ 01:48:24 AM
Script : http://www.actup.org/forum/newreply.php?do=postreply&t=22081
Referrer : a NEW third person infectious RETROVIRUS - we should help! Please****** To answer the topic (http://www.actup.org/forum/ru/newreply.php?do=newreply&p=22596)
IP Address : 24.213.192.62
Username : SvetlanSehjs
Classname : vB_Database



Also, translations still do not work on our site since the upgrade. When a colleagues in France or Argentina clicks on (most) any article in the CMS from the front page they report that they no longer see translated text. This was never a problem before the upgrade.

r.dziadusz
03-10-11, 15:27
Hi,
From now on i will gladly help you, about translation please do these to tests all api you're using: http://www.vbenterprisetranslator.com/forum/vbet4-troubleshooting/413-faq-2.html#post1729. Google apiv1 has set new strict limit, so probably you reach it - i will know it for sure after tests-, for how not to avoid it: please read this faq: http://www.vbenterprisetranslator.com/forum/vbet4-troubleshooting/413-faq-2.html#post10411

About database error: i will invastigate it, and i will let you know as soon as possible

brubros
03-10-11, 15:56
Thank you! After reviewing the links you provided to FAQ, I have reduced languages to English, French and Spanish only. No other translations. Hopefully that will reduce translation volume significantly. I also tried (yesterday) to run the code suggested that returns the Google Translate API test results that indicate if TOS or other issues might exist. You can see the file I used (gt-test.php) under my html directory. But I could not get it to run after FTPing it to site so I hope you have better luck. I will stop accessing cp-admin now until I receive further instructions from you here on this thread. Thank you again for your help.

brubros
04-10-11, 05:03
UPDATE : Due to the issues we encountered, we decided to restore our web site back to its original state as of Wednesday September 28th. We PMd Michal with more information.

vBET
04-10-11, 10:31
Yes - we got PM. I didn't thought before but this could be side effect of wrong upgrade which happen on your server (we got access details to wrong FTP location). So we will hold this issue for a moment. You already have fresh and working update. Please tell if this issue happens again. If not in about a week we will consider it was just side effect of wrong upgrade. If it happens just write here even if it will be already considered solved.

vBET
06-10-11, 02:58
Solved - please see here: http://www.vbenterprisetranslator.com/forum/vbet4-bug-reporting/2471-sql-error-containing-reference-vbet-has-started-again.html#post10513

AfrikaansAlbanianArabicBelarusianBulgarianCatalanChineseCroatianCzechDanishDutchEnglishEstonianFilipinoFinnishFrenchGalicianGermanGreekHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKoreanLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishTaiwaneseThaiTurkishUkrainianVietnameseWelshYiddish
Translations supported by vBET 4.10.1