Jake Hall

Aluxi, these functions have not changed one bit in this release. Can you try using the normal bbpress stats shortcode and let me know what that reports?

Thanks.

Hey, when you say you are receiving an error.. is this when you try to save the file?

I haven’t had a single problem whilst playing around with it, although do bare in mind I don’t actually know how this plugin works.

Glad to hear you have fixed it!

The thread/post calculation comes directly from bbpress functions, so if it’s displaying incorrectly that is not something I can really assist with.

What you can try to do is run the tools for bbpress. I am not in wp-admin right now, however, I believe they can be found in admin > tools > bbpress

But yeah, I am not doing anything special to calculate those values. I am using the provided functions available within bbpress.

Regards,

I am really sorry for how abysmal this has been. Genuinely.

I have corrected both of those issues now, would you mind checking the plugin once more?

https://downloads.wordpress.org/plugin/bbpress-improved-statistics-users-online.1.3.11.zip

Replace the files via FTP. Everything should be good, if so – I am going to bed!

Hey Dude,

No, it shouldn’t be. Do you have access to phpmyadmin? I suspect your database version is one ahead (hence why you’re getting that error)

Could you run the following commands in phpmyadmin and let me know what the results are?

• Click on the database that contains your WordPress installation (in this case, for you, e6612395070903
• Click on “SQL”

SHOW TABLES;

and, in a separate query

SELECT option_value from wp_dqzkhzk511_options WHERE option_name = 'bbpress-advanced-statistics-dbversion'

Can you post the results here if possible please?

Thanks!

EDIT: 1.2.2 is an older version of the plugin, I don’t totally recommend that version as it has some performance issues (hence the move over to a database structure!)

Hey,

Could you make sure you have the very latest download? What I mean by this is redownload the plugin and then upload and install it as you normally would.

Edit: please make sure you deactivate the plugin, delete the plugin, upload the fresh files and then reactivate as normal.

If that doesn’t fix it, I will take a look when I get home.

Thanks.

@illiniguy it was purely because it was a file I missed when releasing, not too many people had downloaded it by that point. Plus, I had made plenty of commits that day bumping the plugin continuously… not what I want to do (as it is irritating to end users, it is irritating to other people publishing their plugin).

Regardless, for the future it won’t happen again. It has been a very, very messy release all round. Plenty of lessons were learned.

Hey illiniguy,

First and foremost, I am glad performance has improved. It was a big problem for some sites, and I wanted to correct it. Previously it would be hitting the database constantly to find all users, and it is no longer doing that!

Now, the reason why you have duplicates is you are actually running a slightly older copy of 1.3.1.

I noticed this pesky fellow last night and released a quiet update to the plugin, if you run the following queries everything should be nice and speedy! (basically, userid wasn’t set to unique. I have migrated the data, and since most sites using the plugin won’t have hundreds of members I hoped it wouldn’t be too much of an issue. (Apologies!)

DELETE FROM wp_bbpas
WHERE id NOT IN (SELECT *
FROM (SELECT MAX(n.id)
FROM wp_bbpas n
GROUP BY n.userid) x)

Might be a bit slow, apologies for that. All it is doing is deleting the duplicate data.

Next, make the userid column unique

ALTER TABLE wp_bbpas ADD UNIQUE(userid)

That should then mop up (and prevent) any duplicates from appearing. I will run some tests with your SQL code and more than likely add it into the next release!

(If you are doing that, please finally run the following command else all of your data will be lost in subsequent updates!)

UPDATE wp_options SET option_value = '1.0.2' WHERE option_name = 'bbpress-advanced-statistics-dbversion'

If any other users are reading this, I would actually suggest just installing the latest version… it does it all for you! 🙂

Please keep me updated on progress. Thank you 🙂