Quote:
Originally Posted by TSR
(Post 2195621)
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:
Code:
$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. |
More Information