PDA

View Full Version : Solved Uninstall Problem - MySQL Error



Snake
29-09-11, 15:13
When i try to remove the product i get this error.

Database error in vBulletin 3.8.7:

Invalid SQL:
UPDATE user SET usergroupid = 2 WHERE usergroupid IN ();

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
Error Number : 1064
Request Date : Thursday, September 29th 2011 @ 01:11:58 PM
Error Date : Thursday, September 29th 2011 @ 01:11:58 PM
Script : Log in - Computer Juice - vBulletin Admin Control Panel (http://www.computer-juice.com/forums/admincp/plugin.php?do=productkill)
Referrer : Log in - Computer Juice - vBulletin Admin Control Panel (http://www.computer-juice.com/forums/admincp/plugin.php?do=productdelete&productid=vbenterprisetranslator)
IP Address : 62.255.192.162
Username : Hybr!d
Classname : vB_Database
MySQL Version : 5.1.58

Snake
29-09-11, 15:59
Hi this is urgent please, i have only half uninstalled!

r.dziadusz
29-09-11, 16:29
I have to weit, we are trying to reproduce this uinstall error in out test forum

tsak76
29-09-11, 16:48
happens here also, i need to uninstal too

vBET
29-09-11, 17:46
Hi this is urgent please, i have only half uninstalled!

Please just disable vBET until the time we provide quick fix for this issue. When mod is disabled it has no influence on your forum.

Simon Lloyd
29-09-11, 21:13
I disabled vBET as you instructed (im not uninstalling but my server seems to messed up since upgrading to vBET3.4.1 from vBET3.4.0 last night) and i have hundreds upon hundreds of these vbenterprisetranslator_seo.php running in server processes, how do i stop them?

r.dziadusz
30-09-11, 11:43
Snake, tsak76 :I've tried to reproduce this issue but in my forum test everything works , if you want to fully uinstall product please PM your access and I will try to fix it on place
Simon Lloyd: this is other problem, so please open new thread for this issue

tsak76
30-09-11, 13:05
maube it has to do that we have delete all secondary usergroups that vbet adds

r.dziadusz
30-09-11, 14:11
You have delete something manually? If cannot look on it can only guess what's happend

tsak76
30-09-11, 15:38
unfortunately vbet is still very unstable, this happened to my site also and i had to make a vb upgrade in order to fix it . now i see the exact same thing here too so its vbet related

http://img23.imageshack.us/img23/831/vbett.png (http://imageshack.us/photo/my-images/23/vbett.png/)

Uploaded with ImageShack.us (http://imageshack.us)

tsak76
02-10-11, 17:50
can a provide a fix so we can uninstall ? thx

vBET
02-10-11, 23:27
maube it has to do that we have delete all secondary usergroups that vbet adds

This is great hint. In fact this query is executing during cleanup of additional usergroups. We was not able to reproduce it, because we was testing vBET - you have modified vBET, so this behavior is even not a bug, just troubleshooting related to your personal changes in vBET. And that is why you have empty () in your query (no vBET roles was found and those suppose to exist).

OK so to avoid this issue please:
1. Open file /includes/vbenterprisetranslator_functions_usergroups.php
2. Find:

function vbet_removeDefaultLanguageGroups() {
3. Comment or remove its whole body - everyting until closing } before function vbet_removeGroupFromMembers (but without it)
NOTE: this hint is not tested and it assumes that you already removed vBET additional roles, so you do not need cleanup during uninstall.

Please tell did it help :)

vBET
02-10-11, 23:31
unfortunately vbet is still very unstable, this happened to my site also and i had to make a vb upgrade in order to fix it . now i see the exact same thing here too so its vbet related

http://img23.imageshack.us/img23/831/vbett.png (http://imageshack.us/photo/my-images/23/vbett.png/)

Uploaded with ImageShack.us (http://imageshack.us)

This is out of topic for this thread. For new issue open new thread. Shortly - most probably it is not a bug and you was just blocked by translation provider. No more here - please open new thread, if you need support in this area. As I understand it is not a case, because you are during uninstall vBET.

tsak76
05-10-11, 17:48
This is great hint. In fact this query is executing during cleanup of additional usergroups. We was not able to reproduce it, because we was testing vBET - you have modified vBET, so this behavior is even not a bug, just troubleshooting related to your personal changes in vBET. And that is why you have empty () in your query (no vBET roles was found and those suppose to exist).

OK so to avoid this issue please:
1. Open file /includes/vbenterprisetranslator_functions_usergroups.php
2. Find:

function vbet_removeDefaultLanguageGroups() {
3. Comment or remove its whole body - everyting until closing } before function vbet_removeGroupFromMembers (but without it)
NOTE: this hint is not tested and it assumes that you already removed vBET additional roles, so you do not need cleanup during uninstall.

Please tell did it help :)i removed it but when trying to uninstall..

fatal error: Call to undefined function vbet_removeDefaultLanguageGroups() plugin.php(1522) : eval()'d code on line 14

vBET
06-10-11, 01:43
i removed it but when trying to uninstall..

fatal error: Call to undefined function vbet_removeDefaultLanguageGroups() plugin.php(1522) : eval()'d code on line 14

You didn't suppose to remove the function - just its body (so everything after function signature and before closing }). The function itself have to stay. Sorry if I didn't make it clear.

vBET
09-10-11, 13:30
Do you still need help here or last response allow to solve the issue? :)

vBET
18-10-11, 13:37
No answer - assumed it is solved. If the issue still exists please just write here.

AfrikaansAlbanianArabicBelarusianBulgarianCatalanChineseCroatianCzechDanishDutchEnglishEstonianFilipinoFinnishFrenchGalicianGermanGreekHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKoreanLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishTaiwaneseThaiTurkishUkrainianVietnameseWelshYiddish
Translated to other languages supported by vB Enterprise Translator PRODUCER_PRODUCT_VERSION