By Johan Mouton on Thursday, 12 May 2016
Posted in General
Likes 0
Views 709
Votes 0
Hi - we updated easydiscuss.

Getting this error:
Unknown Column 'Cc.Anonymous' In 'Field List' SQL=Select SQL_CALC_FOUND_ROWS B.*, A.`Has_polls` As `Polls_cnt`, A.`Num_fav` As `TotalFavourites`, A.`Num_replies`, A.`Num_attachments` As Attachments_cnt, A.`Num_likes` As `LikeCnt`, A.`Sum_totalvote` As `VotedCnt`, A.`Replied` As `Lastupdate`, A.Vote As `Total_vote_cnt`, A.`Last_user_id`, A.`Last_poster_name`, A.`Last_poster_email`, (Select Cc.Anonymous From `#__discuss_posts` As Cc Where Cc.`Thread_id` = A.`Id` And Cc.Created = A.Replied Limit 1) As `Last_user_anonymous`, DATEDIFF('2016-05-12 09:41:25', A.`Created`) As `Noofdays`, DATEDIFF('2016-05-12 09:41:25', A.`Created`) As `Daydiff`, TIMEDIFF('2016-05-12 09:41:25', A.`Created`) As `Timediff`, 0 As `IsVoted`, A.`Post_status`, A.`Post_type`, Pt.`Suffix` AS Post_type_suffix, Pt.`Title` AS `Post_type_title`, E.`Title` AS `Category` From `#__discuss_thread` As A Inner Join `#__discuss_posts` As B On A.Post_id = B.Id LEFT JOIN `#__discuss_post_types` AS Pt ON A.`Post_type`= Pt.`Alias` LEFT JOIN `#__discuss_category` AS E ON A.`Category_id` = E.`Id` WHERE A.`Published` = '1' AND A.`Private` = '0' AND A.`Cluster_id` = '0' AND A.Category_id IN (1,2,3,4,5,6,7,8,9) AND A.`Featured` = '1' ORDER BY A.`Replied` DESC LIMIT 5

Any ideas?

Also, when trying to re-install it hangs.
I am not entirely sure how did you upgraded EasyDiscuss but from the looks of it, it looks like the upgrade was not successful. To fix this, I had to run the following SQL query and re-install EasyDiscuss



As for your domain question, I would suggest that you place your development site into your license. We have recently just found out that over 500 users are abusing our support policy by telling us all their domains are development sites.

Thanks for understanding
·
Thursday, 12 May 2016 18:18
·
0 Likes
·
0 Votes
·
0 Comments
·
Please assign your domain to your license to obtain for support. You can do so by accessing your license area at http://stackideas.com/dashboard . Once you have added the domain, please reply to this thread again.

Even if it is a development / staging site, you will need to enter the domain for the license.
·
Thursday, 12 May 2016 18:06
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark - this is a development space for the site. Can we allocate the main site and development site?
·
Thursday, 12 May 2016 18:12
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark - thank you. Asked the client to register. Will move license to them and add domain for support.
·
Thursday, 12 May 2016 18:30
·
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.
·
Thursday, 12 May 2016 19:22
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post