[HMBeaty]

If you don't have vBSEO, don't worry about it. I was asking to help diagnose what's going on on your site with that error. Anyway, try this first go to your AdminCP and repair your database tables. You may need to run that a few times. Then see if it fixes your error.

If that does not work, then you need to execute a few queries. Follow these steps only if the above did not work!

First we need to get rid of the current table, since it can't be repaired

DROP TABLE contenttype;

Then we need to create it again

CREATE TABLE contenttype (
 contenttypeid INT UNSIGNED NOT NULL AUTO_INCREMENT,
 class VARBINARY(50) NOT NULL,
 packageid INT UNSIGNED NOT NULL,
 canplace ENUM('0','1') NOT NULL DEFAULT '0',
 cansearch ENUM('0','1') NOT NULL DEFAULT '0',
 cantag ENUM('0','1') DEFAULT '0',
 canattach ENUM('0','1') DEFAULT '0',
 isaggregator ENUM('0', '1') NOT NULL DEFAULT '0',
 PRIMARY KEY (contenttypeid),
 UNIQUE KEY packageclass (packageid, class)
);

If you do not have the suite installed, run this query next:

INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES
(1, 'Post', 1, '0', '1', '0', '1', '0'),
(2, 'Thread', 1, '0', '0', '1', '0', '0'),
(3, 'Forum', 1, '0', '1', '0', '0', '0'),
(4, 'Announcement', 1, '0', '0', '0', '0', '0'),
(5, 'SocialGroupMessage', 1, '0', '1', '0', '0', '0'),
(6, 'SocialGroupDiscussion', 1, '0', '0', '0', '0', '0'),
(7, 'SocialGroup', 1, '0', '1', '0', '1', '0'),
(8, 'Album', 1, '0', '0', '0', '1', '0'),
(9, 'Picture', 1, '0', '0', '0', '0', '0'),
(10, 'PictureComment', 1, '0', '0', '0', '0', '0'),
(11, 'VisitorMessage', 1, '0', '1', '0', '0', '0'),
(12, 'User', 1, '0', '0', '0', '0', '0'),
(13, 'Event', 1, '0', '0', '0', '0', '0'),
(14, 'Calendar', 1, '0', '0', '0', '0', '0');

If you do have the suite installed, run this query:

INSERT INTO `contenttype` VALUES (1, 'Post', 1, '0', '1', '0', '1', '0');
INSERT INTO `contenttype` VALUES (2, 'Thread', 1, '0', '0', '1', '0', '0');
INSERT INTO `contenttype` VALUES (3, 'Forum', 1, '0', '1', '0', '0', '0');
INSERT INTO `contenttype` VALUES (4, 'Announcement', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` VALUES (5, 'SocialGroupMessage', 1, '0', '1', '0', '0', '0');
INSERT INTO `contenttype` VALUES (6, 'SocialGroupDiscussion', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` VALUES (7, 'SocialGroup', 1, '0', '1', '0', '1', '0');
INSERT INTO `contenttype` VALUES (8, 'Album', 1, '0', '0', '0', '1', '0');
INSERT INTO `contenttype` VALUES (9, 'Picture', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` VALUES (10, 'PictureComment', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` VALUES (11, 'VisitorMessage', 1, '0', '1', '0', '0', '0');
INSERT INTO `contenttype` VALUES (12, 'User', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` VALUES (13, 'Event', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` VALUES (14, 'Calendar', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` VALUES (15, 'BlogEntry', 2, '0', '1', '0', '1', '0');
INSERT INTO `contenttype` VALUES (16, 'BlogComment', 2, '0', '1', '0', '0', '0');
INSERT INTO `contenttype` VALUES (17, 'Section', 3, '1', '0', '0', '0', '1');
INSERT INTO `contenttype` VALUES (18, 'Article', 3, '1', '1', '1', '1', '0');
INSERT INTO `contenttype` VALUES (19, 'ContentNode', 3, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` VALUES (20, 'StaticPage', 3, '1', '1', '1', '0', '0');
INSERT INTO `contenttype` VALUES (21, 'PhpEval', 3, '1', '0', '0', '0', '0');