By The NAF on Monday, 09 May 2016
Posted in General
Replies 7
Likes 0
Views 402
Votes 0
Hi

We're working on an easysocial/easydiscuss setup.

Could you please detail where group and event discussion topics are stored in the database please? If alongside the easydiscuss topics and posts, then how are they differentiated?

I ask as I'm looking at a manual migration of an existing site, and am trying to work out whether assigning event specific discussion threads to the event is better before or after migration.

I'm confident I can do the normal threads to the easydiscuss forum; but the group and event specific threads I'm not sure how to identify in the database as such.

As much detail as possible would be appreciated!
Hi The NAF,

I am sorry for the delay of this reply. The group and events discussion topic was stored in #_social_discussions in the database
·
Monday, 09 May 2016 12:41
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks Muhammad!

Just to check, am I seeing correctly that the new easydiscuss app for easysocial is creating them in the discuss_posts table... is that right? So the old and new apps are storing them separately.

Actually I prefer the old app, except that the new one says in the stream update which group the topic is posted in, whereas the old one just says that it's a comment.
·
Monday, 09 May 2016 14:01
·
0 Likes
·
0 Votes
·
0 Comments
·
We actually use the column `cluster_id` and `cluster_type` in the #__discuss_posts table to distinguish between a normal discussion post and a group post.
·
Monday, 09 May 2016 16:50
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks Mark, I can see those columns now. Also I can see the opening posts duplicated in the _thread table.

So in practice, to change a topic to a group, I just add the information to those two fields in both the _thread table and the _posts table? Anywhere else?

When inserting threads directly in sql, assuming I have only one user and one category, are these the only two tables I need to reference?

Really wish you had a phpbb importer for easydiscuss and/or could change the group or event assignment for topics in the back end!
·
Monday, 09 May 2016 17:04
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey there,

Firstly, before I am able to assist you with these questions:

1. Please set a domain for your licenses at http://stackideas.com/dashboard

2. It looks like your account doesn't have a valid subscription for the EasyDiscuss group app. Am I missing anything here?
·
Monday, 09 May 2016 18:50
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark

1) I've got a staging site with the components on at the moment, if I set that domain as the support account can I change it later to the production domain? Just want to make sure I don't tie support in to a domain I know will change later...!

2) What do you mean? We have the full professional bundle for ES/ED/EB/Kommento. I'm not aware of a separate subscription for your apps...?
·
Thursday, 12 May 2016 08:02
·
0 Likes
·
0 Votes
·
0 Comments
·
1) I've got a staging site with the components on at the moment, if I set that domain as the support account can I change it later to the production domain? Just want to make sure I don't tie support in to a domain I know will change later...!

Currently when you request for support, you have to put your site domain on your license area.
In your case, you can put your staging site domain on your license area and if your site already uploaded to live, and you would like to change your current support domain to your live site domain, you can contact us to change if everything look good.

2) What do you mean? We have the full professional bundle for ES/ED/EB/Kommento. I'm not aware of a separate subscription for your apps...?

Yes, if you are referring the Easydiscuss group app, it will separate with your current license subscription.
·
Thursday, 12 May 2016 19:21
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post