Announcement

Collapse
No announcement yet.

db error in upgrade

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

  • db error in upgrade

    PHP Code:
    Database error in vBulletin 3.6.7:

    Invalid SQL:

        
    SELECT pf.profilefieldidpf.profilefieldcategoryidpf.requiredpf.typepf.datapf.defpf.height
        FROM profilefield 
    AS pf
        LEFT JOIN profilefieldcategory 
    AS pfc ON(pfc.profilefieldcategoryid pf.profilefieldcategoryid)
        
    WHERE pf.form 
        ORDER BY pfc
    .displayorderpf.displayorder;

    MySQL Error  Unknown column 'pf.profilefieldcategoryid' in 'field list'
    Error Number 1054
    Date         
    FridayJune 20th 2008 @ 08:04:06 PM
    Script       
    http://www.oo.org/forum/member.php?find=lastposter&f=766
    Referrer     
    IP Address   85.238
    Username     

    Classname    vB_Database 
    Help Me Please.. What will do I?

  • #2
    You haven't completed the upgrade.
    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


    • #3
      What Will Do I ?

      Comment


      • #4
        I upgraded again again.where is mistake?

        Comment


        • #5
          Which version does it show in the Admin CP?
          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


          • #6
            vBulletin 3.6.7

            in Plugins & Products..

            Comment


            • #7
              Then you did not upgrade. Which version did you think you were upgrading to?
              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
                I was upgrading 3.6.7 PL1

                Comment


                • #9
                  Upgrade to either 3.6.10 PL2 or 3.7.1 PL2.
                  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


                  • #10
                    OK I Upgrading To 3.610 PL2 Now.. We look..<br>

                    Comment


                    • #11
                      Im upgrading to 3.6.8 but this error didn't change.. Please please heplme please

                      Comment


                      • #12
                        You cannot get that exact same error if you upgraded correctly. What is the new error?
                        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


                        • #13
                          PHP Code:
                          Database error in vBulletin 3.6.10:

                          Invalid SQL:

                                  
                          SELECT pf.profilefieldidpf.profilefieldcategoryidpf.requiredpf.typepf.datapf.defpf.height
                                  FROM profilefield 
                          AS pf
                                  LEFT JOIN profilefieldcategory 
                          AS pfc ON(pfc.profilefieldcategoryid pf.profilefieldcategoryid)
                                  
                          WHERE pf.form 
                                  ORDER BY pfc
                          .displayorderpf.displayorder;

                          MySQL Error  Unknown column 'pf.profilefieldcategoryid' in 'field list'
                          Error Number 1054
                          Date         
                          FridayJune 20th 2008 11:22:49 PM
                          Script       
                          http://www.oo.org/forum/member.php?find=lastposter&f=1051
                          Referrer     http://www.oo.org/forum/index.php
                          IP Address   78.71
                          Username     

                          Classname    vB_Database 

                          I take this error

                          Comment


                          • #14
                            To troubleshoot this, first reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Also be sure to upload the admincp files to whichever directory you have set in your config.php file. Then run 'Suspect File Versions' in Diagnostics to make sure you have all the original files for your version and that none show 'File does not contain expected contents':

                            Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions


                            [Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

                            Next, disable all plugins.

                            Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

                            define('DISABLE_HOOKS', true);

                            Then if you still have this problem, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?
                            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


                            • #15
                              wuow good but this post is english I need turkish because I can't speak good english
                              çevirebilen arkadaşlar varsa türk olarak bekliyorum lütfen..

                              Comment

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