[@trymedo Participant 10 years, 7 months ago]

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?

[@trymedo Participant 10 years, 7 months ago]

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?

[@trymedo Participant 10 years, 7 months ago]

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

[@trymedo Participant 10 years, 7 months ago]

I did all the repair tools after the import, one by one as instructed.
I have both plugins Network activated.

[@trymedo Participant 10 years, 7 months ago]

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.

[@trymedo Participant 10 years, 7 months ago]

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 🙂

[@trymedo Participant 10 years, 7 months ago]

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

[@trymedo Participant 10 years, 7 months ago]

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?

[@trymedo Participant 10 years, 7 months ago]

It’s the same – it seems that $wpdb->get_col() is still AWOL…

[@trymedo Participant 10 years, 7 months ago]

@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)

[@trymedo Participant 10 years, 7 months ago]

– 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 🙁

[@trymedo Participant 10 years, 7 months ago]

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() ?

[@trymedo Participant 10 years, 7 months ago]

@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 🙁

[@trymedo Participant 10 years, 7 months ago]

@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

[@trymedo Participant 10 years, 7 months ago]

@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.

[@trymedo Participant 10 years, 7 months ago]

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

[@trymedo Participant 10 years, 7 months ago]

@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.

[@trymedo Participant 10 years, 7 months ago]

@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 🙂

[@trymedo Participant 10 years, 7 months ago]

@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.

[@trymedo Participant 10 years, 7 months ago]

@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.

[@trymedo Participant 10 years, 7 months ago]

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]

[@trymedo Participant 10 years, 7 months ago]

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?

[@trymedo Participant 10 years, 8 months ago]

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!

[@trymedo Participant 10 years, 8 months ago]

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!

[@trymedo Participant 10 years, 8 months ago]

@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? 🙂