database error on usercp

[YOPOP]

One of my member is experiencing this error everytime she go to her usercp

Database error in vBulletin 3.8.1:Invalid SQL:    SELECT socialgroup.*, socialgroup.dateline AS createdate, user.username AS creatorusername
     , socialgroupmember.type AS membertype,
     sgc.title AS categoryname, sgc.socialgroupcategoryid AS categoryid,
     socialgroupicon.dateline AS icondateline, socialgroupicon.thumbnail_width AS iconthumb_width,
     socialgroupicon.thumbnail_height AS iconthumb_height
     , groupread.readtime AS readtime
     , subscribegroup.emailupdate
FROM socialgroup AS socialgroup
    INNER JOIN subscribegroup AS subscribegroup ON
     (subscribegroup.userid = 678 AND subscribegroup.groupid = socialgroup.groupid)
LEFT JOIN socialgroupmember AS socialgroupmember ON
     (socialgroupmember.userid = 678 AND socialgroupmember.groupid = socialgroup.groupid)
    LEFT JOIN socialgroupicon AS socialgroupicon ON socialgroupicon.groupid = socialgroup.groupid
    LEFT JOIN user AS user ON (user.userid = socialgroup.creatoruserid)
     LEFT JOIN groupread AS groupread
      ON (groupread.groupid = socialgroup.groupid
          AND groupread.userid = 678)
    INNER JOIN socialgroupcategory AS sgc ON (sgc.socialgroupcategoryid = socialgroup.socialgroupcategoryid)
    WHERE 1=1
    ORDER BY socialgroup
MySQL Error   : Unknown column 'subscribegroup.emailupdate' in 'field list'
Error Number  : 1054
Request Date  : Monday, June 29th 2009 @ 05:54:07 AM
Error Date    : Monday, June 29th 2009 @ 05:54:08 AM
Script        : http://www.mysite.com/usercp.php
Referrer      : http://www.mysite.com/
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.77-community-log

I hope someone can help me

 

[bluescorpion]

Looks like you might have a file compatibility issue:


Your database is 3.8.1 and your files are 3.8.2. Either run upgrade.php or do a full upgrade to 3.8.3.

 

[Hoxxy]

Try running this quiry:

CREATE TABLE IF NOT EXISTS `subscribegroup` (
  `subscribegroupid` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `groupid` int(10) unsigned NOT NULL default '0',
  `emailupdate` enum('daily','weekly','none') NOT NULL default 'none',
  PRIMARY KEY  (`subscribegroupid`),
  UNIQUE KEY `usergroup` (`userid`,`groupid`),
  KEY `groupid` (`groupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Always make a back up before playing with your databases!