SQL Error in RC4

[UKSTU]

installed a copy of my vB2 upgraded to latest onto my test site.
Ran upgrades to vB3 RC4 everything was working fine, now I get this error

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_holiday AS phrasegroup_holiday,
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) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
WHERE user.userid = XXX

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

mysql error number: 1054

Date: Sunday 15th of February 2004 03:30:39 PM
Script: http://www.XXXXXX/forums/

I cat see where the fault is, I tried the repair.php file as a last resort and I get same error with that

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_sql AS phrasegroup_sql,
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 = XXX

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

mysql error number: 1054

Date: Sunday 15th of February 2004 04:09:04 PM
Script: http://www.XXXXX/forums/admincp/repair.php


Any Ideas where to start ?

[UKSTU]

Tried running the upgrade.php again and I get the same sql error.
also the browser address is changed to /admincp/index for some reason

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 = XXX

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

mysql error number: 1054

Date: Sunday 15th of February 2004 04:32:12 PM
Script: http://www.XXXXXXX/forums/admincp/index.php

[Steve Machol]

You skipped one or more steps in the upgrade process. Restore a backup of the vB2 database, then try again. Make sure you read each page and you complete each step.

[UKSTU]

Hi Steve,
thats a bit of a sweeping statement.
I did not skip any of the steps. The upgrade had 42 steps and each was completed without problems

The forums were installed last night and were working with no problems until this afternoon.

If I missed one of the steps as you suggest, why did it work for over 12 hours ?

maybe you could elaborate what you think I missed, please.

[Steve Machol]

Hi Steve,
thats a bit of a sweeping statement.
I did not skip any of the steps. The upgrade had 42 steps and each was completed without problems

That would appear to be the problem then. The first phase of upgrading from vB2 to vB3 has 42 steps. Then you will need to follow the instructions and run each of the subsequent steps that upgreade through each of the beta and RC versions.

[UKSTU]

Steve,
yes the 42 steps was the initial upgrade then I did follow all the subsequent RC upgrades which had around 9 steps each.
In the end I had RC4 running with no problems.

As I said above I didn't miss out any steps

it was fully working for more than 12 hours then I got the above error

I spent a good two hours trying to trace the problem, to no avail.

Looks like I'm resigned to a re-install. I just dont like re-installing as it doesn't solve the underlying problems.

Thanks

[Steve Machol]

One or more steps were not completed otherwise this field would have been added to the user table:

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

The reason I suggested rerunning the upgrade is because the step that creates this should give you some sort of an error message which will help troubleshoot why this isn't updating like it should. Specifically this query is executed in upgrade1.php and requires the db user have ALTER permissions.

[UKSTU]

Steve,
I can see why you are stating that, but I didn't receive an error messages during install.
I dont understand it myself.

would the forums work without that field? (boards were working perfectly for over 12 hours!!)

[Steve Machol]

No, unfortunately you will continue to get errors with that field missing.

[UKSTU]

sorry Steve,
you mis-understood, I was asking if the boards would work with that field missing as the boards were working for 12+ hours. So if it was never added in the first place (missed step) then surely the boards would not have worked. So as the boards were working, I can only assume that something happened to cause this fault! That is what I was looking for, the underlying cause.

It's all academic now as I've re-installed, but thanks for your input, much appreciated.

[UKSTU]

guess I spoke too soon,
seems the same problem has occured again.

I dropped all the tables,
restored the vB2 backup
uploaded vB3 files again
Ran vB3 upgrade script (42 steps, Betas and RC's) no errors encountered
RC4 working no problems since yesterday.
now no longer working and I'm getting the same error as post 1

[Steve Machol]

Hmmm...this is a mystery to me. If that field was not added during the upgrade then I would expect you would get errors almost immediately. Since you didn't this means that either the field was deleted later, or there is something wrong with the database.

PM me with your Admin CP and phpMyAdmin login info. be sure to include a link to this thread so I knwo what it's about.