Error install EasyDiscuss RC
By adrian on Monday, 18 April 2016
Posted in Installation Issues
Likes 0
Views 1.1K
Votes 0
Hello guys,

I got this error when install EasyDiscuss RC

1054 Unknown column 'cluster_id' in 'where clause' SQL=SELECT COUNT(1) FROM `#__discuss_posts` WHERE `category_id` IN ('1') AND `parent_id`='0' AND `published`='1'AND `cluster_id`='0'

Need help

Regards!
Hi Adrian,

Regarding this issue, did you upgrade from previous ED 4 alpha / beta? If yes, you will need to uninstall your ED 4 alpha / beta and remove the EasyDiscuss tables and then re-install the ED 4 RC. Or, you can run below sql for the quick fix:



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

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

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

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


Replace jos_ to your Joomla table prefix. Let me know if the above fix your issue or not

Also, for any issues / bugs that you've encountered with EasyDiscuss 4.0 RC, please submit your issue at http://stackideas.com/issues/easydiscuss so that we can follow up your issues faster

Thanks again for testing EasyDiscuss 4.0 RC
Sam
·
Monday, 18 April 2016 10:34
·
0 Likes
·
0 Votes
·
0 Comments
·
I am sorry for the delay of this reply,

Can you run this following sql queries into your database?



// replace your table prefix #__

ALTER TABLE `#__discuss_posts` ADD `cluster_id` int(11) NOT NULL DEFAULT '0';


If the installation still not work, can you provide us with your phpmyadmin access?
Arlex Wong
·
Monday, 18 April 2016 10:30
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks Sam! Had the same problem (I have been using the beta and RC).

Your 4 SQL statements solved it! (Had to change the "jos" prefix to my Joomla database prefix.)
Torgrim Sandvoll
·
Wednesday, 27 April 2016 03:03
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

You are most welcome. Glad to hear that your issue has been resolved now.

As a gentle reminder, kindly start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiry. I will lock and mark this thread as resolved.
Arlex Wong
·
Wednesday, 27 April 2016 11:24
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post