:| Help Me!

[Tharos]

I dont know what happened!
I just was i the university the whole day and now I see that error

Database error in vBulletin 3.0.0 Beta 4:

Invalid SQL:

SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid

FROM forum AS forum;

MySQL Error : Unknown column 'lastthread' in 'field list'
Error Number : 1054
Date : Thursday, April 3rd 2008 @ 04:23:00 PM
Script : http://www.wachos.cl/comunidad/
Referrer :
IP Address : 190.46.40.74
Username : THAROS
Classname : vB_Database

could you help me please??

[Twilkey]

it seems that lastthread doesnt exist in the field list database table. What are you doing that requires a field list table. Is it a mod from this site.

[Tharos]

but could you help me please?
I am a novice on being webmaster so I cant understand that of SQL

[Lynne]

The error is telling you it can't find the column "lastthread" in the "forum" table. I have no idea if that was a standard column back with vbulletin 3.0. Did you perhaps install a hack made for a later version of vbulletin that perhaps changed a query and is causing this error?

edit: scratch that. I don't think you have not given us the full error. Can you copy/paste the FULL mysql query from the error?

[SEOvB]

I think its actually trying to querey the lastthread and it shouldn't be.

Remove any custom modifications, or attempt to run some maintence tools on the DB

[Tharos]

I dont know why my forum is showing as a 3.0.0 because I have the 3.6.8 version :s
Even Today I wanted to upgrade to the 3.6.9 version
And I did not installed any hack :s
I do not know what happened
ANd the complete error is that:


Database error in vBulletin 3.6.0 Beta 2:

Invalid SQL:

SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid

FROM forum AS forum;

MySQL Error : Unknown column 'lastthread' in 'field list'
Error Number : 1054
Date : Thursday, April 3rd 2008 @ 06:17:18 PM
Script : http://www.wachos.cl/comunidad/
Referrer :
IP Address : 190.46.40.74
Username : THAROS
Classname : vB_Database

[Lynne]

This is the only place I can find something like that query:

include/functions.php line 3047:
$counter_select = 'forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid';

It has to do with your forum cache. It gets used in another query that looks like your query on line 3067. I think I would start by reuploading the file. I would probably also do a repair/optimize on my forum table if I knew I had a backup (which I always do).

edit: very weird. Your last error said "3.6.0 Beta 2" and yest you say you are using 3.6.8. Something strange is going on.

[SEOvB]

Originally Posted by Tharos

I dont know why my forum is showing as a 3.0.0 because I have the 3.6.8 version :s
Even Today I wanted to upgrade to the 3.6.9 version
And I did not installed any hack :s
I do not know what happened
ANd the complete error is that:


Database error in vBulletin 3.6.0 Beta 2:

Invalid SQL:

SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid

FROM forum AS forum;

MySQL Error : Unknown column 'lastthread' in 'field list'
Error Number : 1054
Date : Thursday, April 3rd 2008 @ 06:17:18 PM
Script : http://www.wachos.cl/comunidad/
Referrer :
IP Address : 190.46.40.74
Username : THAROS
Classname : vB_Database

If you're going to upgrade, reupload all the 3.6.9 files and run the upgrade.php script, see if the error continues to happen after that.

Good luck

[Tharos]

Ok my dear friend. I am downloading it now
But I don´t know How to upgrade :s
If i have question I´ll do them here

[CHIPIT]

Just upload the files overwriting your old and run yoursite.com/forums/upgrade.php