Social Groups for XenForo 1.x [Deleted]

[naia]

Also, if a group's forum is deleted. The group cannot be deleted. I deleted a forum in the ACP when testing. Please provide an update to fix this.

 

[Snog]

@Snog
There are a lot of bugs that I think you should fix.

• Category is lower-case on group creation page. This looks bad.
• A ton of undefined-offset server errors are generated

With all due respect, I paid 50$ for this addon. Please fix this.

What are you talking about about the category being lower case? Categories are displayed as they are created, so if they are lower case when you create them, then they will be lower case when they are displayed.

And what offset errors? You are the first person to mention this and if you can't supply the errors, I can't fix them.

 

[Snog]

Also, if a group's forum is deleted. The group cannot be deleted. I deleted a forum in the ACP when testing. Please provide an update to fix this.

From the README.txt file...

* DELETING GROUPS *
-------------------
When deleting groups from your site, if you don't want to keep a group's forums you MUST delete the group forums
BEFORE deleting the group using the admin options in owner tools.

EDIT: As it turns out, the errors that you were getting (that you supplied via PC) were caused by not following this note from the README.txt file.

 

[Snog]

For everyone's benefit...

One thing I pride myself on is acting quickly to fix bugs in my add-ons. If an error is provided, and the error is from one of my add-ons I usually drop everything I'm doing and concentrate on fixing the error.

If someone says that there are a ton of errors, that is not helpful to anyone. I need to see the errors from the XF error log to establish what the problem is. It could be a compatibility problem with other add-ons. Which I then locate and fix the problem if it's on my end, or I contact the author and we resolve the problem together.

Without two way communication between add-on owners and myself, there is no way to locate and fix problems that don't exist on my site, or on my development server. I need input from the owners to be able to duplicate any errors found.

 

[au lait]

Query very slow

SELECT user.*
,
user_profile.*,
user_option.*,
user_privacy.*,snog_socialgroups.socialgroups,snog_socialgroups.groupmoderator,snog_pendinggroups.pendinggroups
FROM xf_user AS user

LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = user.user_id)
LEFT JOIN xf_user_option AS user_option ON
(user_option.user_id = user.user_id)
LEFT JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = user.user_id)
LEFT JOIN xf_snog_socialgroup_members AS snog_socialgroups ON
(snog_socialgroups.user_id = user.user_id)
LEFT JOIN xf_snog_socialgroup_members_pending AS snog_pendinggroups ON
(snog_pendinggroups.user_id = user.user_id)
WHERE (user.is_banned = 0)
ORDER BY user.xengallery_album_count DESC
LIMIT 20
Run Time: 3.842999

Disable this addon:

SELECT user.*
,
user_profile.*,
user_option.*,
user_privacy.*
FROM xf_user AS user

LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = user.user_id)
LEFT JOIN xf_user_option AS user_option ON
(user_option.user_id = user.user_id)
LEFT JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = user.user_id)
WHERE (user.is_banned = 0)
ORDER BY user.xengallery_album_count DESC
LIMIT 20
Run Time: 0.001459

Please optimize this




Edit and more with the addon:

SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
GREATEST(COALESCE(thread_read.thread_read_date, 0), COALESCE(forum_read.forum_read_date, 0), 1433151835) AS thread_read_date,
IF(thread_watch.user_id IS NULL, 0,
IF(thread_watch.email_subscribe, 'watch_email', 'watch_no_email')) AS thread_is_watched,
thread_user_post.post_count AS user_post_count,
permission.cache_value AS node_permission_cache,
snog_nodeinfo.snog_parent_group_id,
if(snog_nodeinfo.snog_parent_group_id = 0, snog_socialgroup.groupid,snog_privategroup.groupid) AS groupid,
if(snog_nodeinfo.snog_parent_group_id = 0,snog_socialgroup.owner_id,snog_privategroup.owner_id) AS owner_id,
if(snog_nodeinfo.snog_parent_group_id = 0,snog_socialgroup.name,snog_privategroup.name) AS name,
if(snog_nodeinfo.snog_parent_group_id = 0,snog_socialgroup.privategroup,snog_privategroup.privategroup) AS privategroup,
if(snog_nodeinfo.snog_parent_group_id = 0,snog_socialgroup.privatehide,snog_privategroup.privatehide) AS privatehide,
if(snog_nodeinfo.snog_parent_group_id = 0,snog_socialgroup.hasdiscussion,snog_privategroup.hasdiscussion) AS hasdiscussion,
if(snog_nodeinfo.snog_parent_group_id = 0,snog_socialgroup.hasforum,snog_privategroup.hasforum) AS hasforum,
if(snog_nodeinfo.snog_parent_group_id = 0,snog_socialgroup.hasalbum,snog_privategroup.hasalbum) AS hasalbum,
if(snog_nodeinfo.snog_parent_group_id = 0,snog_socialgroup.albumview,snog_privategroup.albumview) AS albummview,
if(snog_nodeinfo.snog_parent_group_id = 0,snog_socialgroup.discussionview,snog_privategroup.discussionview) AS discussionview,
if(snog_nodeinfo.snog_parent_group_id = 0,snog_socialgroup.postview,snog_privategroup.postview) AS postview,
if(snog_nodeinfo.snog_parent_group_id = 0,snog_socialgroup.groupavatar,snog_privategroup.groupavatar) AS groupavatar,
if(snog_nodeinfo.snog_parent_group_id = 0,snog_socialgroup.groupbanner,snog_privategroup.groupbanner) AS groupbanner,
if(snog_nodeinfo.snog_parent_group_id = 0,snog_socialgroup.category_id,snog_privategroup.category_id) AS category_id,
if(snog_nodeinfo.snog_parent_group_id = 0,snog_socialgroup.album_id,snog_privategroup.album_id) AS album_id
FROM xf_thread AS thread

LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_thread_read AS thread_read ON
(thread_read.thread_id = thread.thread_id
AND thread_read.user_id = 230451)
LEFT JOIN xf_forum_read AS forum_read ON
(forum_read.node_id = thread.node_id
AND forum_read.user_id = 230451)
LEFT JOIN xf_thread_watch AS thread_watch
ON (thread_watch.thread_id = thread.thread_id
AND thread_watch.user_id = 230451)
LEFT JOIN xf_thread_user_post AS thread_user_post
ON (thread_user_post.thread_id = thread.thread_id
AND thread_user_post.user_id = 230451)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 26
AND permission.content_type = 'node'
AND permission.content_id = thread.node_id)
LEFT JOIN xf_node AS snog_nodeinfo ON
(snog_nodeinfo.node_id = thread.node_id)
LEFT JOIN xf_snog_socialgroup AS snog_socialgroup ON
(snog_socialgroup.node_id = thread.node_id AND snog_nodeinfo.snog_parent_group_id = 0)
LEFT JOIN xf_snog_socialgroup AS snog_privategroup ON
(snog_privategroup.groupid = snog_nodeinfo.snog_parent_group_id AND snog_nodeinfo.snog_parent_group_id > 0)
WHERE (thread.discussion_state IN ('visible')) AND (thread.last_post_date > 1425375835) AND thread.node_id IN ('77', '47', '74', '9', '90', '118', '10', '7', '4', '14', '11', '20', '21', '79', '22', '24', '25', '65', '30', '6', '105', '18', '102', '100', '16', '89', '142', '122', '136', '82', '42', '86', '134', '133', '135', '143', '147', '148', '126', '124', '91', '92', '121', '8', '15', '138', '26', '19', '13', '70', '17', '52', '48', '51', '50', '98', '54', '108', '76', '45', '46', '53', '28', '29', '56', '60', '57', '59', '61', '66', '58', '113', '112', '114', '115', '27', '85', '145', '93', '127', '155', '97', '141', '80')
ORDER BY thread.last_post_date DESC
LIMIT 20
Run Time: 1.547975

without:

SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
GREATEST(COALESCE(thread_read.thread_read_date, 0), COALESCE(forum_read.forum_read_date, 0), 1433152021) AS thread_read_date,
IF(thread_watch.user_id IS NULL, 0,
IF(thread_watch.email_subscribe, 'watch_email', 'watch_no_email')) AS thread_is_watched,
thread_user_post.post_count AS user_post_count,
permission.cache_value AS node_permission_cache
FROM xf_thread AS thread

LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_thread_read AS thread_read ON
(thread_read.thread_id = thread.thread_id
AND thread_read.user_id = 230451)
LEFT JOIN xf_forum_read AS forum_read ON
(forum_read.node_id = thread.node_id
AND forum_read.user_id = 230451)
LEFT JOIN xf_thread_watch AS thread_watch
ON (thread_watch.thread_id = thread.thread_id
AND thread_watch.user_id = 230451)
LEFT JOIN xf_thread_user_post AS thread_user_post
ON (thread_user_post.thread_id = thread.thread_id
AND thread_user_post.user_id = 230451)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 26
AND permission.content_type = 'node'
AND permission.content_id = thread.node_id)
WHERE (thread.discussion_state IN ('visible')) AND (thread.last_post_date > 1425376021) AND thread.node_id IN ('77', '47', '74', '9', '90', '118', '10', '7', '4', '14', '11', '20', '21', '79', '22', '24', '25', '65', '30', '6', '105', '18', '102', '100', '16', '89', '142', '122', '136', '82', '42', '86', '134', '133', '135', '143', '147', '148', '126', '124', '91', '92', '121', '8', '15', '138', '26', '19', '13', '70', '17', '52', '48', '51', '50', '98', '54', '108', '76', '45', '46', '53', '28', '29', '56', '60', '57', '59', '61', '66', '58', '113', '112', '114', '115', '27', '85', '145', '93', '127', '155', '97', '141', '80')
ORDER BY thread.last_post_date DESC
LIMIT 20
Run Time: 0.002150

 

[Snog]

Query very slow

Disable this addon:

Please optimize this

Edit and more with the addon:

without:

I'll have a look at the first one.

The second query is the one that was optimized as best as possible in the last update and was tested on a Big Board with over 5 million posts and over 1000 groups. So, I'm not sure what else I can do with it. But I will look at it closer.

 

[au lait]

The Addon is active in a BigBoard with 9 Million posts and 150 Groups and 200K users

Look what you can do!
thanks

 

[Snog]

The Addon is active in a BigBoard with 9 Million posts and 150 Groups and 200K users

Look what you can do!
thanks

Please see your PCs.

 

[Snog]

Due to database performance issues on big boards that seem to get exponentially worse as the size of the site increases, I am going to rewrite a good portion of the system.

The next update version will be 1.3.0 which should correct database issues on big boards.

 

[Snog]

My site is now running version 1.3.0 of the social group add-on.

If anyone with a big board would like to test the new version before it's release, please log into your account on my site and contact me by PC. I'll make arrangements for you to download it.

 

[Snog]

Snog updated Social Groups with a new update entry:

Social Groups Update 1.3.0

An update to the Social Groups system has been released. Those that have purchased this add-on, please log into your account on my site to download this update.

This is a major update and as such it is strongly suggested you backup your database and the library/Snog/SocialGroups folder before upgrading to 1.3.0.

While the main focus of this update is to optimize the database routines for big boards, there are some other minor changes to the system...

• Rewrite - Database routines...

Read the rest of this update entry...

 

[Gossamer]

Would it be possible to add the ability for a group owner to set the forum description of their group? So then the forum list of groups can have some information on what the groups actually are.

And it would also be nifty for it to display on the groups page, perhaps as a hover?

 

[Snog]

Would it be possible to add the ability for a group owner to set the forum description of their group? So then the forum list of groups can have some information on what the groups actually are.

And it would also be nifty for it to display on the groups page, perhaps as a hover?

Good one!

I'll put this on the wish list. It may be in the next release.

 

[Gossamer]

Awesome, thanks!

Also, I just updated to the latest version and found a bug. I have "Go Directly to Group Forum" checked in the options, but when I click on a group in the group list, it goes to the information tab instead.

 

[Snog]

Awesome, thanks!

Also, I just updated to the latest version and found a bug. I have "Go Directly to Group Forum" checked in the options, but when I click on a group in the group list, it goes to the information tab instead.

If you're not a member of the group, it will always take you to the information tab first.

 

[Gossamer]

Is there a way to disable the separate forum tab and going back to having the forum show beneath the information tab? I think that's how it was setup for my forum before I upgraded (I missed a bunch of updates, oops). I see the update notes says you have to disable "show group and forum" to show the tab, but I don't see that option.

Edit: Or maybe have an option to have it redirect to the forum tab as long as the user has permission to view it?

 

[Snog]

Is there a way to disable the separate forum tab and going back to having the forum show beneath the information tab? I think that's how it was setup for my forum before I upgraded (I missed a bunch of updates, oops). I see the update notes says you have to disable "show group and forum" to show the tab, but I don't see that option.

Edit: Or maybe have an option to have it redirect to the forum tab as long as the user has permission to view it?

That would have to be a hard coded change to library/Snog/SocialGroups/Index.php

Locate this...

if(!$innode || !Snog_SocialGroups_Helper_Groups::helperMemberGroup($visitor,$group))

And change to this...

if(!$innode)

The tab will still show, but you'll be taken directly to the forum.

 

[RichardKYA]

Would it be possible to add the ability for a group owner to set the forum description of their group? So then the forum list of groups can have some information on what the groups actually are.

And it would also be nifty for it to display on the groups page, perhaps as a hover?

Good one!

I'll put this on the wish list. It may be in the next release.

Could this be made optional for the admin to allow this? I don't have/want forum descriptions on my site for a couple of reasons, so I don't really want group owners to be able to do this.

Thank you

 

[Snog]

Could this be made optional for the admin to allow this? I don't have/want forum descriptions on my site for a couple of reasons, so I don't really want group owners to be able to do this.

Thank you

Yes it can.

 

[Dad.]

Would this add-on allow for forums to be private except to just the group? And does it support invites and approvals to join by the starter? Can anyone start a group with the right permissions?