doanvananhtoan
15-05-2011, 07:16 AM
Em nâng cấp 4rum từ 3.8.2 lên bản 4.1.3, tiến hành đầy đủ các bước, uninstall toàn bộ các mod. Trong quá trình upgrade báo lỗi sau:
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 (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=']]></error>
<error_html><![CDATA[<p>Database error in vBulletin 3.8.2</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 (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='<br />
<strong>Error Number</strong> : 1267<br />
<strong>Request Date</strong> : Sunday, May 15th 2011 @ 07:05:24 AM<br />
<strong>Error Date</strong> : Sunday, May 15th 2011 @ 07:05:24 AM<br />
<strong>Script</strong> : http://xxx.com/4rum/install/upgrade.php<br />
<strong>Referrer</strong> : http://xxx.com/4rum/install/upgrade.php<br />
<strong>Classname</strong> : vB_Database<br />
<strong>MySQL Version</strong> : 5.0.67-community<br />
</p>]]></error_html>
</errors>
Đã search, cũng có nhiều bác gặp lỗi này nhưng chưa có cách khắc phục. :-/
Mong các bác giúp đỡ #-o
Cảm ơn các bác nhiều...[-O<
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 (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=']]></error>
<error_html><![CDATA[<p>Database error in vBulletin 3.8.2</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 (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='<br />
<strong>Error Number</strong> : 1267<br />
<strong>Request Date</strong> : Sunday, May 15th 2011 @ 07:05:24 AM<br />
<strong>Error Date</strong> : Sunday, May 15th 2011 @ 07:05:24 AM<br />
<strong>Script</strong> : http://xxx.com/4rum/install/upgrade.php<br />
<strong>Referrer</strong> : http://xxx.com/4rum/install/upgrade.php<br />
<strong>Classname</strong> : vB_Database<br />
<strong>MySQL Version</strong> : 5.0.67-community<br />
</p>]]></error_html>
</errors>
Đã search, cũng có nhiều bác gặp lỗi này nhưng chưa có cách khắc phục. :-/
Mong các bác giúp đỡ #-o
Cảm ơn các bác nhiều...[-O<