Forum Replies Created
Bloody hell, now the email subject looks fine above as it HASN’T been output as raw html in this forum.
The subject in the emails shows the apostrophe as pure html though.
It’s hard to show here as the forums seem to change html to how it should be displayed.
So to clarify:
– In my DB issue with the syntax, that ’ DOESN’T show in the error log – JUST IN THE FORUM POST – it shows in the error log as another single quote.
– The subject line of the bbpress notification emails is outputting the apostrophe as raw html.
The from address is fine and shows the apostrophe normally. It’s just the subject line that is wrong.
No it doesn’t, but ignore that ’ – it’s tripped for security here.
Hope that’s not confused stuff?
Just realised, the reason that you see the ’ in the URL is JUST THIS FORUM. It’s obviously stripping the second apostrophe JUST IN THIS FORUM.
Ignore that, it’s in 2 single quotes in my error log, it’s just because I’ve not posted it as code here.
I’ll try again here, see if it includes the second single quote.
`[19-Jan-2013 00:40:03 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘http://www.actonthis.tv/members/hardylane/’ rel=’nofollow’>@hardylane Trish ‘ at line 1 for query SELECT ID FROM wp_posts WHERE post_type = ‘reply’ AND post_status != ‘trash’ AND post_author = 11 AND post_content = ‘No worries! Say hello to Trish from me!
@hardylane Trish is still at Man Met isn\’t she Annie? I know Niamh has departed now.’ AND post_parent = ‘12436’ LIMIT 1 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), call_user_func_array, bbp_template_redirect, do_action(‘bbp_template_redirect’), call_user_func_array, bbp_new_reply_handler, bbp_check_for_duplicate`
The URL displays fine in the error log, hopefully it will here now too.
Cheers for the update Stephen!
I’m still getting it, every single time I use an @mention>
Here’s one I got tonight:
[19-Jan-2013 00:40:03 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘http://www.mysite.com/members/hardylane/’ rel=’nofollow’>@hardylane Trish ‘ at line 1 for query SELECT ID FROM wp_posts WHERE post_type = ‘reply’ AND post_status != ‘trash’ AND post_author = 11 AND post_content = ‘No worries! Say hello to Trish from me!
@hardylane Trish is still at Man Met isn\’t she Annie? I know Niamh has departed now.’ AND post_parent = ‘12436’ LIMIT 1 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), call_user_func_array, bbp_template_redirect, do_action(‘bbp_template_redirect’), call_user_func_array, bbp_new_reply_handler, bbp_check_for_duplicate
Any idea what I may need to change in my DB to stop this?
With regards to the email being sent out, the SUBJECT appears like this: (apostrophe is output as '
[My Site – The Actors' Network] Topic Name
So the apostrophe should appear as The Actors’ Network, but it’s stripped.
Not sure if the 2 problems are associated?
Thanks so much for your time!
Just wondering if anyone has had time to check their error log and see if ou get this also?
Write a forum post with an @mention and see if you get the error reported regarding syntax.
Sorry guys, was just testing out how tweets look embedded in forums. Must be some custom stuff going on in the main post over in these forums as it’s not embedded correctly.
Saying that though, submitting replies here on this site is pretty snappy!
Anything we can do to streamline our own sites?
I too would love to know if I can speed up my forums in buddypress.
I use regular site wide forums and the actual loading of the pages of the forums is great.
The sluggishness comes when posting an actual reply or topic.
Does anyone know if the number of voices in a thread, number of subscribers to it should have adverse affects on load time?
I have one topic that has 77 voices in it and quite a few may be subscribed. It takes about 7 seconds to submit a reply after hitting post.
Is that normal?
Strange thing is, is that even starting a new topic from scratch is slooowww too.
Has there been any changes to bbpress lately that will cause this? I don’t think it used to seem so sluggish.
yeah right now my site is heavily BuddyPress focused on a single site install and will more than likely never use multisite so I think the dynamic user role of ‘Member’ assigned to EVERYONE except admins will work just fine.
It’s nice to be able to control the forum privileges separately, I’d be wondering for a while how we could do that.
This way I can use all of my s2 member roles and then upgrade certain members to forum mods without affecting any of their paid for privileges.
Should help give my forums a boost too!
Thanks for your patience with all of my questions, it’s much appreciated! :O
Would that only really affect sites that were running BBPress standalone with WP?
It wouldn’t affect Buddypress profiles would it?
I’ve checked on my staging site, and the forums tabs with ‘created topics’ ‘replies’ etc still work great for users just assigned a ‘Member’ role with no specific BBPress role.
Nice explanation JJ, I now get it mate! 🙂
So all NEW signups that register will be assigned the ‘Member’ label dynamically if I don’t tick the box in the backend to make all new sign-ups a participant for example.
I’m cool with that if it’s the case.
I don’t anyone to have a specific role other than ‘Member’ unless I upgrade someone to a mod for example.
Leaving the box unchecked would thus stop any members thinking “why am I just a member when that guy is a participant’.
As long as all future members who end up with a S2 Member role will still be able to post as a ‘Member’, that works just great for me.
Is that right?
Well at the moment, everyone except admin seems to be receiving the lable of ‘Member’ under there avatar in the forums.
That isn’t an option in the backend role drop down under settings—>forums so I could set every NEW signup member to ‘Participant’ from now on, although the difference in label may confuse the odd one or two.
I’m quite happy for BBPress to just assign the dynamic role of ‘member’ to everyone unless I select something else like ‘Moderator’ from the backend.
As long as all NEW members will still be given that ‘Member’ label and still allowed to post, then I wouldn’t need to tick that box.
Is that what would happen?
Sorry for sounding dense, I just want to understand it properly. 🙂
MASSIVE thanks go out to nerrad and JJJ for this fix!
Seems to work just perfectly.
So JJ, do you think I now need to tick the box in the back end to assign a default level to new sign-ups, or does this patch dynamically assign the ‘member’ role to all new sign-ups too?In reply to: Fix for users of s2member and bbPress 2.2
nerrad, that is fantastic, and thank you so much for sharing it.
So if this assigns roles to existing members, how do we deal with new sign-ups?
JJ, do you reckon this is a future-proof solution?
No worries JJ, I’ll wait for the docs.
So how do you envisage what the best way forward would be for site owners that use membership plugins?
Is there anything we can build into BBPress to enable the ‘Participant’ level being attributed to all users excpt admins or unless it’s changed otherwise?
I’m not quite sure how to move forward.
I could use a user role capability plugin, but is that not just complicating things?
Also, where does the ‘member’ label come from that I’m seeing for regular members? It’s not actually a role that is selectable in the backend.
‘Participant’ is as close as I can find to be suitable for normal members that have their role assigned by the S2 Member plugin I use for membership.
Are there any docs on the new dynamic user roles JJ?
Bloody hell, I have this now!
BBPress was just instantly marking these posts by this user as spam, even though they weren’t!
Is there an option somewhere that would have marked this user as spammer which would go away when their role is changed to Participant?
What’s really bizarre is, I have installed the user roles plugin just now and examined user capabilities in both the plugin menu and directly in the DB looking at the capability entry string.
The free user that can’t currently post, has the EXACT same capabilities as those free users who CAN post.
There are no differences, and yet this one user account that can’t post seems to be able to write a reply and submit it, the slug in the URL adapts as it should and increases the post number in the slug by one, but it then doesn’t show the post, and it doesn’t appear front or backend.
If I change their ‘Forum Role’ in the drop down at the bottom of their edit profile dashboard screen to ‘Participant’, then they CAN post normally.
I shouldn’t have to do this though.
Anyone have any kind of clue what else it could be?
Cheers Sam, I’ll check that out. I’ve not seen any documentation about this new system yet.
I’m guessing there is a good reason for it, but would be nice to turn it off and revert if it’s going to cause big issues with any site that has altered roles (of which there will be a high percentage).
Hey Sam, I use custom caps built straight nto S2member and just assign different caps all to various s2level1 packages, so only have FREE subscribers at level 0 and paid members at level 1.
The majority of the free subscribers can access and use forums in bbpress 2.2, but anyone with level 1 access hits a 404 regardless of accessing the forum directory or topics.
Bizarrely the forum tab on profiles of these level 1 members will show their threads.
Some free subscribers set at level 0 can access forums but can’t post. You can submit a reply but it doesn’t show front or backend, and yet trying to submit the same reply again straight after gives you the duplicate post error message although NOTHING got posted anyway.
What are the role editor plugins going to enable me to do?
I’ve never used them. Would love to get to the bottom of why some level 0 members can post and yet a user with an identical role can’t?
Assigning a forum role of ‘participant’ to the free members that for some reason cant post fixes the issue.
If everyone could be assigned a ‘participant’ role as default that might be the way forward with this?
Not quite sure where the role named ‘member’ is being assigned from to my free members in the forums, as it doesn’t seem to be selectable role in the drop down for forum role.
I have ‘Participant’ set as the default role which I think it was preset to in the forums options now.
I notice the tick box to assign this role to all new signups, but a box to assign it to existing members except admins would be cool.
I’m not sure what the best way is, but I’m guessing there will be an awful lot of sites breaking if they do this upgrade.
Would love to hear some suggestions.
Not to sound ungrateful though, I love BBPress. I’ll gladly help test everything on my staging site until we can work it out for everyone.
Okay and I’ve also got some weird things happening too:
– If a member signs up for a free account on my site, they are automatically assigned the regular WP ‘subscriber’ role. These members can use the forums normally, and when they now post, they have the word ‘member’ assigned under their avatar.
– If a user pays for membership and gets an S2 Member level, they can’t see any forums, they just get a 404.
Now if I go into these members profiles in the backend, i can assign their ‘forum role’ from the drop down to something like ‘Participant’.
They still keep their S2 level, but can now also use forums.
1. Why can’t we assign them as ‘members’ like normal FREE users who are assigned that tag. It doesn’t appear in the forum role drop down menu in the edit user screen.
2. Bizarrely I have a couple of accounts that although are FREE accounts with the usual WP ‘subscriber’ role assigned, they can’t actually post.
They can see the forums, type a response and post it, but it doesn’t appear anywhere.
Pretty bizarre. Would be cool to get a good explanation of how this new dynamic role process works.
Cheers JJ 🙂
Looks like this new role capabilities change is going to cause me some pretty big issues, wondered if you could advise.
I use S2Member on my site (probably the best and most supported membership plugin).
It creates S2 Member roles for paid members away from the standard roles in WP.
For standard subscribers the forums are accessible no problem, however for anyone with a paid S2Member role, they can’t even see the root index of the forums which is /forums.
It returns a 404.
I can’t ditch s2member as it is the heart of my site and controls access to everything.
There are thousands of sites out the using this, any advice on how we can make them play nicely?