Table of Contents
< All Topics
Print

♻️ Updating KB Pages from Database

If you want to regenerate a Knowledge Base (KB) page based on updated database values, you can trigger the automatic process again by following these steps.

✅ Step-by-step Instructions

  1. Open your database using a tool like phpMyAdmin or Adminer.
  2. Navigate to the table wp_plant_species.
  3. Find the entry you want to update (you can search by the english_name field).
  4. Set the value of the field post_id to -1 (not NULL or 0).
  5. Save the change in the database.
  6. Now reactivate the plugin “Create KB Article from Plant Species Table” in your WordPress admin dashboard:
    • Go to Plugins > Installed Plugins.
    • Click Deactivate next to the plugin.
    • Then click Activate.
  7. The KB article will be re-generated based on the updated database fields.

💡 Notes

  • This method ensures the content is fully in sync with the database and prevents accidental manual edits on the WordPress side.
  • It currently works for the table wp_plant_species and will be extended to other data tables in the future (e.g., harvest logs, individual plants).

Categories