Database Error and Can't Find all posts by User
 

Hi,

When I click the 'Find all Posts by User' link, vBulletin returns "Sorry - no matches. Please try some different terms." even though the user definitely has posted.

Also, I am getting the following error:
-------------------------------------------------------

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT user.userid, user.salt, user.username, user.email, user.languageid, user.usergroupid, user.membergroupids,
user.timezoneoffset, IF(user.options & 128, 1, 0) AS dstonoff,
IF(user.options & 8192, 1, 0) AS hasaccessmask,
socialgroup.groupid, socialgroup.name, socialgroup.options, socialgroupmember.type AS membertype,
language.dateoverride AS lang_dateoverride, language.timeoverride AS lang_timeoverride, language.locale AS lang_locale
FROM subscribegroup AS subscribegroup
INNER JOIN socialgroup AS socialgroup ON (socialgroup.groupid = subscribegroup.groupid)
INNER JOIN user AS user ON (user.userid = subscribegroup.userid)
LEFT JOIN socialgroupmember AS socialgroupmember ON
(socialgroupmember.userid = user.userid AND socialgroupmember.groupid = socialgroup.groupid)
LEFT JOIN usergroup AS usergroup ON (usergroup.usergroupid = user.usergroupid)
LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
WHERE subscribegroup.emailupdate = 'weekly' AND
socialgroup.lastpost > 1250460051 AND
user.usergroupid 3 AND
(usergroup.genericoptions & 32);

MySQL Error : Unknown column 'subscribegroup.emailupdate' in 'where clause'
Error Number : 1054
Request Date : Monday, August 24th 2009 @ 09:02:50 AM
Error Date : Monday, August 24th 2009 @ 09:02:51 AM
Script : http://www.electricalforum.co.uk/cro...and=1251097365
Referrer : http://www.electricalforum.co.uk/
IP Address : 90.214.9.175
Username : Unregistered
Classname : vb_database
MySQL Version :


-----------------------------------------------------


Any help with the reasons for this and what I can do about it greatly appreciated.


:confused: