Skip to Content Skip to Menu

[#7997] Some Communiy Builder Running which does not clear

4 years 6 months ago #318344 by edmundcheong
Replied by edmundcheong on topic Some Communiy Builder Running which does not clear

edmundcheong wrote: is this the only location:

Code:
if ( $_CB_database->isDbCollationCaseInsensitive() ) { $query .= "\n WHERE ( u." . $_CB_database->NameQuote( 'username' ) . " = " . $_CB_database->Quote( trim( $username ) ) . ' OR c.' . $_CB_database->NameQuote( 'alias' ) . ' = ' . $_CB_database->Quote( trim( $username ) ) . ' )';

or there are anywhere else in the code which i need to update?


Latest findings to help you guys out in troubleshooting.. it seems to be better when I disabled the antispam plugin.. am still monitoring the situation..

Please Log in or Create an account to join the conversation.

4 years 6 months ago #318346 by edmundcheong
Replied by edmundcheong on topic Some Communiy Builder Running which does not clear
Yeaps, Antispam has been off for 4 hours and the Database seems to be behaving..

I will on Antispam and perhaps disable the blocking and logging to see if this is the cause..

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48541
  • Thanks: 8290
  • Karma: 1445
4 years 6 months ago #318354 by krileon
Replied by krileon on topic Some Communiy Builder Running which does not clear
There's around 4 locations that the username and alias query is being performed. It's fixed and awaiting review for merge so we can release the fix.

There's no such queries in CB AntiSpam. If you have not run the cleaning process on CB AntiSpam at all it's possible the Log and Attempts have both built up a rather large amount of database rows. Ideally you should have a CRON task setup to run the clean up URL provided in CB AntiSpam > Parameters > Cleanup. CB AntiSpam has one join of the _users table, but profiling it against a million rows it is performing fine. I'm not aware of any slow queries in CB AntiSpam, but if you find any please let us know.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

4 years 6 months ago - 4 years 6 months ago #318383 by edmundcheong
Replied by edmundcheong on topic Some Communiy Builder Running which does not clear
You are quite right, now we are getting about 4488 con-current users, the query is queuing up again..

Glad to know that you guys are already working on the fix.. do let me know when you the release is ready..
Last edit: 4 years 6 months ago by edmundcheong.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48541
  • Thanks: 8290
  • Karma: 1445
4 years 6 months ago - 4 years 6 months ago #318385 by krileon
Replied by krileon on topic Some Communiy Builder Running which does not clear
This has now been fixed in latest build release released today. It has now been tested against 1 million rows taking less than 1ms to run.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Last edit: 4 years 6 months ago by krileon.
The following user(s) said Thank You: edmundcheong

Please Log in or Create an account to join the conversation.

4 years 6 months ago #318386 by edmundcheong
Replied by edmundcheong on topic Some Communiy Builder Running which does not clear
Is is this file right: pkg_communitybuilder_2.4.5+build.2020.05.07.21.35.06.e8f8a6125.zip

Does the other plugins require updates as well?

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon
Powered by Kunena Forum