Hi,
i am getting following error on 96% upgrade, the collation is already latin1_swedish_ci
Action Required
Unexpected Text:
<?xml version="1.0" encoding="windows-1252"?> <br /> <b>Warning</b>: mysqli_query() [<a href='function.mysqli-query'>function.mysqli-query</a>]: (HY000/1267): Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '=' in <b>/home/sachiido/public_html/forum/includes/class_core.php</b> on line <b>1393</b><br /> <?xml version="1.0" encoding="windows-1252"?> <errors> <error><![CDATA[<p>Database Error</p> Invalid SQL: SELECT pd.* FROM productdependency AS pd INNER JOIN product AS p ON (p.productid = pd.productid) WHERE pd.productid IN ('vbblog', 'vbcms', 'skimlinks', 'forumrunner', 'postrelease', 'panjo') AND p.active = 1 ORDER BY pd.dependencytype, pd.parentproductid, pd.minversion; Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '=']]></error> <error_html><![CDATA[<p>Database error in vBulletin 4.2.2</p> <p>Invalid SQL: SELECT pd.* FROM productdependency AS pd INNER JOIN product AS p ON (p.productid = pd.productid) WHERE pd.productid IN ('vbblog', 'vbcms', 'skimlinks', 'forumrunner', 'postrelease', 'panjo') AND p.active = 1 ORDER BY pd.dependencytype, pd.parentproductid, pd.minversion;<p> <p> <strong>MySQL Error</strong> : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='<br /> <strong>Error Number</strong> : 1267<br /> <strong>Request Date</strong> : Sunday, October 27th 2013 @ 11:08:36 PM<br /> <strong>Error Date</strong> : Sunday, October 27th 2013 @ 11:08:36 PM<br /> <strong>Script</strong> : http://xxxxxxxxxxx.com/forum/install/upgrade.php<br /> <strong>Referrer</strong> : http://xxxxxxxxxxx.com/forum/install/upgrade.php<br /> <strong>Classname</strong> : vB_Database_MySQLi<br /> <strong>MySQL Version</strong> : 5.1.70-cll<br /> </p>]]></error_html> </errors>
i am getting following error on 96% upgrade, the collation is already latin1_swedish_ci
Action Required
Unexpected Text:
<?xml version="1.0" encoding="windows-1252"?> <br /> <b>Warning</b>: mysqli_query() [<a href='function.mysqli-query'>function.mysqli-query</a>]: (HY000/1267): Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '=' in <b>/home/sachiido/public_html/forum/includes/class_core.php</b> on line <b>1393</b><br /> <?xml version="1.0" encoding="windows-1252"?> <errors> <error><![CDATA[<p>Database Error</p> Invalid SQL: SELECT pd.* FROM productdependency AS pd INNER JOIN product AS p ON (p.productid = pd.productid) WHERE pd.productid IN ('vbblog', 'vbcms', 'skimlinks', 'forumrunner', 'postrelease', 'panjo') AND p.active = 1 ORDER BY pd.dependencytype, pd.parentproductid, pd.minversion; Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '=']]></error> <error_html><![CDATA[<p>Database error in vBulletin 4.2.2</p> <p>Invalid SQL: SELECT pd.* FROM productdependency AS pd INNER JOIN product AS p ON (p.productid = pd.productid) WHERE pd.productid IN ('vbblog', 'vbcms', 'skimlinks', 'forumrunner', 'postrelease', 'panjo') AND p.active = 1 ORDER BY pd.dependencytype, pd.parentproductid, pd.minversion;<p> <p> <strong>MySQL Error</strong> : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='<br /> <strong>Error Number</strong> : 1267<br /> <strong>Request Date</strong> : Sunday, October 27th 2013 @ 11:08:36 PM<br /> <strong>Error Date</strong> : Sunday, October 27th 2013 @ 11:08:36 PM<br /> <strong>Script</strong> : http://xxxxxxxxxxx.com/forum/install/upgrade.php<br /> <strong>Referrer</strong> : http://xxxxxxxxxxx.com/forum/install/upgrade.php<br /> <strong>Classname</strong> : vB_Database_MySQLi<br /> <strong>MySQL Version</strong> : 5.1.70-cll<br /> </p>]]></error_html> </errors>
Comment