:| 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]

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

[Tharos]

I?m doing a backup,..... then i just have to replace all files?????? :o
all???

[SEOvB]

its actually yoursite.com/forums/install/upgrade.php but we're not being picky today :D

1. Upload all 3.6.9 files overwritting all old files
2. Navigate to yoursite.com/forums/install/upgrade.php
3. Enter customer number
4. Verify in the top right corner everything says 3.6.9
5. Keep clicking Next
6. Delete install.php file from the /install folder
7. Enjoy 3.6.9

[Tharos]

FRDS YOU ARE A HERO
I will do it and then I will tell you
I finished my backup so I will start now

[CHIPIT]

its actually yoursite.com/forums/install/upgrade.php but we're not being picky today :D

Whoops :rolleyes:

[Marco van Herwaarden]

Please open a Support Ticket regarding this issue. It looks like the database somehow got corrupted and vBulletin thinks it is upgrading from a different version then acutally in use.

[Tharos]

I tried to upgrade but this error appeared to me :(

Step 1) Create New vBulletin 3 Tables

* Creating calendar table
http://wachos.cl/comunidad/image.php?type=dberror Database error
The =(_ WACH@S _)= database has encountered a problem.




-----------------------------

Database error in vBulletin 3.6.0 Beta 2:

Invalid SQL:

CREATE TABLE calendar (
calendarid int unsigned NOT NULL auto_increment,
title varchar(255) NOT NULL DEFAULT '',
description varchar(100) NOT NULL DEFAULT '',
displayorder smallint NOT NULL DEFAULT '0',
neweventemail varchar(255) NOT NULL DEFAULT '',
moderatenew smallint NOT NULL DEFAULT '0',
startofweek smallint NOT NULL DEFAULT '0',
options int unsigned NOT NULL DEFAULT '0',
cutoff smallint unsigned NOT NULL DEFAULT '0',
eventcount smallint unsigned NOT NULL DEFAULT '0',
birthdaycount smallint unsigned NOT NULL DEFAULT '0',
startyear smallint unsigned NOT NULL DEFAULT '2000',
endyear smallint unsigned NOT NULL DEFAULT '2006',
PRIMARY KEY (calendarid),
KEY displayorder (displayorder)
);

MySQL Error : Table 'calendar' already exists
Error Number : 1050
Date : Sunday, April 6th 2008 @ 11:24:07 AM
Script : http://www.wachos.cl/comunidad/install/upgrade_300b3.php?step=1
Referrer : http://www.wachos.cl/comunidad/install/upgrade_300b3.php?rand=82
IP Address : 200.104.88.220
Username :
Classname : vB_Database











I do not know what to do...
i do not want to lose my users and my 4 months of efforts :(

[Lynne]

You should post this sort of thing over on vb.com., They know what to do about these sort of issues during an upgrade. Or, open a support ticket like Marco suggested.

[Tharos]

i did it but they did not understand me
they just say "try to upgrade 3.6.9 version" ¬¬

but thanks friends, thanks for your help

[Dismounted]

Say you are upgrading then...Explain your situation, and point them to this thread.

[Marco van Herwaarden]

Tell in the ticket that the upgrade process "thinks" it is upgrading from 3.5 (or now 3.6.0) instead of the real version you are upgrading from.

[Tharos]

I will do it firends
thanks Dismounted and Marco Herwaaerden!

then I?ll tell you ;)


I said that to them:


The same error is still appearing =/
I can not upgrade
I replace the files over and over again
and I went to the link "http://www.wachos.cl/comunidad/install/upgrade.php" over and over again too!
But I can not pass over the second step (create new tables)
Because this error appears to me:

Database error in vBulletin 3.6.0 Beta 2:

Invalid SQL:

CREATE TABLE calendar (
calendarid int unsigned NOT NULL auto_increment,
title varchar(255) NOT NULL DEFAULT '',
description varchar(100) NOT NULL DEFAULT '',
displayorder smallint NOT NULL DEFAULT '0',
neweventemail varchar(255) NOT NULL DEFAULT '',
moderatenew smallint NOT NULL DEFAULT '0',
startofweek smallint NOT NULL DEFAULT '0',
options int unsigned NOT NULL DEFAULT '0',
cutoff smallint unsigned NOT NULL DEFAULT '0',
eventcount smallint unsigned NOT NULL DEFAULT '0',
birthdaycount smallint unsigned NOT NULL DEFAULT '0',
startyear smallint unsigned NOT NULL DEFAULT '2000',
endyear smallint unsigned NOT NULL DEFAULT '2006',
PRIMARY KEY (calendarid),
KEY displayorder (displayorder)
);

MySQL Error : Table 'calendar' already exists
Error Number : 1050
Date : Monday, April 7th 2008 @ 06:53:32 PM
Script : http://www.wachos.cl/comunidad/install/upgrade_300b3.php?step=1
Referrer : http://www.wachos.cl/comunidad/install/upgrade_300b3.php?rand=913
IP Address : 200.104.88.176
Username :
Classname : vB_Database






and look by yourself:
1)
http://xs226.xs.to/xs226/08152/step1366.png

2)
http://xs226.xs.to/xs226/08152/step2902.png




THE PROBLEM IS THAT I AM BEING SHOWED WITH A VBULLETIN 3.0.0 BETA AND THEN AS A 3.6.0 AND I HAVE THE 3.6.8 VERSION

I need you to help me!


Greetings from Chile