wp_podsrel table does not exist, trows error on deletion of pod content item

  • Resolved mluzvdb

    (@mluzvdb)


    3 months ago

    Hi, I am using pods and have been for a while. In this new website I created a new content type ‘Museum’. I can create a new ‘museum’ page, edit it, save it without any problem.

    But when I try to delete a museum page (from the trash) I get this error:

    Database Error; SQL: DELETE FROM wp_podsrel WHERE ( pod_id = 308 AND item_id = 436 ) OR ( related_pod_id = 308 AND related_item_id = 436 ); Response: Table 'mydatabase.wp_podsrel' doesn't exist

    I checked the database and, indeed, there is no table named wp_podsrel.

    In older websites this table is present. How did this happen? The plugin was installed without any issues. I did not manually edit the database or deleted tables.

    Installation date of the plugin: 16-01-2025. Version Pods plugin 3.2.8.1 – Version of wordpress: 6.7.1

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    3 months ago

    Try going to Settings > Tools (/wp-admin/admin.php?page=pods-settings&tab=tools) and then at the bottom there’s a tool to recreate missing tables.

    Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    3 months ago

    The only thing I can think of that would cause a missing table would be it had trouble creating in the first place (running that tool could expose the underlying issue if it still does not create for you).

    No other process deletes only the wp_podsrel table from the DB on our side except when running the reset from Settings > Cleanup and Reset (/wp-admin/admin.php?page=pods-settings&tab=reset)

    Thread Starter mluzvdb

    (@mluzvdb)

    3 months ago

    @sc0ttkclark Thank you for your quick response, I tried to create the missing table with settings/tools, but there was indeed an underlying issue: sql/dump.sql was not present.

    After copying that file from another project it worked like a charm!

    • This reply was modified 3 months ago by mluzvdb.
    Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    3 months ago

    I wonder if some other plugin removed that file or .sql files are disallowed on your host because they think it was a backup file of your actual database.

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