Question database error after upgrading vbulletin from forum to suite

[kamranmed]

hi
i just upgrade my vbulletin from forum to Vbulletin suite
so i have blog now
but button in the blog not work and get this error in a message:

<p>Database Error</p>

i think this is becouse plugin not create blog tables before,
so what should i do?
can i create them manualy?

 

[Fillip H.]

Please post the full error message.

 

[kamranmed]

thats all
nothing store in error_log

this is what happen
1- i have vbulletin "forum" before
2- i install thanks and like plugin
3- four days ago i upgrade from "vbulletin forum" to "vbulletin suite"
4- then buttons not work in "blog" and show this message
i think this is becouse plugin not create database tables for "blog" before it installed before i have blog features

 

[Fillip H.]

Please make sure that, in config.php, your "technicalemail" field is filled out with your email address, then generate the database error again. You will receive an email with the complete error message.

 

[kamranmed]

oh im sorry

Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT
blog_text.title AS posttitle,
blog.title AS threadtitle,
blog_text.blogtextid AS postid,
blog_text.userid,
blog_text.dbtech_thanks_disabledbuttons,
blog.firstblogtextid AS firstpostid,
blog.dbtech_thanks_disabledbuttons AS disabledbuttons_thread,
user.username,
user.userid,
user.usergroupid,
user.displaygroupid,
user.membergroupids,
user.customtitle
FROM blog_text AS blog_text
LEFT JOIN blog AS blog ON(blog.blogid = blog_text.blogid)
LEFT JOIN user AS user ON(user.userid = blog_text.userid)
WHERE blog_text.blogtextid = '22'
LIMIT 1;

MySQL Error : Unknown column 'blog_text.dbtech_thanks_disabledbuttons' in 'field list'
Error Number : 1054
Request Date : Monday, June 30th 2014 @ 03:53:04 PM
Error Date : Monday, June 30th 2014 @ 03:53:04 PM
Script : ???? ???? / Like - ??? ??? ????| ???????? ???? ?????? ???
Referrer : ????? ??? ?? - ????? ?? - ??? ??? ????| ???????? ???? ?????? ???
IP Address : 37.19.82.169
Username : WinPhoneCenter
Classname : vB_Database
MySQL Version : 5.5.35-cll

 

[Fillip H.]

Ahh, I should have realised.

Run the following queries:

ALTER TABLE blog ADD dbtech_thanks_disabledbuttons INT(10) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE blog_text ADD dbtech_thanks_disabledbuttons INT(10) UNSIGNED NOT NULL DEFAULT '0'

 

[kamranmed]

problem resolved
thanks Fillip H.

 

[EasyEasy]

Searched for this after an upgrade to the Pro Version

Thanks Fillip H.