What does this error mean

[Website Rob]

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.

[Steve Machol]

<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.

[BadGuy]

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 ?

[Steve Machol]

You would need to do this manually with phpMyAdmin.

[BadGuy]

This my error

Database error in vBulletin 3.0.3:
 
Invalid SQL: 
SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount
FROM forum AS forum
 
mysql error: Unknown column 'lastthreadid' in 'field list'
mysql error number: 1054 

[Steve Machol]

You need to add that column manually.

[BadGuy]

error !!

[Scott MacVicar]

That looks like access sql.

Try
ALTER TABLE forum ADD lastthreadid INT UNSIGNED NOT NULL

[BadGuy]

everything is working fine now

Thank you,
BadGuy

[FindSP.com]

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'

[Steve Machol]

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.