PDA

View Full Version : Solved Get error when edit/reply post, because a thread



basketmen
18-11-10, 16:18
Hi guys,



Our default language are Indonesia

Some time get this error message in email, few weeks ago this problem are not too often, but now its more often almost everyday, maybe because more thread starter are writen in other language, for example in english, the error usually are because the thread that writen in other language, and translated to our default language, indonesia









Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT translated FROM vbenterprisetranslator_cache_short_id WHERE originaltext='michael+jackson+ghost';

MySQL Error :
Error Number :
Date : Thursday, November 18th 2010 @ 08:32:32 AM
Script : http://www.domain.com/editpost.php?do=updatepost&postid=718277
Referrer : http://www.domain.com/other-thread-title/index326.html
IP Address : 125.165.13.xxx
Username : xxxx
Classname : vB_Database





Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT translated FROM vbenterprisetranslator_cache_short_id WHERE originaltext='michael+jackson+ghost';

MySQL Error :
Error Number :
Date : Thursday, November 18th 2010 @ 08:32:32 AM
Script : http://www.domain.com/ajax.php?do=quickedit&p=717875
Referrer : http://www.domain.com/other-thread-title/index326.html
IP Address : 125.165.13.xxx
Username : xxxx
Classname : vB_Database





Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT translated FROM vbenterprisetranslator_cache_short_id WHERE originaltext='michael+jackson+ghost';

MySQL Error :
Error Number :
Date : Thursday, November 18th 2010 @ 08:32:32 AM
Script : http://www.domain.com/newreply.php?do=postreply&t=53451
Referrer : http://www.domain.com/other-thread-title/index326.html
IP Address : 125.165.13.xxx
Username : xxxx
Classname : vB_Database









from error message example above, i search and delete the thread with title "michael jackson ghost", then the error not showing again in email


the error usually are getting by members when they editing or reply post (the post are not related to michael jackson ghost thread at all like error message above)







any analyze about this guys?

the database table vbenterprisetranslator_cache_short_id its looks like the problem, i already tried repair and optimize it, and Cache Cleaner from admincp but this problem stil occur

mateuszr
19-11-10, 12:27
MySQL Error :
Error Number :

These fields are blank, so we don't know, what error is that.
Please contact with MySQL support and ask why your messages do not have any error number nor error description. Also - did you check MySQL logs? Maybe there will be more about it.

We have asked on MySQL forum about enabling of errors display as well

kamilkurczak
07-12-10, 17:22
no answer - solved. If not, please write here and I will open this thread again

basketmen
07-01-11, 18:33
still cannot solved actually guys, i am still get this error message to email almost every day, every time there are a new thread created from not default language, and other member do edit post or new reply in other threads, the error messages only get by member, because member can edit/newreply the posts, guest cannot do that so cannot get this error messages


is there any clue or something that i can try guys? the database table that get error are only vbenterprisetranslator_cache_medium_id




- my default language are Indonesian, if i uncheck it in Admincp --> vBet --> Chace --> uncheck Indonesian in Cache details, so not using cache for Indonesian, we dont get the error again, but it is better if we can use cache too for our default language, Indonesian



- i use vbulletin 3.6.8



- here are the real error messages to email

http://i291.photobucket.com/albums/ll284/basketmen/errortoemail1.jpg

http://i291.photobucket.com/albums/ll284/basketmen/errortoemail2.jpg

http://i291.photobucket.com/albums/ll284/basketmen/errortoemail3.jpg

http://i291.photobucket.com/albums/ll284/basketmen/errortoemail4.jpg

http://i291.photobucket.com/albums/ll284/basketmen/errortoemail5.jpg

http://i291.photobucket.com/albums/ll284/basketmen/errortoemail6.jpg

http://i291.photobucket.com/albums/ll284/basketmen/errortoemail7.jpg

http://i291.photobucket.com/albums/ll284/basketmen/errortoemail8.jpg

http://i291.photobucket.com/albums/ll284/basketmen/errortoemail9.jpg






- there are other some one that get this exactly same error message too : http://www.vbenterprisetranslator.com/forum/troubleshooting/451-inquiries-to-the-table-on-page-translator-of-the-original-language.html#post1651

please help guys if there is some thing i can try

kamilkurczak
08-01-11, 11:09
hello,

We still no have a error number


MySQL Error :
Error Number :

These fields are blank, so we don't know, what error is that.
Please contact with MySQL support and ask why your messages do not have any error number nor error description. Also - did you check MySQL logs? Maybe there will be more about it.

kamilkurczak
19-01-11, 10:41
no answer - solved. If not, please write here and I will open this thread again.

AfrikaansAlbanianArabicBelarusianBulgarianCatalanChineseCroatianCzechDanishDutchEnglishEstonianFilipinoFinnishFrenchGalicianGermanGreekHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKoreanLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishTaiwaneseThaiTurkishUkrainianVietnameseWelshYiddish
Translated to other languages thanks to vB Enterprise Translator 4.10.1