| carolmyt |
05-08-2005 07:26 PM |
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:
Quote:
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:
Quote:
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:
Quote:
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. |
More Information