Table Settings clear randomly, then table rows and columns hidden after save

  • Resolved Tim Sutherland

    (@681admin)


    4 years, 2 months ago

    Hi Tobias

    We recently migrated 400+ tables from one WordPress install to another which worked AOK.

    However we’ve had a weird occurrence whereby some of the tablepress tables checked settings have cleared.

    The three we use are:

    • first row is table header
    • alternate colours for rows, and
    • show different colour background on hover

    For the tables that were affected I simply selected those options again and saved.

    After saving, weirdly all the rows and columns where marked as hidden. By selecting all and clicking on show rows and show columns buttons the issue was resolved.

    My concern is why this could’ve happened in the first place and whether I should be concerned about it happening again.

    Could it be something to do with where the data is stored and perhaps WordPress table data that I need to clean up?

    Any thoughts or suggestions would be greatly appreciated.

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

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    This likely happened due to some issue with the wp_postmeta database table. That’s where the selected checkboxes and visibility settings are stored. My guess is that this happened during the migration of the site.

    Regards,
    Tobias

    Thread Starter Tim Sutherland

    (@681admin)

    Cheers and thanks for the prompt response.

    Is there an identifier that will allow me to search for all the post meta rows which are table press and/or the settings?

    That way I can search all and check to ensure they’re all AOK.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    TablePress stores them with keys name _tablepress_table_options and _tablepress_table_visibility. There should be one of these for each post ID that belongs to a table.

    Regards,
    Tobias

    Thread Starter Tim Sutherland

    (@681admin)

    Great thanks. ??

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    no problem, you are very welcome! ?? Good to hear that this helped!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Table Settings clear randomly, then table rows and columns hidden after save’ is closed to new replies.