yeah… I think we’d be fine if we only had 2 topics too 🙁
I’m not well versed in database optimisation, do you have any pointers as to how I can avoid the database memory issues?
Yep, confirmed. It didn’t like /topics/ either.
I’ve just tried putting a temporary limit of 100 on the SELECT query and it fixed the issue, but obviously this isn’t an ideal solution. Do you have any ideas as to how I could fix this ‘properly’? I suppose coming up with a sensible limit could be a fix, but what would be the repercussions of doing that?
Also, if a limit is what’s required, is this going to be something I have to do manually, or would it be an update to the plugin?
I’ve just tried a Network Deactivate on both, and activated them both at the site level. There doesn’t appear to be any difference
I did all the repair tools after the import, one by one as instructed.
I have both plugins Network activated.
ok – some more digging has brought this to the surface:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 72 bytes) in /Users/tom/Sites/frenchentree/htdocs/wp-includes/wp-db.php on line 1828
Which appears at the time $wpdb->get_col() is called. Could it be that we have too many forum topics? 🙁
*edit* Currently we have 71,009 posts. Of which 70,728 are published.
Oh, and the bbPress forums were migrated from phpBB using the import tool… I can’t see that being a factor in this particular issue, just throwing it out there 🙂
FYI: If it helps, here’s the versions of all stuff currently running:
Core:
WordPress version: 3.9.1
Configuration setup for multisite. Currently, only one site installed and running (but with the intention to add ‘micro’ sites at a later date).
Plugins:
bbP Private Groups version: 1.6
bbPress version: 2.5.3
Theme:
Twenty Fourteen version 1.1
Nope, I’ve not touched the Twenty fourteen theme since I added it. It’s been updated whenever required anyway though (I don’t like the seeing the update icon in the admin, so I tend to always keep things on the latest version whether I’m using it or not).
This is a multisite install of WordPress though – Would that affect the $wpdb->get_col() visibility?
It’s the same – it seems that $wpdb->get_col() is still AWOL…
@netweb I’ve switched to the Twenty Fourteen theme, and disabled ALL plugins except for bbpress and bbp-private-groups. It’s still doing the same thing for me 🙁
– The only saving grace here, is that this *hopefully* means that I haven’t broken anything myself (although I’ll probably have to retract that statement when we find the “real” issue)
– that’s if I’m checking it correctly. I tried this:
var_dump( property_exists( $wpdb, 'get_col' ) ); Which returned bool(false)
Am I doing it right? I don’t understand how the object could be there, but the method not 🙁
Having poked around in the code myself, it appears to be falling over in inc/topics.php line 12.
$post_ids=$wpdb->get_col("select ID from $wpdb->posts where post_type = 'topic'") ;
I’ve checked and the $wpdb object is available, but it seems that the method get_col() is not… does anybody know why that might be? Or is there another method I could use to replace get_col() ?
@robin-w scrap that – it’s an error in my theme’s functions.php which I’ve just resolved. This still hasn’t fixed the ‘move’ reply issue though 🙁
@robin-w Currently, the only error I’m seeing is this (which I can’t find a reference to within the bbp-private-groups plugin code):
[23-May-2014 11:02:07 UTC] PHP Warning: call_user_func_array() expects parameter 1 to be a valid callback, function ‘blockusers_init’ not found or invalid function name in /Users/tom/Sites/frenchentree/htdocs/wp-includes/plugin.php on line 470
@netweb of course, and I’m happy to assist with this in anyway possible – I’m not expecting a free ride. I’m currently looking through the php error logs to see if I can find out some more information about where it’s failing.
Thanks @netweb, I appreciate the concern and I think if this was a live site we were discussing then I’d be much more weary of asking for help. As it happens, this site is not currently public facing, and I have plenty of backups of the data. It would be just be beneficial for @robin-w to see what I’m working with (it’s a pretty big site with a lot of forum users and topics, something that’s hard to replicate for a local test).
I solemnly swear that I won’t get ugly, and will always just be appreciative of any help that @robin-w is providing, whether it fixes my problem or makes it worse.
I believe his intentions are in the right place. Just like yours
@robin-w I just realised I gave you access to my local version of the site… *face-palm*.
I’m setting you up as an admin on the beta site right now.
@robin-w I’m using a customised version of the Roots theme (http://roots.io/).
The site is in development at the moment, but I’ll send you a personal email with a login to the beta site. I’ll also set you up as a wordpress admin and forum keymaster so you can take a look around. Thanks for your help on this by the way – I’ll be sure to make a donation once I get paid myself 🙂
@robin-w Just checked and it’s the same for keymasters and moderators. Obviously, all roles below that do not have the ability to move replies.
@robin-w I haven’t checked all the roles, but it’s happening to me and I’m a keymaster. I’ll check if it’s the same for other roles now.
Thanks for getting back to me. It appears to be missing entirely – and also doesn’t appear to use the theme to render the page anymore.
I’ve added a ‘before’ and ‘after’ screen-shot here which should hopefully help to explain what I mean:
*edit* This site tries to render my link into the page… I’ve added [link] around it to stop this happening…
[link]http://imgur.com/a/t3V6q[/link]
Hi Robin,
This plugin is perfect for our requirements but I have found that it seems to affect the ability to ‘move’ replies. (highlighted in red in the screenshot attached)
http://postimg.org/image/oxoagevs1/
Usually, you would have the option to move a post to another topic within that forum, but the dropdown seems to be missing when bbp private groups is enabled.
Is there any way to fix that?
Robin, your a star! I’ll check this out right away 🙂
Thank you so much for this, it couldn’t have come at a better time for me!
Sounds perfect 🙂 I’d happily help but to be honest this is my first project with bbpress so I’m not sure I’d be of much assistance. Sounds like you have it under control anyway – Great stuff!
@robin-w This could be perfect timing for a project I’m currently working on!
What do you have in mind for the solution that you’re building, and will it be publicly available? 🙂
