Forum error on Rebuild Search Index
 

error on Rebuild Search Index
Code:
http://domain.com/admincp/misc.php?do=emptyindex
Quote:
Database error in vBulletin 4.0.2:

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 data_base__package AS package
LEFT JOIN data_base__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 data_base__contenttype AS contenttype
INNER JOIN data_base__package AS package ON package.packageid = contenttype.packageid
LEFT JOIN data_base__product AS product ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin' );

MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Friday, March 5th 2010 @ 01:15:27 PM
Error Date : Friday, March 5th 2010 @ 01:15:27 PM
Script : http://domain.com/admincp/misc.php?do=doemptyindex
Referrer : http://domain.com/admincp/misc.php?do=emptyindex
IP Address : xxx.xxx.xxx.4
Username : admin
Classname : vB_Database
MySQL Version : 5.1.41-log

who do i fix this?
sorry if i wrong forum section...