Group file name in database
By Bruce Dill on Thursday, 26 July 2018
Posted in Technical Issues
Replies 5
Likes 0
Views 504
Votes 0
I want to make direct input to files related to groups. What are the table names related to groups in the database i.e "Group Name", "Permalink", "Description", "Category", and the name of the field where posts are stored.

If you can direct me to any documentation, etc. I would appreciate it.

Thank you so much for your help.

Bruce
Hi Bruce,

The table name for it is social_clusters, group name is under title column, permalink under alias , description under description and category under category_id eg: http://take.ms/GRV2P
Muhammad Fadhli
·
Thursday, 26 July 2018 11:54
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you for the information.

I must ask forgiveness because I didn't include something.

If someone makes a post to the group, where is the post stored in the database?

Also, the link you attached isn't working.
Bruce Dill
·
Thursday, 26 July 2018 18:01
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Bruce,

Sorry about the screenshot, seems like there issue with monosnap today Here another screenshot for that: https://www.screencast.com/t/Ex3Jn2iTUiE3

If someone makes a post to the group, where is the post stored in the database?

It is stored in both social_stream interrelated with social_stream_item table
Muhammad Fadhli
·
Thursday, 26 July 2018 19:13
·
0 Likes
·
0 Votes
·
0 Comments
·
I'm sorry. I understand the "Group" setup and thank you for helping me.

Now I need to know where the data is saved if someone shares something in that group page. See Attached
Bruce Dill
·
Thursday, 26 July 2018 20:49
·
0 Likes
·
0 Votes
·
0 Comments
·
Once you added a new story stream in Easysocial, it will store in these following table :

- #__social_stream
- #__social_stream_item

I would suggest that you have to try add a new story stream on your site then check for that new stream data from your database, so you will probably know what value you should add.

Hope this will help.
Arlex Wong
·
Friday, 27 July 2018 11:36
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post