Orphaned postmeta for Category IDs

  • Resolved Erik Molenaar

    (@erikmolenaar)


    2 months ago

    Spectra 2.15.3 incorrectly creates postmeta records in the wp_postmetatable for post categories, which is not intended behavior. The?wp_postmeta?table is designed to store metadata for posts, not for other types like categories. This results in orphaned post meta entries in the database.

    To reproduce, please follow these steps:

    1. Do a preliminary check to confirm that the category IDs being tested do not exist as post IDs. This is crucial to avoid confusion, as the orphaned post meta entries will not be marked as orphaned if they overlap with existing post IDs.
    2. Visit a category page on the front end.
    3. After visiting the category page, the database contains orphaned post meta entries corresponding to the category ID used.

    This leads to massive database clutter and orphaned post meta for all existing categories.

    I hope this bug gets addressed promptly in the next release of Spectra.

    Screenshot: https://app.screencast.com/RTDy2GvKfOvwm

    Kind regards,
    Erik Molenaar

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter Erik Molenaar

    (@erikmolenaar)

    Btw, the correct database table for meta for post categories should be: ‘wp_termmeta‘

    Looking forward to your reply

    Plugin Support Abhijit Nage

    (@abhijitnage)

    Hello @erikmolenaar ,

    Thank you for bringing this to our attention. We have identified the issue and created a story for our development team to address it. We will make sure to fix this in an upcoming release to prevent any further database clutter.

    Your feedback is valuable, and we really appreciate your help in improving Spectra.

    Best regards,

    Abhijit Nage

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.