Announcement

Collapse
No announcement yet.

mysql error: Unknown column 'passworddate' in 'field list'

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

  • mysql error: Unknown column 'passworddate' in 'field list'

    Upgrading from 2.2.9

    Database error in vBulletin 3.0.0 Release Candidate 4:
    Invalid SQL:

    PHP Code:
    SELECT administrator.*, 
     
    userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
     
    IF(
    displaygroupid=0user.usergroupiddisplaygroupid) AS displaygroupid,
     
    language.phrasegroup_cphome AS phrasegroup_cphome,
     
    language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
     
    language.phrasegroup_global AS phrasegroup_global,
     
    language.options AS lang_options,
     
    language.languagecode AS lang_code,
     
    language.charset AS lang_charset,
     
    language.locale AS lang_locale,
     
    language.imagesoverride AS lang_imagesoverride,
     
    language.dateoverride AS lang_dateoverride,
     
    language.timeoverride AS lang_timeoverride,
     
    language.registereddateoverride AS lang_registereddateoverride,
     
    language.calformat1override AS lang_calformat1override,
     
    language.calformat2override AS lang_calformat2override,
     
    language.logdateoverride AS lang_logdateoverride,
     
    language.decimalsep AS lang_decimalsep,
     
    language.thousandsep AS lang_thousandsep
     
    FROM user 
    AS user
     
    INNER JOIN userfield 
    AS userfield ON (user.userid userfield.userid)
     
    INNER JOIN usertextfield AS usertextfield ON (usertextfield.userid user.useridLEFT JOIN administrator AS administrator ON (administrator.userid user.useridINNER JOIN language AS language ON (language.languageid = IF(user.languageid 01user.languageid)) 
     
    WHERE user.userid 

    mysql error: Unknown column 'passworddate' in 'field list'

    mysql error number: 1054

    Date: Wednesday 11th of February 2004 11:29:06 PM

    Script:
    http://www.7thgencivicdev.com/forums/admincp/index.php

    Referer: http://www.7thgencivicdev.com/forums/install/install.php?step=2

  • #2
    You shouldn't be running install.php. You need to run upgrade.php.
    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
      i am. in install step 2 it asks u to upgrade, that is where i clcik upgrade. either way, i get the error.

      This didn't happen the first time i upgraded.

      Comment


      • #4
        Then post the error you get when you run upgrade.php. The one above is from install.php, which you shouldn't be running at all. Hopefully it did not make any changes to the database which could prevent the upgrade from being successful.
        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


        • #5
          I have no idea why it goes to admincp
          Code:
           
          Database error in vBulletin 3.0.0 Release Candidate 4:
           
          Invalid SQL: 
           
          SELECT administrator.*, 
           
          userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
           
          IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
           
          language.phrasegroup_cphome AS phrasegroup_cphome,
           
          language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
           
          language.phrasegroup_global AS phrasegroup_global,
           
          language.options AS lang_options,
           
          language.languagecode AS lang_code,
           
          language.charset AS lang_charset,
           
          language.locale AS lang_locale,
           
          language.imagesoverride AS lang_imagesoverride,
           
          language.dateoverride AS lang_dateoverride,
           
          language.timeoverride AS lang_timeoverride,
           
          language.registereddateoverride AS lang_registereddateoverride,
           
          language.calformat1override AS lang_calformat1override,
           
          language.calformat2override AS lang_calformat2override,
           
          language.logdateoverride AS lang_logdateoverride,
           
          language.decimalsep AS lang_decimalsep,
           
          language.thousandsep AS lang_thousandsep
           
          FROM user AS user
           
          INNER JOIN userfield AS userfield ON (user.userid = userfield.userid)
           
          INNER JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN administrator AS administrator ON (administrator.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 
           
          WHERE user.userid = 2
           
           
           
          mysql error: Unknown column 'passworddate' in 'field list'
           
          mysql error number: 1054
           
          Date: Thursday 12th of February 2004 12:37:25 AM
           
          Script: http://www.7thgencivicdev.com/forums/admincp/index.php
           
          Referer: 
           
           
           
          

          Comment


          • #6
            If we are not supposed to use install.php, why would you give the option?
            Attached Files

            Comment


            • #7
              Because that's a fail safe mesaage in case you run install.php by accident - as you did.

              Also that error doesn't appeear to be from the upgrade script. In order to help I need to know exactly what you've done up to this point, and what you are doing when you get this 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


              • #8
                in wasn't an accident. I did upgrade first. it didn't work, so iwent in that way.

                What i did up to this point.

                uploaded the files
                ran the upgrade

                what i am doing when i get the error? nothing. you can go to the url urself and see.

                Comment


                • #9
                  why do i keep getting bumped to admincp when I go to install/upgrade.php!!

                  Comment


                  • #10
                    Thanks but those details are rather sketchy. Did you make a backup of your database prior to upgrading? If so, my recommendation is to restore the backup and rerun upgrade.php.
                    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


                    • #11
                      thats pretty much all i can provide, cause that's all i did.
                      It's a dev site, so it's not too critical. I will try a restore and see what happens.

                      Comment


                      • #12
                        I am getting this error again now. I am trying to finally upgrade and all i get is this error.
                        it's failling here
                        PHP Code:
                            if ($log['step'] == 0)
                            {
                                
                        // the last entry has step=0, meaning the script completed...
                                
                        $scriptnumber++;
                                if (
                        file_exists("./install/upgrade$scriptnumber.php"))
                                {
                                    
                        // found the next script - link to that
                                    
                        $link "upgrade$scriptnumber.php";
                                }
                                else
                                {
                                    
                        // next script not found - upgrade is complete!
                                    
                        exec_header_redirect("../$admincpdir/index.php");
                                    exit;
                                }
                            } 

                        Comment


                        • #13
                          7thgencivic.com,

                          I had to remove your sig because it was calling an htaccess login box every time someone looks at a thread you posted in.
                          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


                          • #14
                            Are you still getitng the same error? Please post the complete 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


                            • #15
                              ya, sorry bout that.
                              trying to do htaccess redirect instead, but didn't work.

                              what i did to work around it was to to call upgrade.php with step=1 and it bypassed the problem.

                              Comment

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