Unknown column 'phrasetypeid' -ACP error after upgrade.

[Grover]

:( Hmmm.... I upgraded my VB 3.5.4 testboard to VB 3.6.0 Beta1. All seemed to go very well (did not got any error-messages). Until I entered the AdminCP and clicked on 'VBulletin Options'... then I get this error:


Database error in vBulletin 3.6.0 Beta 1:

Invalid SQL:

SELECT varname, text
FROM phrase
WHERE phrasetypeid = PHRASETYPEID_SETTING AND
languageid IN(-1, 0, 1)
ORDER BY languageid ASC;

MySQL Error : Unknown column 'phrasetypeid' in 'where clause'
Error Number : 1054
Date : Monday, June 12th 2006 @ 07:39:23 PM
Script : http: xxx/options.php?null=0
Referrer : http: xxx/index.php?do=nav
IP Address : 62.194.230.41
Username : xxx
Classname : vb_database


This also occurs when I click on 'Search Type' or 'Phrase Manager'. What went wrong?

[Steve Machol]

There is no 'phrasetypeid' field in the 3.6 phrase table. This is from a 3.5.4 file. Reupload all the 3.6 files again.

[Grover]

There is no 'phrasetypeid' field in the 3.6 phrase table. This is from a 3.5.4 file. Reupload all the 3.6 files again.

Wow! Thanks for your very quick reaction, Steve : much appreciated! I will re-upload all the 3.6. files again and see what happens.

[Grover]

Hi Steve,

I re-uploaded all files again and unfortunately I still get the same errors.

I also encountered another one, when I click on 'User Profile Field Manager' I get this one:

Database error in vBulletin 3.6.0 Beta 1:

Invalid SQL:

SELECT profilefieldid, title, type, form, displayorder, IF(required=2, 0, required) AS required, editable, hidden, searchable, memberlist
FROM profilefield;

MySQL Error : Unknown column 'title' in 'field list'
Error Number : 1054
Date : Monday, June 12th 2006 @ 08:09:51 PM
Script : http://xxx/profilefield.php?do=modify
Referrer : http://xxx/index.php?do=nav
IP Address : 62.194.230.41
Username : xxx
Classname : vb_database

[Steve Machol]

I just checked and there is no mention of 'phrasetypeid' anywhere in the 3.6 admincp/options.php file.

Run 'Suspect File Version' in Diagnostics and report back the results.

Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

[Grover]

I just checked and there is no mention of 'phrasetypeid' anywhere in the 3.6 admincp/options.php file.

Run 'Suspect File Version' in Diagnostics and report back the results.

Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

Just minutes ago (during cooking :)) I realized that there was an option in the ACP now to check file versions. I came back to this thread and tada you wrote it down. And the conclusion is..... you were right!

My options file has this version:
options.php 3.5.0 Release Candidate 3

So do a lot of my other files apparently. I don't really understand why? When I upload all files with CuteFTP all seems to go fine actually. :confused: Or maybe it's a wrong assumption of mine. Isn't it better if I delete ALL files on my server (so all old files are deleted) on my testvb directory and upload all files again?

[Steve Machol]

Sometimes FTP clients won't overwrite existing files unless you force them to.

[Grover]

Steve,

I feel like : :o

In the end it occured to me that the problem was : myself...

Yep. You see, I use a renamed admincp directory for security purposes. After uploading all the Beta1 files, a new 'admincp' directory was created, next to my renamed directory. VB's Suspect File Versions uses this renamed directory (with all the old files in it) for it's check. I, myself use this renamed directory (with all the old files in it) when I go to my ACP.

That's the reason why I got those error-messages. I forgot to use the proper directory... (and I have upgraded my software a dozen times before! It must be the very hot weather overhere in Holland....;)).

Sorry!

[Steve Machol]

Yep. You see, I use a renamed admincp directory for security purposes. After uploading all the Beta1 files, a new 'admincp' directory was created, next to my renamed directory.Yep, that's happened to others as well. I usually try to remind people to check this out but sometimes forget.