Апгрейт с 3.8.6 на 4.1.9

04-03-2012, 04:57 AM

Всем привет.Помогите пожалуйста.
На 89-ом шаге выскакивает вот такая ошибка

Code:

Unexpected Text:
<?xml version="1.0" encoding="windows-1252"?>
<?xml version="1.0" encoding="windows-1252"?>
<errors>
	<error><![CDATA[<p>Database Error</p>

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

Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=']]></error>
	<error_html><![CDATA[<p>Database error in vBulletin 3.8.6</p>
<p>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'  );<p>
<p>
<strong>MySQL Error</strong>   : Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='<br />
<strong>Error Number</strong>  : 1267<br />
<strong>Request Date</strong>  : Tuesday, April 3rd 2012 @ 03:58:41 AM<br />
<strong>Error Date</strong>    : Tuesday, April 3rd 2012 @ 03:58:43 AM<br />
<strong>Script</strong>        : http://домен.ru/install/upgrade.php<br />
<strong>Referrer</strong>      : http://домен.ru/install/upgrade.php<br />
<strong>Classname</strong>     : vB_Database<br />
<strong>MySQL Version</strong> : 5.1.58-1~dotdeb.0-log<br />
</p>]]></error_html>
</errors>

Как это исправить?