HELP How to enter MySQL tables

[Shazy225]

Ok, I just upgraded from 3.7.4 to 3.8.0, And anything that has to do with social groups, even the public profile page, I get a MySQL error.

Here Is the error

Database error in vBulletin 3.8.0:

Invalid SQL:

				SELECT socialgroup.groupid, socialgroup.name, socialgroup.description, socialgroup.dateline, sgicon.dateline AS icondateline,
					sgicon.thumbnail_width AS iconthumb_width, sgicon.thumbnail_height AS iconthumb_height
				FROM vbulletinsocialgroupmember AS socialgroupmember
				INNER JOIN vbulletinsocialgroup AS socialgroup ON
					(socialgroup.groupid = socialgroupmember.groupid)
				LEFT JOIN vbulletinsocialgroupicon AS sgicon ON sgicon.groupid = socialgroup.groupid
				WHERE
					socialgroupmember.userid = 140
					AND socialgroupmember.type = 'member'
				ORDER BY socialgroup.name;

MySQL Error   : Table 'halofan1_vb.vbulletinsocialgroupicon' doesn't exist
Error Number  : 1146
Request Date  : Friday, January 9th 2009 @ 05:47:22 PM
Error Date    : Friday, January 9th 2009 @ 05:47:23 PM
Script        : http://halo-fans.com/forums/member.php?action=getinfo&u=140
Referrer      : http://halo-fans.com/forums/
IP Address    : 71.137.193.118
Username      : M@gg0t
Classname     : vB_Database
MySQL Version : 5.0.67-community-log

I Checked in the phpmyadmin and there is no table vbulletinsocialgroupicon.

But the thing is, I don't know what to do to create it. I don't know like all the things to enter and stuff.

Please help

 

[Shazy225]

Ok, never mind I fixed it. But now I have a new problem. Whenever Someone tries to make a social group, I get this problem.

Database error in vBulletin 3.8.0:

Invalid SQL:
INSERT INTO vbulletinsocialgroup
	(name, description, creatoruserid, type, socialgroupcategoryid, options, dateline, lastpost, lastupdate)
VALUES
	('Magg0ts', 'The hardcore slipknot fans', 1, 'public', 1, 12, 1231553087, 1231553087, 1231553087);

MySQL Error   : Unknown column 'options' in 'field list'
Error Number  : 1054
Request Date  : Friday, January 9th 2009 @ 07:04:47 PM
Error Date    : Friday, January 9th 2009 @ 07:04:47 PM
Script        : http://halo-fans.com/forums/group.php?do=docreate
Referrer      : http://halo-fans.com/forums/group.php?do=create
IP Address    : 71.137.193.118
Username      : M@gg0t
Classname     : vB_Database
MySQL Version : 5.0.67-community-log