Announcement

Collapse
No announcement yet.

Errors when upgrading to 3.8

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

  • Errors when upgrading to 3.8

    I had an issue upgrading to 3.8 with the database tables not having the correct collation. I restored my backup and changed all tables to general_swedish_ci then ran the backup and everything seemed to go fine.

    Now I have a weird error in my smilies box, here is a pic. I can't think of anything else that would have had an effect other than me changing the collations on my tables, but why would it cause this error:
    Attached Files

  • #2
    Changing collations doesn't actually change the data to match the new collation. If your new collation is incompatible with the previous character set, you would have problems like this.

    What was the collation before and what is the collation now?
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment


    • #3
      Most tables were latin1_general_ci but I changed them all to latin1_swedish_ci as that is what I read was the best thing to do.

      What can I do now to fix this problem?

      Comment


      • #4
        I would suggest changing them back. You actually shouldn't change encodings of tables with data in them. IF you experience a problem, then you should change other tables to match your current encoding.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment


        • #5
          I changed them all back and I still get the error..

          Comment


          • #6
            Nobody have any advice? I can't believe I would be the only person having this issue when upgrading to 3.8.

            Comment


            • #7
              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. 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: http://www.vbulletin.com/forum/showt...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.
              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
              Change CKEditor Colors to Match Style (for 4.1.4 and above)

              Steve Machol Photography


              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


              Comment


              • #8
                My database collation is latin1_general_ci and I have checked all fields as you have said to do and they are all the same.

                Are you saying I should change them all to swedish?

                Comment


                • #9
                  Ended up fixing it by editing each smilie and removing the incorrect characters. Thank!

                  Comment


                  • #10
                    Edit and save each of your smilies to reset their database records.
                    Translations provided by Google.

                    Wayne Luke
                    The Rabid Badger - a vBulletin Cloud demonstration site.
                    vBulletin 5 API

                    Comment

                    Related Topics

                    Collapse

                    Working...
                    X