Announcement

Collapse
No announcement yet.

What does this error mean

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

  • What does this error mean

    Database error in vBulletin 3.0.0:

    Invalid SQL: SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount

    FROM forum AS forum

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

    mysql error number: 1054

    --------------------------------------------------
    Ok, so that is the error msg. Not being familiar with mySQL (4.0.18 btw) I have attempted to run: REPAIR TABLE forum;

    Admin CP -> Import & Maintenance -> Execute SQL Query
    and from within phpMyAdmin itself -- to no avail.

    I presume "Unknown column 'lastthread' in 'field list'" cannot be fixed because it first needs to inserted. Using Steve's info within phpMyAdmin is a bit confusing (for me) as it states:

    Create new table on database 'dbname_I_leftout' :
    Name : lastthread << I entered
    Fields : lastthreadid << I entered

    And JS popup error msg. stated it was not a number -- which one is it?


    The above error is from first time attempt at using Forum after upgrading from v2 to v3. This is my first attempt at doing the upgrade and no 'vBulletin Options' have yet been set or altered.

  • #2
    <Split from original thread becaue this is a different issue>

    This error means that one or more of the upgrade steps were skipped and this field was not added to the forum table:

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

    If this is the only thing missing (which is unlikely) you can manually add this field to the forum table:

    field: lastthread
    type: char(250)
    attributes: <blank>
    Null: No
    Default: <blank>

    If you run into further erros like this, then the best thing to do is to restore the db backup you made prior to upgrading and try again.
    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
      Originally posted by Steve Machol

      you can manually add this field to the forum table:

      field: lastthread
      type: char(250)
      attributes: <blank>
      Null: No
      Default: <blank>
      how do that ?

      how add this field to the forum table ?

      Comment


      • #4
        You would need to do this manually with phpMyAdmin.
        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
          This my error

          PHP Code:
          Database error in vBulletin 3.0.3:
           
          Invalid SQL
          SELECT forum.forumidlastpostlastposterlastthreadlastthreadidlasticonidthreadcountreplycount
          FROM forum 
          AS forum
           
          mysql error
          Unknown column 'lastthreadid' in 'field list'
          mysql error number1054 

          Comment


          • #6
            You need to add that column manually.
            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


            • #7
              error !!
              Attached Files

              Comment


              • #8
                That looks like access sql.

                Try
                ALTER TABLE forum ADD lastthreadid INT UNSIGNED NOT NULL
                Scott MacVicar

                My Blog | Twitter

                Comment


                • #9
                  everything is working fine now

                  Thank you,
                  BadGuy

                  Comment


                  • #10
                    I tried to do the same because I had the same error and here is what I got:

                    Error

                    SQL-query :

                    ALTER TABLE forum ADD lastthreadid INT UNSIGNED NOT NULL

                    MySQL said:


                    #1060 - Duplicate column name 'lastthreadid'
                    Forex Trading

                    Comment


                    • #11
                      FindSP.com, please start your own thread with all the relevant details about your specific problem. You obviously already had this column so it was not necessary to add it again.
                      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

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