lbracci
Forum Replies Created
-
Forum: Fixing WordPress
In reply to: Reorder images via drag and drop in media library not workingThank you!
As I can see, those SQL commands are being used in the file includes/class.WpdiscuzDBManager.php, in the function getRecentAuthors(). The function apparently is being used only once, in the line 65 in utils/form-bottom-statistics.php.
As a temporary solution, I’ve commented that line and I’ve enabled the plugin again, and everything is working fine. I hope that next version of the excellent WpDiscuz plugin will have a definitive solution for this problem.
<?php // $recentAuthorsComments = $this->dbManager->getRecentAuthors($postId, $authorsLimit, false); ?>I had same problem, with MySQL overloaded. Using the MySQL slow queries log, I’ve found these queries lasting more than 40 seconds to execute. I’ve disabled WPDiscuz temporaly until the problem can be solved.
# Time: 180528 12:54:51 # Query_time: 41.808263 Lock_time: 0.000054 Rows_sent: 5 Rows_examined: 4507961 SELECT * FROM wp_comments WHERE (comment_ID, comment_date_gmt) IN (SELECT MAX(comment_ID), MAX(comment_date_gmt) FROM wp_comments WHERE comment_post_ID = _______ AND comment_approved = 1 AND comment_aut hor_email!= '' GROUP BYcomment_author_email) ORDER BYcomment_date_gmtDESC,comment_ID DESC LIMIT 5; # Time: 180528 12:54:52 # Query_time: 42.325572 Lock_time: 0.000044 Rows_sent: 5 Rows_examined: 4507961 SELECT * FROM wp_comments WHERE (comment_ID, comment_date_gmt) IN (SELECT MAX(comment_ID), MAX(comment_date_gmt) FROM wp_comments WHERE comment_post_ID = ________ AND comment_approved = 1 AND comment_aut hor_email!= '' GROUP BYcomment_author_email) ORDER BYcomment_date_gmtDESC,comment_ID DESC LIMIT 5;I think this is the same problem as in:
https://ww.wp.xz.cn/support/topic/saving-cache-settings-corrupts-wp-cache-config-php/
https://ww.wp.xz.cn/support/topic/wp-cache-config-php-file-getting-corrupted/
I’ve applied chmod 400 to wp-cache-config.php to make it read-only, until a solution is found.
Thanks you!
- This reply was modified 8 years, 8 months ago by lbracci.
Forum: Plugins
In reply to: [WP Super Cache] wp-cache-config.php file getting CorruptedI want to report the same problem. In the Dashboard, Wp-Super-Cache gives an error message about an erroneus value (/) for the $cache_path variable, and the plugin is shown as disabled. When I checked the wp-cache-config.php file, this was their partial content:
$super_cache_enabled = true; //Added by WP-Cache Manager $wp_cache_mobile_groups = ''; //Added by WP-Cache Manager $wp_cache_home_path = '/'; //Added by WP-Cache Manager ^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@$ // Disable the file locking system. // If you are experiencing problems with clearing or creating cache files // uncommenting this may help. $wp_cache_mutex_disabled = 1; //Added by WP-Cache ManagerAs you can see, the null characters overwrote $cache_path and other variables, causing the error messages. I uninstalled and reinstalled the plugin, but the problem keeps happening approximately every two days.
Temporary I’ve chmoed the wp-cache-config.php file, making it read-only.
Forum: Plugins
In reply to: [Comments - wpDiscuz] After update – can’t commentAbout the “nothing happens” problem:
Do you have a plugin or a .htaccess rule preventing access to the /wp-admin/ to unauthorized users? As far as I know, WPDiscuz *requires* access to /wp-admin/admin-ajax.php; if you block access to wp-admin, WPDiscuz will not work when users click on submit comment.
- This reply was modified 9 years, 4 months ago by lbracci.