Announcement

Collapse
No announcement yet.

error during upgrade 4.2.1 to 4.2.2

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Suite] error during upgrade 4.2.1 to 4.2.2

    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>
    SachiiDosti - Hum Sub Dost Hain

  • #2
    anyone??
    SachiiDosti - Hum Sub Dost Hain

    Comment


    • #3
      As the error says:
      Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT)
      You have a mix of collations. You should check the collation of the database tables AND the individual fields. One of them is definitely incorrect.

      Please don't PM or VM me for support - I only help out in the threads.
      vBulletin Manual & vBulletin 4.0 Code Documentation (API)
      Want help modifying your vbulletin forum? Head on over to vbulletin.org
      If I post CSS and you don't know where it goes, throw it into the additional.css template.

      W3Schools &lt;- awesome site for html/css help

      Comment


      • #4
        Originally posted by Lynne View Post
        As the error says:

        You have a mix of collations. You should check the collation of the database tables AND the individual fields. One of them is definitely incorrect.
        Please confirm if these are OK, or they need to be set swedish for every row e.g., userid, forumid and accessmask??
        SachiiDosti - Hum Sub Dost Hain

        Comment


        • #5
          Every table and every row in the tables needs to have the exact same collation.

          When vBulletin creates a new table in the upgrade process, it asks MySQL what the default collation for the database is and then uses that. Most MySQL installations default to latin1_swedish_ci. Newer versions will default to a UTF8 collation. If you have changed collations for any reason on tables in the past then you should change the database to use that as the default to prevent this issue from happening in the future.

          You will find more information in the MySQL manual here:
          http://dev.mysql.com/doc/refman/5.1/en/charset.html

          You will need to use phpMyAdmin and make sure that all tables and fields within them have the same collation. Make sure your database collations are appropriate and consistent throughout the entire database. You need to use program like phpmyadmin to view your collations:

          http://www.phpmyadmin.net/home_page/index.php

          When you click your database name in phpmyadmin it will list all tables, their collations, as well as the collation of the database itself at the bottom. And when you click the name of a table on the left it will list the collations of individual fields within that table.

          1) To edit the collation of the database itself you need to click the database name on the left and then click "Operations" on the top.

          2) To edit the collation of an individual table you need to click its name on the left and then click "Operations" on the top.

          3) To edit the collation of an individual field within a table you need to click the table name on the left and then click the edit image (a little pencil icon) for that field.

          For more information please see: https://www.vbulletin.com/forum/show...ight=collation

          Note: It is very very very important to make full database backups before proceeding if you are ever manually making any changes to your database, let it be issuing queries, or editing it via phpMyAdmin or any other interface. If done incorrectly, manually modifying the database can potentially cause irreversible damage to your database, and there is no way to perform a "partial restore" to restore just the part you may break.
          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud demonstration site.
          vBulletin 5 API - Full / Mobile
          Vote for your favorite feature requests and the bugs you want to see fixed.

          Comment


          • #6
            Thanks upgrade is complete but there are two tables, Phrase and Tag, they still have one field which i wasnt able to edit ??
            SachiiDosti - Hum Sub Dost Hain

            Comment


            • #7
              I also have all kinds of errors and issues with 4.2.3 are you guys coming up with 4.2.3 to fix the errors in 4.2.2.

              Comment


              • #8
                4.2.3???

                Comment


                • #9
                  Originally posted by mimocherry View Post
                  I also have all kinds of errors and issues with 4.2.3 are you guys coming up with 4.2.3 to fix the errors in 4.2.2.
                  i didnt get what you mean :-s
                  SachiiDosti - Hum Sub Dost Hain

                  Comment

                  widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                  Working...
                  X