AWS Uninstall. Plagued by Warnings Field List

[b00k]

-----------

[kh99]

The current version doesn't seem to have that column in the db, so I'm guessing you have a plugin from an older version or some file that's an old version. Maybe uninstall it and then go to the plugin manager and see if you can find a plugin that looks like it's part of some AWS version.

[b00k]

-----------

[kh99]

Well, you wouldn't actually have to uninstall it, you could go through all the plugins looking for which one has the query from your error message. It's just that it might be easier if you know it's been uninstalled, then you'd know there shouldn't be any plugins for that mod.

[b00k]

..........................

[kh99]

Even if I use:
define('DISABLE_HOOKS', true);
in the config, the error persists.

I am guessing this is a bit more than just pluggins being disabled and perhaps a SQL fix is required but I am not certain

Oh, right. OK, do you have any way to search all your vb files? I'd search for some (hopefully) unique section from the query, like maybe "infractions, ipoints, warnings".

ETA: That looks like a query from admin/user.php around line 120:
$searchquery = "
SELECT
user.userid, reputation, username, usergroupid, birthday_search, email,
parentemail,(options & " . $vbulletin->bf_misc_useroptions['coppauser'] . ") AS coppauser, homepage, icq, aim, yahoo, msn, skype, signature,
usertitle, joindate, lastpost, posts, ipaddress, lastactivity, userfield.*
FROM " . TABLE_PREFIX . "user AS user
LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
WHERE $condition
ORDER BY " . $db->escape_string($vbulletin->GPC['orderby']) . " " . $db->escape_string($vbulletin->GPC['direction']) . "
LIMIT " . $vbulletin->GPC['limitstart'] . ", " . $vbulletin->GPC['limitnumber']
;

except that (by total coincidence) it's missing "infractions, ipoints, warnings".

ETA: another thought...I have vb version 3.8.3, so I suppose it's possible it is something taht changed going to 3.8.4 and a "warnings" field was actually added to the user table, and uninstalling that mod removed it. If that's the case then the solution might be to put it back. If you look in install/mysql_schema.xml and search for '"user' (with the " in front), then you should be able to check if it should have a warnings column or not.

[Lynne]

Questions/Problems regarding modifications/styles need to be asked in the modification/style thread. That is where the support for modification/style is - not out here in the main forums. Please note that if a modification/style is unsupported (or even if it says it is supported), you may be on your own if you chose to install it. Uninstalling modifications means going through the installation steps totally backwards and removing all files, file edits, template edits, products, etc.