An idea…

Hello @goof71

This can easily be done with a custom cleanup-script in phpmyadmin.

You forum should not run slowly when it contains a lot of posts/topics. Are you using the latest version of the plugin? Which parts are running slow? How many posts/topics your forum has?

Dear Asgaros
I hace 200 topics / 2000 posts with the lastest version of WordPress/Asgaros.
It’s the maintopic page (with the “forum shortcode”). I will ask my hoster to know if there’s a server problem.

Viewing my logs… I got hundred of errors like this :

[Tue Jul 04 20:37:17 2017] [error] [client 141.101.69.157] [host https://www.xxxxxx.fr] FastCGI: server “/home/xxxx/www/v3/index.php” stderr: PHP message: Erreur de la base de donn\xc3\xa9es WordPress Lost connection to MySQL server during query pour la requ\xc3\xaate SELECT p.id, p.date, p.parent_id FROM wp_forum_posts AS p INNER JOIN wp_forum_topics AS t ON p.parent_id = t.id INNER JOIN wp_forum_forums AS f ON t.parent_id = f.id WHERE p.id IN (SELECT MAX(p_inner.id) FROM wp_forum_posts AS p_inner GROUP BY p_inner.parent_id) AND (f.id = 4 OR f.parent_forum = 4) AND p.date > ‘0000-00-00 00:00:00’ ORDER BY p.id DESC; faite par require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/customizr/index.php’), do_action(‘__loop’), WP_Hook->do_action, WP_Hook->apply_filters, CZR_page->czr_fn_page_content, the_content, apply_filters(‘the_content’), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, AsgarosForum->forum, AsgarosForum->overview, require(‘/plugins/asgaros-forum/includes/views/overview.php’), require(‘/plugins/asgaros-forum/includes/views/forum-element.php’), AsgarosForumUnread::getSta…

Theme compatibility problem ???

I’ve changed my theme, it works better !

Sorry but the problem only disappear when I deactivate the forum. Last version of the forum installed

[Fri Jul 07 17:38:27 2017] [error] [client 80.12.58.70] [host https://www.fanselanchalon.fr] FastCGI: server “/homez.57/fanselan/www/v3/index.php” stderr: PHP message: Erreur de la base de donn\xc3\xa9es WordPress Lost connection to MySQL server during query pour la requ\xc3\xaate SELECT p.id, p.date, p.parent_id, p.author_id, t.name, (SELECT COUNT(*) FROM wp_forum_posts WHERE parent_id = p.parent_id) AS post_counter FROM wp_forum_posts AS p LEFT JOIN wp_forum_topics AS t ON (t.id = p.parent_id) LEFT JOIN wp_forum_forums AS f ON (f.id = t.parent_id) WHERE p.id IN (SELECT MAX(p_inner.id) FROM wp_forum_posts AS p_inner GROUP BY p_inner.parent_id) AND f.parent_id IN (424) ORDER BY p.id DESC LIMIT 4; faite par require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/customizr/index.php’), do_action(‘__loop’), WP_Hook->do_action, WP_Hook->apply_filters, CZR_page->czr_fn_page_content, the_content, apply_filters(‘the_content’), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, amr_do_widget, amr_shortcode_sidebar, WP_Widget->display_callback, AsgarosForumRecentPosts_Widget->widget, AsgarosForumWidgets::showW…, referer: https://www.fanselanchalon.fr/v3/forums?view=forum&id=1
[Fri Jul 07 17:38:27 2017] [warn] [client 80.12.58.70] [host https://www.fanselanchalon.fr] FastCGI: too much stderr received from server “/homez.57/fanselan/www/v3/index.php”, increase FCGI_SERVER_MAX_STDERR_LINE_LEN (1023) and rebuild or use “\\n” to terminate lines, referer: https://www.fanselanchalon.fr/v3/forums?view=forum&id=1

Hello @goof71

Sorry for the late reply. I will check the database-queries and will try to improve them for a better performance. Do you have phpMyAdmin installed on your server to check if the indices got created correctly by the forum?