MySQL Error!

Database error in vBulletin 4.1.1:

Invalid SQL:

				SELECT contenttype.contenttypeid AS itemid
					
				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
					1 = 1 AND (product.active = '1' OR package.productid = 'vbulletin')  AND contenttype.canattach = '1';

MySQL Error   : Incorrect information in file: './XXXXXX/contenttype.frm'
Error Number  : 1033
Request Date  : Saturday, April 9th 2011 @ 02:00:11 AM
Error Date    : Saturday, April 9th 2011 @ 02:00:11 AM
Script        : http://XXXXXX/usercp.php
Referrer      : 
IP Address    : 186.109.XXX.XXX
Username      : XXXXXX
Classname     : vB_Database
MySQL Version : 5.0.92-community