Running an SQL queriy from ACP

[JGM]

Running an SQL quiery from ACP

UPDATE 
 vbuser 
LEFT JOIN 
 vbuserfield 
ON 
 vbuser.userid = vbuserfield.userid 
SET 
 usergroupid = '8' 
WHERE 
 vbuserfield.field1 = 'man'

This is query I am trying to run, I have a lot of bots which have "man" as their biography so this will set them to the banned usergroup. The problem is that when I run it I get the following error;

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'the_vault.vbuser' doesn't exist

Any help would be appreciated.

JGM.

EDIT - Sorry forgot to mention I am on vBulletin v3.8.5.

 

[warezrock]

check the database, if vbuser table is there ??

 

[JGM]

Not sure warezrock all I want it to do is move every user who has "man" in their biography to the banned user group.

JGM.

~EDIT~

OK it's official... I am a fricking idiot! I got it working I had to change some of the code so instead it looks like this;

Query
UPDATE
user
LEFT JOIN
userfield
ON
user.userid = userfield.userid
SET
usergroupid = '8'
WHERE
userfield.field1 = 'man'

Everybody/bot who had "man" in their biography was moved to the Banned user group. Once I had done this I could then prune those members and remove them from the database using ACP>Users>Move/Prune Users and selecting the Banned user group.

Hope this helps anybody since it sure has helped me!