$conf, $runtime; function_exists('chdir') AND chdir(APP_PATH); $r = 'mysql' == $conf['cache']['type'] ? website_set('runtime', $runtime) : cache_set('runtime', $runtime); } function runtime_truncate() { global $conf; 'mysql' == $conf['cache']['type'] ? website_set('runtime', '') : cache_delete('runtime'); } register_shutdown_function('runtime_save'); ?>posts - Comments are in database, don't show up in WordPress backend or frontend|Programmer puzzle solving

Programmer puzzle solving

    最新消息：Welcome to the puzzle paradise for programmers! Here, a well-designed puzzle awaits you. From code logic puzzles to algorithmic challenges, each level is closely centered on the programmer's expertise and skills. Whether you're a novice programmer or an experienced tech guru, you'll find your own challenges on this site. In the process of solving puzzles, you can not only exercise your thinking skills, but also deepen your understanding and application of programming knowledge. Come to start this puzzle journey full of wisdom and challenges, with many programmers to compete with each other and show your programming wisdom! Translated with DeepL.com (free version)
    你的位置： HOME>matter>posts - Comments are in database, don't show up in WordPress backend or frontend

    posts - Comments are in database, don't show up in WordPress backend or frontend

    matteradmin7PV0评论

    I am in the process of rescuing the content from a WordPress site with a bloated/damaged database. Everything has gone according to plan except for the comments. I can see that the 4000+ comments are indeed in the database's wp_comments table, and I verified that the IDs of the associated posts are correct, but none of them show up in the WordPress admin area or the front-end. I haven't been able to find where the issue lies.

    Maybe someone in the community has an idea for a possible fix? Thanks.

    Edit: to clarify, I already moved the content to a new database, the issue happens on the new WordPress installation. The comments were imported to the database when importing the posts through the export/import tool.

    I am in the process of rescuing the content from a WordPress site with a bloated/damaged database. Everything has gone according to plan except for the comments. I can see that the 4000+ comments are indeed in the database's wp_comments table, and I verified that the IDs of the associated posts are correct, but none of them show up in the WordPress admin area or the front-end. I haven't been able to find where the issue lies.

    Maybe someone in the community has an idea for a possible fix? Thanks.

    Edit: to clarify, I already moved the content to a new database, the issue happens on the new WordPress installation. The comments were imported to the database when importing the posts through the export/import tool.

    • posts
    • database
    • comments
    Share Improve this question edited Jan 18, 2019 at 13:39 butlerblog 5,1413 gold badges28 silver badges44 bronze badges asked Jan 18, 2019 at 1:42 cVergelcVergel 13 bronze badges
    Add a comment  | 

    2 Answers 2

    Reset to default 0

    Please make sure that you have turned on the comments and discussion from the screen options of the posts => http://prntscr/m8qac1

    And also mark the check mark on the allow comments checkbox showing on the middle/end of the post pages => http://prntscr/m8qapd

    Ok, so after going over the database structure, I realized that for some reason all comments status on the table comment_approved had been set to post-trashed. Changing the value of that column to '1' made it all reappear.

    Articles related to this article

    Post a comment

    comment list (0)

    1. No comments so far