Can’t change table’s author

  • Resolved jakarta2000

    (@jakarta2000)


    1 year, 3 months ago

    In the “All Tables” view, there’s a column displaying the original author, but I can’t find a way to change it like with posts, which can be updated on a per-post basis, or as a bulk action.

    I’m working on a multisite and creating a template that will be cloned. A lot of tables were originally created under a user account with a weird name that we don’t want others to see.

    Is there a way to change a table’s author so that it won’t be perpetuated to every cloned subsite?

    Thanks.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    Indeed, it’s not directly possible to change the author (the initial creator of the table) from within the TablePress user interface at the moment.

    Thus, your best chance would be to just directly change the user ID in the corresponding entry in the wp_posts database table, or to maybe use the TablePress Debug Extension and then use the native WordPress user interface (via the “TP Tables” admin menu entry that this adds).

    Regards,
    Tobias

    Thread Starter jakarta2000

    (@jakarta2000)

    Hi, thanks for replying. I installed the TP Tables extension, but I’m still not seeing anywhere in the WP interface to adjust the author from the list or by clicking on a table. Is there something I’m missing there?

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    ah, you are right… I would have thought that the Author field is exposed in the Quick Edit on the “TP Tables” screen that the Extension adds — but somehow it’s now ??

    I’m afraid that changing the value directly in the post_author field of the relevant entry in the wp_posts table is then probably the way to go.

    Or, you could try exporting the table to a CSV file, and re-import that file as a new table (as the user that should be the author).

    Regards,
    Tobias

    Thread Starter jakarta2000

    (@jakarta2000)

    Thanks @tobiasbg, I updated them in wp_posts. I wanted to avoid creating new tables since I’d have to update all of the posts that referenced them.

    No doubt you already have a lot of feature requests in the works, but it’d be nice to have that ability to quickly/easily change the author like a normal post if you ever have time. I imagine most people are not comfortable poking around in the databases ??

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    good to hear that updating in the database helped!

    Note that creating a new table should not really be an issue here. If you delete the old table then, you could simply give the newly imported table the old table ID again (as table IDs can be changed on the “Edit” screen).

    I’ll look into making it possible to easily change the author, but I’ll be honest in that this is indeed not really a priority feature for me. To be honest, I can’t recall people asking for this before, so it might not be that relevant for the majority of users.

    Best wishes,
    Tobias

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Can’t change table’s author’ is closed to new replies.