Uninstall Problem - MySQL Error

[Snake]

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
Referrer : Log in - Computer Juice - vBulletin Admin Control Panel
IP Address : 62.255.192.162
Username : Hybr!d
Classname : vB_Database
MySQL Version : 5.1.58

[Snake]

Hi this is urgent please, i have only half uninstalled!

[vBET]

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.

[r.dziadusz]

I have to weit, we are trying to reproduce this uinstall error in out test forum

[tsak76]

happens here also, i need to uninstal too

[Simon Lloyd]

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]

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]

maube it has to do that we have delete all secondary usergroups that vbet adds

[vBET]

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

[tsak76]

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