[NSFW] I cannot edit comments thru admin menu

  • Resolved SWC Team

    (@strongwomancrushing)


    2 years, 5 months ago

    After the the last update i cannot open the https://www.[mysite].com/wp-admin/edit-comments.php
    I received an error 502. After I enabled the debug I saw this error:
    SELECT COUNT(*) FROM wp_comments LEFT JOIN wp_posts AS wp_posts_to_exclude_reviews ON comment_post_ID = wp_posts_to_exclude_reviews.ID WHERE ( ( comment_approved = ‘0’ OR comment_approved = ‘1’ ) ) AND user_id = 2 AND comment_type != ‘order_note’ AND comment_type != ‘webhook_delivery’ AND wp_posts_to_exclude_reviews.post_type NOT IN (‘product’) AND wp_posts.post_type <> ‘wc_user_membership’ ORDER BY wp_comments.comment_date_gmt DESC
    How I can address this problem?

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)

  • Hi @strongwomancrushing

    Thanks for reaching out!

    I understand that you want to edit the comments on your site.

    Since WooCommerce 6.7.0, product reviews have moved and can now be managed under Products > Reviews.

    Hope this helps!

    Thread Starter SWC Team

    (@strongwomancrushing)

    Hi, thanks for the reply but what I’m trying to edit post comments, as you said product comments are on the products menu, it looks like woocommerce membership is generating the wrong query.

    Hi there @strongwomancrushing ??

    I’m trying to edit post comments, as you said product comments are on the products menu, it looks like woocommerce membership is generating the wrong query.

    Indeed, product reviews have moved and can now be managed under Products > Reviews.

    Post comments can be found under the standalone Comments section, as seen in the screenshot here. Can you not see that option, currently? That would be odd.

    From what I understand, you are telling us that this could be due to a plugin conflict.

    For us to investigate further, could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select Get system report and then Copy for support.?

    Additionally, could you also provide us with the fatal error logs (if any) under WooCommerce > Status > Logs.

    Once you’ve copied each, you can use https://pastebin.com/ for pasting it there and sharing it with us.

    Looking forward to hearing from you!

    Thread Starter SWC Team

    (@strongwomancrushing)

    Hi, yes, this happened without any changes to our site, also we did not install any plugins, only did upgrades.
    After I click on the comments link under posts I get an error 502, I can only access comments by activating the debug options in wp-config.

    Here is our status pasted:
    https://pastebin.com/XLjLWXAf

    Thread Starter SWC Team

    (@strongwomancrushing)

    Oh, I forgot we did not receive any fatal errors.

    Hi there @strongwomancrushing ??

    Hi, yes, this happened without any changes to our site, also we did not install any plugins, only did upgrades.
    After I click on the comments link under posts I get an error 502, I can only access comments by activating the debug options in wp-config.

    Thanks for the extra details on this. Could you try deactivating the following two plugins and see if the issue persists:

    – Display Posts – Pagination: by Bill Erickson – 1.0.0
    – Contextual Related Posts: by WebberZone – 3.2.3

    They both stood out among the active plugins, as they have to do with posts, and they haven’t been updated in five months now.

    Additionally, could you clarify how you are able to access comments by activating the debug options in wp-config?

    Looking forward to your response.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘[NSFW] I cannot edit comments thru admin menu’ is closed to new replies.