Receive SQL error from vBulletin referencing vBET

[brubros]

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]

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]

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....treply&t=22081
Referrer: A new third person infectious retrovirus - we need help! Please! -Reply to topic
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 CMS from the front page they report that they no longer see translated text. This was never a problem before the upgrade.

[r.dziadusz]

Hi,
From now on i will gladly help you, about translation please do these to tests all api you're using: http://www.vbenterprisetranslator.co....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.co...html#post10411

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

[brubros]

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]

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]

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]

Solved - please see here: http://www.vbenterprisetranslator.co...html#post10513