Skip to Content Skip to Menu

🌟 CB Editor Assistant 1.0.0 is here! Discover our new AI Joomla Plugin that wrote its story! (and this banner!)
Start at just $12.50/month* or 💸 save 30% with our 🛍️ Intro Black Friday Offer for a lifetime*
Grab It Now!

Open groups - content only appearing in Newsfeed when a user joined it.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48551
  • Thanks: 8291
  • Karma: 1445
5 years 1 month ago #314902 by krileon
Replied by krileon on topic Open groups - content only appearing in Newsfeed when a user joined it.

I now have thousands of groups that have been joined already. How can I add it retrospectively that the people who joined a group also automatically follow it?

A custom database query could take care of that quickly, yes. Below for example should work.

Code:
INSERT IGNORE INTO `jos_comprofiler_plugin_activity_following` ( `user_id`, `asset`, `date` ) SELECT `user_id`, CONCAT( 'groupjive.group.', `group`, `date` ) FROM `jos_groupjive_users`

Be sure to replace jos_ table prefix in both tables with whatever your table prefix is.

Btw I would make this a system action as I am sure not the only one who has this problem.

Auto follow on join would be a good system action. Have added a feature ticket to implement.

forge.joomlapolis.com/issues/7747

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

  • timstohr
  • timstohr
  • OFFLINE
  • Posts: 1091
  • Thanks: 56
  • Karma: 9
5 years 1 month ago #314910 by timstohr
Replied by timstohr on topic Open groups - content only appearing in Newsfeed when a user joined it.
Hi
Unfortunately that query does not work...

SQL query: Documentation

INSERT IGNORE INTO `nuernberg_comprofiler_plugin_activity_following` ( `user_id`, `asset`, `date` ) SELECT `user_id`, CONCAT( 'groupjive.group.', `group`, `date` ) FROM `nuernberg_groupjive_users`

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1

What does that mean?

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48551
  • Thanks: 8291
  • Karma: 1445
5 years 1 month ago #314914 by krileon
Replied by krileon on topic Open groups - content only appearing in Newsfeed when a user joined it.
Oops, I put the date inside the concat. The below should work.

Code:
INSERT IGNORE INTO `jos_comprofiler_plugin_activity_following` ( `user_id`, `asset`, `date` ) SELECT `user_id`, CONCAT( 'groupjive.group.', `group` ), `date` FROM `jos_groupjive_users`

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

  • timstohr
  • timstohr
  • OFFLINE
  • Posts: 1091
  • Thanks: 56
  • Karma: 9
5 years 1 month ago #314917 by timstohr
Replied by timstohr on topic Open groups - content only appearing in Newsfeed when a user joined it.
Hi yeah the SQL Query worked perfectly... There is something that does not work with the asset FOLLOWONLY. It now shows me stuff that I have done and not only the stuff that I am following...

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48551
  • Thanks: 8291
  • Karma: 1445
5 years 1 month ago #314941 by krileon
Replied by krileon on topic Open groups - content only appearing in Newsfeed when a user joined it.
That was a known and fixed bug. Ensure you've the latest CB Activity build installed. It was fixed late last week.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

  • timstohr
  • timstohr
  • OFFLINE
  • Posts: 1091
  • Thanks: 56
  • Karma: 9
5 years 1 month ago #314998 by timstohr
Replied by timstohr on topic Open groups - content only appearing in Newsfeed when a user joined it.
True, it is fixed now. Just found another "bug" or "missing feature"... I have it set so that the activity shows the assets followingonly and mainforum (mainforum is what the people post directly in the activity feed). If I post now inside the main forum, the tooltip visible on the left (the three dot menu on the activity post) shows "Unfollow post" on my own mainforum asset post...
I can't unfollow my own posts...

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon
Powered by Kunena Forum