[@talhawp Participant 8 years, 8 months ago]

Hi Pascal,

Thanks, I have just emailed you the details.

Regards,
T

[@talhawp Participant 8 years, 8 months ago]

Hi Pascal,

Yes, I don’t have errors in logs apache logs.

It is a public server, please let me know if you would like to have a quick look and can find something I have missed.

Regards,
T

[@talhawp Participant 8 years, 8 months ago]

I tried the following steps without any success:

1- Upgraded to bbPress 2.6

2- Removed sub-forums

3- Emptied Trash/Spam Topics and Replies through admin panel. This took me 3 days! Around 25% of 0.5 million posts were removed

4- Repaired Forums by going through every single option

5- Optimized WordPress Database through wp-optimize plugin

6- Changed theme to WordPress default Twenty Sixteen theme

7- Deactivated all the plugins except bbPress

The site works for few minutes then crashes. My WordPress itself has around 30K posts and 400K comments, not sure if this is causing the issue.

The whole bbPress 1.x worked perfectly for 7 years, then only issue was that the cookies and single sign between WP and bbPress had become incompatible due to newer WP versions.

Can anyone suggest anything else that I can try?

[@talhawp Participant 8 years, 9 months ago]

I found this php script online, can anyone suggest if this is safe to empty the trash?

$strSql="SELECT ID FROM wp_posts WHERE post_status='trash'";
 
$con=mysqli_connect("localhost","my_wordpress_user","my_db_pass","my_wordpress_db_name") or die("Error connecting");
$result = mysqli_query($con, $strSql);
while($row = mysqli_fetch_array($result)){
 printf($row['ID']."\n");
 }
mysqli_close($con);

php findtrash.php > trash.txt

$con=mysqli_connect("localhost","my_wordpress_user","my_db_pass","my_wordpress_db_name") or die("Error connecting");
$file = fopen("trash.txt", "r") or exit("Unable to open file!");
while(!feof($file)){
  $intId = fgets($file);
  $result = mysqli_query($con, "DELETE FROM wp_posts WHERE ID=".$intId);
  $result2 = mysqli_query($con, "DELETE FROM wp_postmeta WHERE post_id=".$intId);
  if($result && $result2){
        printf("Deleted id ".$intId);
        }else{
        printf("Results not positive".$result." ".$result2." for ".$intId." ");
        }
  }
fclose($file);
mysqli_close($con);

[@talhawp Participant 8 years, 9 months ago]

@casiepa,

I just moved all the topics in sub-forums to forums on top level and then deleted all the sub-forums.(thanks to your wonderful “topic move” plugin, it was all done quickly)

The forum worked for couple of minutes and then crashed again.

I have around 6,000 topics (25% of total topics) in trash, can this be causing the issue? I tried emptying the trash but it times-out or crashes the site. I also tried deleting the contents of trash one by one but it will take a week to do this.

Is there a way to do it directly via SQL query?

[@talhawp Participant 8 years, 9 months ago]

Yes, top level is a normal forum.

[@talhawp Participant 8 years, 9 months ago]

Hi,

Thanks for tip. I have around 100 subforms at one level deep, but not anything deeper. I will now try to move all the topics in these sub-forums to just a main forum.

Let me try and update you.

[@talhawp Participant 8 years, 9 months ago]

Hi @casiepa,

Unfortunately, the site became slow gradually in around 12 hours, until it won’t just load anymore. I tried with even managed WordPress hosting who did some fine tuning but it still won’t work. I am in kind of a desperate situation where I am losing my visitors of more than 7 years.

I am willing to hire any expert to resolve this issue if possible.

Thanks, T

[@talhawp Participant 8 years, 9 months ago]

Update:

I upgraded to bbPress 2.6 and the site seems to be responding now. Will keep everyone updated on how it goes.

Thanks

[@talhawp Participant 8 years, 9 months ago]

Hi @Pascal,

I successfully ran all the repair tools, but unfortunately I still have the issue.

I also moved my website later to a managed WordPress hosting provider that is optimized for performance, however I have same/worst performance issues. The only solution I had was to disable the bbPress plugin.

I am confident now that my server is okay.

Any more things I can try? I am thinking of trying 2.6 as well tonight.

Regards,
T

[@talhawp Participant 8 years, 9 months ago]

Hi Pascal,

Thanks for replying. No, I didn’t run. Let me try now.

Regards,
T