Problems with blog

[CrashPush]

For some reason the only version of the Blog add-on I can install and use is 1.0.0. No other version works with my vBulletin installation. I get database errors with any other version except 1.0.0.

current version: 3.7.0 Beta 4
versions tried: 3.6.8, 3.7.0 B4 & 3.7.0 B5

[Steve Machol]

I don't have that problem. Do you have any other add-ons installed? What errors are you getting?

[garymill]

I am having similar problems. I have been using 1.0 verison of the blog and was fine, even up to just upgrading to vbulletin 3.70 beta 5.

I just upgraded vblog to the latest version and now will not run.

Error message,


Database error in vBulletin 3.7.0 Beta 5:

Invalid SQL:

SELECT bm.userid, bm.permissions, bm.type, user.username
FROM blog_moderator AS bm
INNER JOIN user AS user USING (userid);

MySQL Error : Unknown column 'bm.type' in 'field list'
Error Number : 1054


Any help is appreciated!

Gary

[Zachery]

Can you please give us the full error message.

[garymill]

These are the emails I am getitng with the error

Database error in vBulletin 3.7.0 Beta 5:

Invalid SQL:

SELECT bm.userid, bm.permissions, bm.type, user.username
FROM blog_moderator AS bm
INNER JOIN user AS user USING (userid);

MySQL Error : Unknown column 'bm.type' in 'field list'
Error Number : 1054
Date : Wednesday, March 5th 2008 @ 08:00:13 AM
Script : http://www.cybermacro.com/forum/members/wonderlandalli.html (http://www.cybermacro.com/forum/members/wonderlandalli.html)
Referrer : http://www.cybermacro.com/forum/members/wonderlandalli.html (http://www.cybermacro.com/forum/members/wonderlandalli.html)
IP Address : 90.156.169.229
Username : Unregistered
Classname : vb_database
MySQL Version :



If I try to access the blog itself, I get

http://www.cybermacro.com/forum/image.php?type=dberrorDatabase errorThe Cybermacro - Macrobiotics + Macrobiotic Food Forum database has encountered a problem.

Was there some specific procedure I needed to follow to upgrade the blog that i did not, do, I could not find any documentation and just uploaded the files.

[Zachery]

Try disabling your vBSEO and all other addons and see if you still have the same problems.