Plugin eating up all of the CPU and crashing the site

Hi tymer007,
as far as I see all queries take 0.000 sec. Are you sure the problem comes from wpDiscuz?
Also please delete all caches and click on [Refresh comment optimization] button under wpDiscuz settings.

After your update my site keeps going down and cpu and memory usage are extremely high, my hosting company is managing to fix the php errors and databases crashes that are happening and they are pointing to wpdiscuz, any tips?

After re-activating the plugin my site got extremely slow and then after clicking [Refresh comment optimization] my site crashed, and my hosting company sent me the spamming queries wpdiscuz was doing:
| 53702 | overwatc_ow | localhost | overwatc_ow | Query | 0 | Writing to net | SELECT post_name FROM ow_posts WHERE post_name = ‘default-form-21540’ AND post_type = ‘wpdiscuz_form | 0.000 |
| 53703 | overwatc_ow | localhost | overwatc_ow | Query | 0 | Sending data | SELECT post_name FROM ow_posts WHERE post_name = ‘default-form-21435’ AND post_type = ‘wpdiscuz_form | 0.000 |
| 53704 | overwatc_ow | localhost | overwatc_ow | Query | 0 | Writing to net | SELECT post_name FROM ow_posts WHERE post_name = ‘default-form-21341’ AND post_type = ‘wpdiscuz_form | 0.000 |
| 53705 | overwatc_ow | localhost | overwatc_ow | Query | 0 | statistics | SELECT post_name FROM ow_posts WHERE post_name = ‘default-form-20906’ AND post_type = ‘wpdiscuz_form | 0.000 |
| 53706 | overwatc_ow | localhost | overwatc_ow | Query | 0 | statistics | SELECT post_name FROM ow_posts WHERE post_name = ‘default-form-19269’ AND post_type = ‘wpdiscuz_form | 0.000 |
| 53708 | overwatc_ow | localhost | overwatc_ow | Query | 0 | Writing to net | SELECT post_name FROM ow_posts WHERE post_name = ‘default-form-17649’ AND post_type = ‘wpdiscuz_form | 0.000 |
| 53709 | overwatc_ow | localhost | overwatc_ow | Query | 0 | statistics | SELECT post_name FROM ow_posts WHERE post_name = ‘default-form-16915’ AND post_type = ‘wpdiscuz_form | 0.000 |
| 53710 | overwatc_ow | localhost | overwatc_ow | Sleep | 0 | | | 0.000 |
| 53711 | overwatc_ow | localhost | overwatc_ow | Query | 0 | statistics | SELECT post_name FROM ow_posts WHERE post_name = ‘default-form-5840’ AND post_type = ‘wpdiscuz_form’ | 0.000 |
| 53713 | overwatc_ow | localhost | overwatc_ow | Query | 0 | statistics | SELECT post_name FROM ow_posts WHERE post_name = ‘default-form-2305’ AND post_type = ‘wpdiscuz_form’ | 0.000 |
| 53714 | overwatc_ow | localhost | overwatc_ow | Sleep | 2 | | | 0.000 |
| 53716 | overwatc_ow | localhost | overwatc_ow | Sleep | 0 | | | 0.000 |
| 53717 | overwatc_ow | localhost | overwatc_ow | Query | 0 | Sending data | SELECT post_name FROM ow_posts WHERE post_name = ‘default-form-366’ AND post_type = ‘wpdiscuz_form’ | 0.000 |

Any help?

Hi Tymer007,
wpDiscuz doesn’t have any spam query. You hosting is wrong. Maybe your website is hacked. i can’t say. We’d need more access to be able check such an issue. You’re the one user of dozens thousands that have such issue, and I have no doubt this is a website specific problem or your website is hacked.

I’d recommend execute this SQL in your WordPress database:

DELETE FROM wp_posts WHERE post_type = 'wpdiscuz_form'

Don’t forget to change the wp_ table prefix to your WP installation table prefix.
Then navigate in Dashboard to Comments > Forms admin page and create a new comment form.

• This reply was modified 8 years, 3 months ago by gVectors Team.
• This reply was modified 8 years, 3 months ago by gVectors Team.

After running that command everything seems to be fine except that wpdiscuz on the “forms” page keeps generating new forms, there is a total of 600 forms created, is this supposed to be like that?

No, something is wrong on your end, it seems wpDiscuz doesn’t see the created form and tries to create it again. We’re going to make this logic more solid and update quickly.

What can I do to fix this?

Nothing, just wait for next update.

When is it coming out?