can anyone help me with a question please?

[bomber1614]

hey guys, i just upgraded to a new vbulletin verison and i when i go to look at a thread or make a thread, i get a database error! can someone please tell me how to fix this!?

[HMBeaty]

Not without knowing what the database error is....

See my article here: https://vborg.vbsupport.ru/showthread.php?t=272014

[bomber1614]

there is the error!

Database error in vBulletin 4.1.9:

Invalid SQL:

(SELECT 'package' AS classtype, package.packageid AS typeid, package.packageid AS packageid,
package.productid AS productid, if(package.productid = 'vbulletin', 1, product.active) AS enabled,
package.class AS class, -1 as isaggregator
FROM package AS package
LEFT JOIN product AS product
ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin'
)

UNION

(SELECT 'contenttype' AS classtype, contenttypeid AS typeid, contenttype.packageid AS packageid,
1, 1, contenttype.class AS class , contenttype.isaggregator
FROM contenttype AS contenttype
INNER JOIN package AS package ON package.packageid = contenttype.packageid
LEFT JOIN product AS product ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin' );

MySQL Error : Incorrect information in file: './extre520_hax1997/contenttype.frm'
Error Number : 1033
Request Date : Tuesday, January 10th 2012 @ 11:33:19 PM
Error Date : Tuesday, January 10th 2012 @ 11:33:19 PM
Script : http://extremehax.net/showthread.php...t-done-yet&p=5
Referrer : http://extremehax.net/
IP Address : XXXXXXXXXXXX
Username : Apex
Classname : vB_Database
MySQL Version : 5.0.92-community

[HMBeaty]

Do you have vBSEO installed?

[bomber1614]

i have know idea what that is and would you please give me a link or something that i can download that from? lol im sorry i am a little new to vbulletin!

[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');

[bomber1614]

still didnt work! would you please teamview me if you can>? thanks!

[HMBeaty]

Then I would suggest submitting a support ticket on vbulletin.com