Error after Easydiscuss Update
By Benjamin Kramer on Saturday, 21 May 2016
Posted in General
Replies 3
Likes 0
Views 742
Votes 0
Hi, after the upgrade to you new version I cannot open Easydiscuss in the Backend and Frontend:

Unknown column 'a.cluster_id' in 'where clause' SQL=select count(1) from `#__discuss_thread` as a where a.`published` = '1' and a.`cluster_id` = '0' and a.`category_id` in (336)

Best regards
Benjamin Kramer
Hey Benjamin,

I am really sorry for the delay of this reply as it is a weekend for us here. It looks like your administration area is password protected and we don't have these details. Can you please edit your post to include these details?
Mark
·
Sunday, 22 May 2016 00:23
·
0 Likes
·
0 Votes
·
0 Comments
·
sorry I forgot. its now the same login credentials
Benjamin Kramer
·
Sunday, 22 May 2016 04:27
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey there,

I am really sorry for the delay of this reply as it is a weekend for us here.

I believe you have install beta version in your site so causing this issue. By the way, I already execute following few sql query in your site, it should work fine now. 



// Note : Replace #__ to your database table prefix



ALTER TABLE `#__discuss_posts` ADD COLUMN `cluster_id` INT(11) NOT NULL default 0;

ALTER TABLE `#__discuss_posts` ADD COLUMN `cluster_type` VARCHAR(255) NULL;

ALTER TABLE `#__discuss_thread` ADD COLUMN `cluster_id` INT(11) NOT NULL default 0;

ALTER TABLE `#__discuss_thread` ADD COLUMN `cluster_type` VARCHAR(255) NULL;
Arlex Wong
·
Sunday, 22 May 2016 12:47
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post