Announcement

Collapse
No announcement yet.

First try failed

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

  • First try failed

    Yesterday I tried to upgrade to Beta 2 but at the 11th step of beta 1 everything hang for a mixed collation error

    I'll try again now
    Italian Body Building & Fitness : www.BodyWeb.com
    Italian unofficial support Forum : www.vBulletin.it

  • #2
    Ok.. how can we help?

    Comment


    • #3
      That's today, same as yesterday, any suggestments ?

      Code:
      Database error in vBulletin 3.5.4:
      
      Invalid SQL:
      
      		SELECT atype.extension, atype.thumbnail, atype.newwindow, aperm.usergroupid,
      			atype.height AS default_height, atype.width AS default_width, atype.size AS default_size,
      			aperm.height AS custom_height, aperm.width AS custom_width, aperm.size AS custom_size,
      			aperm.attachmentpermissions AS custom_permissions
      		FROM attachmenttype AS atype
      		LEFT JOIN attachmentpermission AS aperm USING (extension)
      		WHERE enabled = 1
      		ORDER BY extension;
      
      MySQL Error  : Illegal mix of collations (utf8_bin,IMPLICIT) and (latin1_bin,IMPLICIT) for operation '='
      Error Number : 1267
      Date         : Sunday, June 18th 2006 @ 01:43:09 AM
      Script       : http://www.vbulletin.it/forums/install/upgrade_360b1.php?step=11
      Referrer     : http://www.vbulletin.it/forums/install/upgrade_360b1.php?step=10
      IP Address   : 81.174.32.193
      Username     : 
      Classname    : vb_database
      Italian Body Building & Fitness : www.BodyWeb.com
      Italian unofficial support Forum : www.vBulletin.it

      Comment


      • #4
        I forgot, PHP 4.4.0 , MySql 4.1.13
        Italian Body Building & Fitness : www.BodyWeb.com
        Italian unofficial support Forum : www.vBulletin.it

        Comment


        • #5
          Maybe the info here helps debug it:

          http://www.vbulletin.com/forum/showthread.php?t=182933

          Comment


          • #6
            I manually modified altering the collation of a couple of table with mysqladministrator and now it's working.
            Italian Body Building & Fitness : www.BodyWeb.com
            Italian unofficial support Forum : www.vBulletin.it

            Comment


            • #7
              Originally posted by Floris View Post
              Maybe the info here helps debug it:

              http://www.vbulletin.com/forum/showthread.php?t=182933
              I said too early Now I got that problem too, in the admin panel, I'll try to alter some other tables .
              Italian Body Building & Fitness : www.BodyWeb.com
              Italian unofficial support Forum : www.vBulletin.it

              Comment


              • #8

                Now I got this :
                Code:
                Database error in vBulletin 3.6.0 Beta 2:
                
                Invalid SQL:
                
                	SELECT adminmessage.adminmessageid
                	FROM adminmessage AS adminmessage
                	INNER JOIN adminlog AS adminlog ON (adminlog.script = adminmessage.script AND adminlog.action = adminmessage.action)
                	WHERE adminmessage.status = 'undone'
                		AND adminmessage.script <> ''
                		AND adminlog.dateline > adminmessage.dateline
                	GROUP BY adminmessage.adminmessageid;
                
                MySQL Error  : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
                Error Number : 1267
                Date         : Sunday, June 18th 2006 @ 02:28:44 AM
                Script       : http://www.vbulletin.it/forums/admincp/index.php?do=home
                Referrer     : http://www.vbulletin.it/forums/admincp/index.php?do=nav
                IP Address   : 81.174.32.193
                Username     : Sergio
                Classname    : vb_database
                But adminlog and adminmessage are latin1, not UTF8 I just altered both.
                Italian Body Building & Fitness : www.BodyWeb.com
                Italian unofficial support Forum : www.vBulletin.it

                Comment


                • #9
                  Freddie posted in another thread about this, you can send him a PM I believe and he will look into it. You can find his profile by going to the www.vbulletin.com/forum/showgroups.php page

                  Comment


                  • #10
                    Ok, thx, I hope they do not answer me "Hey this is not 3.6 forum"
                    Italian Body Building & Fitness : www.BodyWeb.com
                    Italian unofficial support Forum : www.vBulletin.it

                    Comment


                    • #11
                      You need to set the collation for the database tables and also for the database rows.
                      Best Regards
                      Colin Frei

                      Please don't contact me per PM.

                      Comment


                      • #12
                        Originally posted by Colin F View Post
                        You need to set the collation for the database tables and also for the database rows.
                        Ok, so once I set that I must use one collation OR the other but not both, that's my problem, my DB seems mixed up.
                        Italian Body Building & Fitness : www.BodyWeb.com
                        Italian unofficial support Forum : www.vBulletin.it

                        Comment


                        • #13
                          Exactly, it can't compare values if they're not encoded using the same method.
                          Best Regards
                          Colin Frei

                          Please don't contact me per PM.

                          Comment


                          • #14
                            Ok, thx, now it's clear.
                            That's bad, I hope I do not damage anything by altering all the tables.
                            Italian Body Building & Fitness : www.BodyWeb.com
                            Italian unofficial support Forum : www.vBulletin.it

                            Comment

                            Loading...
                            Working...
                            X