Missing social groups tables

[Kirkus]

I'm hoping someone can help me out with a problem I've recently discovered. When trying to remove a specific user account I received database errors in the admin center. I discovered that it's because, somehow, I no longer have any social group tables in my database.

Can anyone tell me how this might have happened and how I can fix it?

Any help would be very much appreciated. Thank you.

[BirdOPrey5]

Did you ever have social groups? All I can think of is maybe if you had an early version of 3.x, like 3.6, that never had social groups to begin with and the upgrade never finished correctly... If 3.8 was a fresh install it is very puzzling indeed.

The "social group" tables in 3.8 are:

• socialgroup
• socialgroupcategory
• socialgroupicon
• socialgroupmember
• socialgrouppicture

Can you confirm if any of them exist?

They can be recreated via MYSQL commands if need be, but not sure if a symptom of a bigger problem.

How long have you had the forum? Ever change hosts? been hacked? anything unusual?

[Kirkus]

Thank you, BirdOPrey5, for the reply.

I've verified that none of those tables exist. I've been using vBulletin for quite a number of years. I can't say for sure what version I began with but I know it was at least as far back as 3.6 (probably earlier). I've upgraded our forum software many times in the past (I don't recall ever having a problem with any of the upgrades) and have switched hosts and servers several times also.

I've never used Social Groups and only discovered the missing tables when trying to remove a member account. So I don't have a clue how long the tables have been missing.

I'm gearing up for an upgrade to the current version of vBulletin and want to make sure I remove as many potential problems as I can before moving forward.

[BirdOPrey5]

Please make sure you have a backup of your database before proceeding.

What I will give you are the SQL statements yuu need to create the socialgroup tables in 3.8.7.

Yo can run these by the SQL option in phpmyadmin or any other MySQL tool you use.

Make sure if you use a table prefix you replace the table prefix in the statements below with your own prefix. If you don't use a prefix you must remove the prefix. The prefix I am using in these examples is ju_ because it is what I use on my test forum.

Table 1.

 CREATE  TABLE  `[COLOR=#FF0000]ju_[/COLOR]socialgroup` (  `groupid` int( 10  )  unsigned NOT  NULL  auto_increment ,
 `socialgroupcategoryid` int( 10  )  unsigned NOT  NULL ,
 `name` varchar( 255  )  NOT  NULL default  '',
 `description` text,
 `creatoruserid` int( 10  )  unsigned NOT  NULL default  '0',
 `dateline` int( 10  )  unsigned NOT  NULL default  '0',
 `members` int( 10  )  unsigned NOT  NULL default  '0',
 `picturecount` int( 10  )  unsigned NOT  NULL default  '0',
 `lastpost` int( 10  )  unsigned NOT  NULL default  '0',
 `lastposter` varchar( 255  )  NOT  NULL default  '',
 `lastposterid` int( 10  )  unsigned NOT  NULL default  '0',
 `lastgmid` int( 10  )  unsigned NOT  NULL default  '0',
 `visible` int( 10  )  unsigned NOT  NULL default  '0',
 `deleted` int( 10  )  unsigned NOT  NULL default  '0',
 `moderation` int( 10  )  unsigned NOT  NULL default  '0',
 `type` enum(  'public',  'moderated',  'inviteonly'  )  NOT  NULL default  'public',
 `moderatedmembers` int( 10  )  unsigned NOT  NULL default  '0',
 `options` int( 10  )  unsigned NOT  NULL default  '0',
 `lastdiscussionid` int( 10  )  unsigned NOT  NULL default  '0',
 `discussions` int( 10  ) unsigned default  '0',
 `lastdiscussion` varchar( 255  )  NOT  NULL default  '',
 `lastupdate` int( 10  )  unsigned NOT  NULL default  '0',
 `transferowner` int( 10  )  unsigned NOT  NULL default  '0',
 PRIMARY  KEY (  `groupid`  ) ,
 KEY  `creatoruserid` (  `creatoruserid`  ) ,
 KEY  `dateline` (  `dateline`  ) ,
 KEY  `members` (  `members`  ) ,
 KEY  `picturecount` (  `picturecount`  ) ,
 KEY  `visible` (  `visible`  ) ,
 KEY  `lastpost` (  `lastpost`  ) ,
 KEY  `socialgroupcategoryid` (  `socialgroupcategoryid`  ) ,
 FULLTEXT  KEY  `name` (  `name` ,  `description`  )  );

Table 2.

 CREATE  TABLE `[COLOR=#FF0000]ju_[/COLOR]socialgroupcategory` (  `socialgroupcategoryid` int( 10  )  unsigned NOT  NULL  auto_increment ,
 `creatoruserid` int( 10  )  unsigned NOT  NULL ,
 `title` varchar( 250  )  NOT  NULL ,
 `description` text NOT  NULL ,
 `displayorder` int( 10  )  unsigned NOT  NULL ,
 `lastupdate` int( 10  )  unsigned NOT  NULL ,
 `groups` int( 10  ) unsigned default  '0',
 PRIMARY  KEY (  `socialgroupcategoryid`  ) ,
 KEY  `displayorder` (  `displayorder`  )  ) ;

Table 3.

 CREATE  TABLE `[COLOR=#FF0000]ju_[/COLOR]socialgroupicon` (  `groupid` int( 10  )  unsigned NOT  NULL default  '0',
 `userid` int( 10  ) unsigned default  '0',
 `filedata` mediumblob,
 `extension` varchar( 20  )  NOT  NULL default  '',
 `dateline` int( 10  )  unsigned NOT  NULL default  '0',
 `width` int( 10  )  unsigned NOT  NULL default  '0',
 `height` int( 10  )  unsigned NOT  NULL default  '0',
 `thumbnail_filedata` mediumblob,
 `thumbnail_width` int( 10  )  unsigned NOT  NULL default  '0',
 `thumbnail_height` int( 10  )  unsigned NOT  NULL default  '0',
 PRIMARY  KEY (  `groupid`  )  ) ;

Table 4.

 CREATE  TABLE  `[COLOR=#FF0000]ju_[/COLOR]socialgroupmember` (  `userid` int( 10  )  unsigned NOT  NULL default  '0',
 `groupid` int( 10  )  unsigned NOT  NULL default  '0',
 `dateline` int( 10  )  unsigned NOT  NULL default  '0',
 `type` enum(  'member',  'moderated',  'invited'  )  NOT  NULL default  'member',
 PRIMARY  KEY (  `groupid` ,  `userid`  ) ,
 KEY  `groupid` (  `groupid` ,  `type`  ) ,
 KEY  `userid` (  `userid` ,  `type`  )  ) ;

Table 5.

 CREATE  TABLE  `[COLOR=#FF0000]ju_[/COLOR]socialgrouppicture` (  `groupid` int( 10  )  unsigned NOT  NULL default  '0',
 `pictureid` int( 10  )  unsigned NOT  NULL default  '0',
 `dateline` int( 10  )  unsigned NOT  NULL default  '0',
 PRIMARY  KEY (  `groupid` ,  `pictureid`  ) ,
 KEY  `groupid` (  `groupid` ,  `dateline`  ) ,
 KEY  `pictureid` (  `pictureid`  )  ) ;

Again please be sure to change the ju_ in each command to your database prefix, if any.

This will give you the Social Group tables you should have... not sure if there will be other issues that will reveal themselves after this is fixed.

[Kirkus]

BirdOPrey, thank you so much!! Really. This is very much appreciated. I'll shut my forum down and run these tonight. I'll post the results after I'm done.

[Kirkus]

That was literally painless. I took a db backup and ran the queries above (without the prefix ). Had it done in less than 20 minutes. I was also able to delete user accounts without error.

Thank you so much, BirdOPrey5. Excellent support and help. I really can't tell you how much I appreciate it.