Error Message when attempting to access Default Settings

[texasasl]

I am getting this error message trying to access the vba default settings (after upgrading to vbulletin 3.6.0. and vba CMPS v2.x)

Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT varname, text FROM prvb_phrase WHERE phrasetypeid = 5000 ORDER BY languageid ASC;

MySQL Error : Unknown column 'phrasetypeid' in 'where clause'
Error Number : 1054
Date : Thursday, September 7th 2006 @ 08:11:34 PM
Script : http://www.phoenix-radio.gr/admincp/...modifysettings
Referrer : http://www.phoenix-radio.gr/admincp/index.php?do=nav

Does anybody can help???

[Zachery]

You need to Run vBa CMPS 2.2 and make sure the 2.2 files are uploaded. vBa 2.1 or lower will not run in vBulletin.

[texasasl]

But I have already downloaded and installed vBa 2.2.0 according the instructions, as a free installation.
Can you please tell me whether or not that affects the installation or do I have to buy the branding free ????
Thank you anyway Zachery.

[Zachery]

Hello,

Its not possible for you to get that error message with the 2.2 files, there is not one single query in any of the 2.2 files that refrence phrasetypeid.

[Delw]

Zach I had the same problem after installing the version for 3.5, I overwrote twice with the new files(for 3.6), everything work except this problem.
I over wrote again still had the problem.
then I went file by file and found out my ftp didnt send over the file in the includes/xml/cpnav_vbacmps.xml
uploaded that file and it worked fine.
I am using Ws_FTP le and have had problems with not over writing files, or even sending all files and dirs in the past. so now I double check.

Delw

[smoknz28]

Same problem I had.....

Delw, thanks for directing me on this one.....the same thing happened and I did exactly what you stated in this last post.

Thanks buddy.

[halpern]

I have the same problem when trying to access "Default Settings". I am running Vbulleting 3.6.1 and the newest Vbadvanced. Any support on this? There is obviously a problem. Thanks.

[tandy]

Database error in vBulletin 3.6.2:

Invalid SQL:
SELECT varname, text FROM phrase WHERE phrasetypeid = 5000 ORDER BY languageid ASC;

MySQL Error : Unknown column 'phrasetypeid' in 'where clause'
Error Number : 1054
Date : Sunday, October 22nd 2006 @ 03:37:52 AM
Script : http://xxxxx.com/admincp/vba_cmps_ad...modifysettings
Referrer : http://xxxx.com/admincp/index.php?do=nav

[Brian]

You're running the vBulletin 3.5 version on a 3.6 forum. You need to download the version marked for 3.6 from here and upgrade to that.

[Markowitch]

Just upgraded vbAdvanced on my 3.6.2 forum and it works. However, in admincp I can't access any items in the "vBa CMPS" menu. If I press e.g. "Default Settings" it prints "No input file specified." in the frame.

I did upload all the vbAdvanced files and used the upgrade option in the vbAdvanced installer.

The url for the "Default Settings" is:
http://www.xxxx.xx/.../admincp/vba_c...modifysettings

[Brian]

Have you tried re-uploading the files, and making sure that they were uploaded in ASCII mode?

[Markowitch]

Originally Posted by Brian

Have you tried re-uploading the files, and making sure that they were uploaded in ASCII mode?

Thanx for the very speedy reply Brian

I have figured out what went wrong. After the successful upgrade I deleted the vbacmps_admin.php file instead of vbacmps_install.php. So it was just me deleting the wrong file. Now everything works perfect

[Brian]

Ahhh... I knew it had to be something along the lines of a missing/corrupted/deleted file. Glad you got it worked out though.