AWS Uninstall. Plagued by Warnings Field List

[kh99]

Originally Posted by TSR

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.