[carolmyt]

Well, just to have all my bases covered, here's my problem:

I've got problems with the SQL when I try to change usergroup permissions. First, I received this message:

Database error in vBulletin 3.0.6:

Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Moderators',
description = '',
usertitle = 'Moderator',
opentag = '',
closetag = '',
passwordexpires = '0',
passwordhistory = '0',
shoutview = '0',
shoutpost = '0',
shoutmaxdaily = '0',
shoutedit = '0',
shoutdelete = '0',
shouthdelete = '0',
shouteditothers = '0',
shoutdeleteothers = '0',
shouthdeleteothers = '0',
shoutip = '0',
shoutcoventry = '0',
shouthierarchy = '3',
attachlimit = '500000',
avatarmaxwidth = '130',
avatarmaxheight = '160',
avatarmaxsize = '20000',
profilepicmaxwidth = '100',
profilepicmaxheight = '100',
profilepicmaxsize = '65535',
pmquota = '50',
pmsendmax = '5',
uttstore_discount = '0',
forumpermissions = '2748927',
pmpermissions = '1',
calendarpermissions = '31',
wolpermissions = '3',
adminpermissions = '0',
genericpermissions = '2629263',
genericoptions = '22'
WHERE usergroupid=7
mysql error: Unknown column 'shoutview' in 'field list'

mysql error number: 1054

I saw people here had had similar problems, and tried the previously suggested SQL queries to uninstall, as a prelude to reinstalling. The queries were:

ALTER TABLE language DROP phrasegroup_shoutbox;

DELETE FROM phrasetype WHERE phrasetypeid=716;

DROP TABLE IF EXISTS shoutbox_posts;

ALTER TABLE usergroup
DROP `shoutboxpermissions`,
DROP `shouthierarchy`,
DROP `shoutmaxdaily`;

ALTER TABLE user
DROP `shouts`,
DROP `shoutbanned`;

Then, when trying to uninstall the hack, I got this:

Database error in vBulletin 3.0.6:

Invalid SQL: ALTER TABLE language DROP phrasegroup_shoutbox
mysql error: Can't DROP 'phrasegroup_shoutbox'. Check that column/key exists

mysql error number: 1091

I'm still getting the error message when I try to change usergroups, and now my homepage is unaccessible; I'm just getting the generic database error message.

My site has been down because of this for over 24 hours now, and I don't know how to fix it. At this point, I'd be happy just getting the shoutbox uninstalled. Please, SOMEBODY help.