TablePress Error

  • Resolved triprems

    (@triprems)


    3 years, 10 months ago

    Hello,

    We are experiencing some problems with the TablePress plugin. When updating cells in a table, we get a success message that the table has been updated. However, when we reload the table in the TablePress editor, we are seeing the old data. The timestamp is updated, but all changes that we made to the table are lost.

    Also, we are unable to import a CSV file to an existing table. Again, we get a success message, but the table data does not appear to change.

    We can import a CSV file to a new table without any problems, but this is not very convenient, as we would need to upload a new CSV file every time we need to make changes to the table.

    We’ve tried the following:

    1. Disabled JQuery Migrate plugin
    2. Cleared the CDN and application (Autooptimize) caches in WordPress.
    3. Checked the release notes for TablePress 1.13 for compatibility problems.

    And here is the configuration info for our test site:

    Website: https://health80.hawaii.gov/ddd
· TablePress: 1.13
· TablePress (DB): 42
· TablePress table scheme: 3
· Plugin installed: 2014/09/15 16:28:02
· WordPress: 5.7.1
· Multisite: yes
· PHP: 7.3.27
· mysqli Extension: true
· mySQL (Server): 5.7.31-log
· mySQL (Client): mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $
· ZIP support: yes
· UTF-8 conversion: yes
· WP Memory Limit: 64M
· Server Memory Limit: 1024M
· WP_DEBUG: false
· WP_POST_REVISIONS: true

    Any advice that you could offer would be greatly appreciated!

    Thanks.

    Trip Rems
    Aurora Design and Consulting

    The page I need help with: [log in to see the link]

Viewing 15 replies - 1 through 15 (of 16 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    That sounds really strange and could indicate some sort of database problem. If possible, I’d like to take a direct look at this on your site. Could you therefore please get in touch via email (the address is in the main plugin file “tablepress.php”)? That way, I can investigate this directly. Thanks!

    Regards,
    Tobias

    Thread Starter triprems

    (@triprems)

    Hi Tobias,

    Thanks for the quick response!

    I’ve contacted the DOH team to see if they would be willing to grant you temporary access to the DOH test site. I’ll keep you posted.

    Also, it is strange that the table description and timestamp are editable, but the actual data is not. I’m wondering if there might be a permissions problem with the database, or other configuration problem.

    Aloha,

    -Trip

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks a lot! TablePress is actually pretty strict about error checking when saving/updating tables, so that the only guess I have here is that something in the wp_update_post() function is not updating properly.
    I can’t remember any similar reports like this from the past so that I don’t really have ideas as to what might be causing this. And just to be sure: The table data reverts to the old data on the “Edit” screen as well, or just on the frontend?

    Regards,
    Tobias

    Thread Starter triprems

    (@triprems)

    Hi Tobias,

    Yes… that is correct. The data in the table does not change when I reload the table in the table editor (after Saving changes).

    Also, its strange that I cannot overwrite a table in TablePress with a new CSV file.

    Aloha,

    -Trip

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for the clarification. Then, something must be wrong…

    You could try finding out more with the TablePress Debug Extension from https://tablepress.org/download/extension/tablepress-debug.zip
    Once installed and activated as plugin, this will show a “TP Tables” entry in the admin menu, which gives access to the raw and internal table data, in JSON format. Does making changes and saving work there?

    Also, can you reproduce the issue with normal posts and pages? As TablePress stores tables as a “Custom Post Type”, in the same database table, I could imagine that this also does not work properly.

    Regards,
    Tobias

    Thread Starter triprems

    (@triprems)

    Hi Tobias,

    Thanks for sending the link to the TablePress Debug Extension. I’ve asked DOH to install the plugin on the test site, and will keep you posted.

    Also, we are not having any problems updating posts / pages or any of our custom post types on the DOH test site.

    Thanks.

    -Trip

    Thread Starter triprems

    (@triprems)

    Hi Tobias,

    We’ve tested TablePress on our production website using the TablePress Debug Extension, and we were able to edit tables without any problems. We can make changes directly to JSON data, save changes, and view updates in the normal TablePress editor.

    Thanks!

    -Trip

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    ok, that’s a good sign! If the issue with editing directly from the TablePress “Edit” screen persists, I’d still like to take a look, if possible.

    Regards,
    Tobias

    Thread Starter triprems

    (@triprems)

    Hi Tobias,

    DOH has added a temporary admin account for you on the test site. You should receive an invitation from WordPress.

    Please let me know if you have any problems logging in.

    Aloha,

    -Trip

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks! Yes, I have received the account information and was able to log in.
    I could then log in and can reproduce the issue.

    I’m still unsure how this can happen, but I do have a suspicion:
    Could the PublishPress Revisions plugin play a role here? My feeling is that this plugin is “intercepting” the TablePress save process and internally creates a new revision of the “post” (remember, tables are stored as a custom post type), that is now waiting for some sort of approval somewhere. And until that happens (if at all possible), the old version/revision of the table “post” is shown.
    As an easy test, can you please try temporarily deactivating that plugin and then try again?

    Regards,
    Tobias

    Thread Starter triprems

    (@triprems)

    Hi Tobias,

    Ok… thanks for the information. I?ve contacted DOH personnel about the plugin, and will keep you posted.

    Aloha,

    -Trip

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    sure!

    Other than that, I can’t really find anything else on the site right now (mainly, as I can’t see the Plugins list or add debug code inside TablePress, as this seems to be a Multisite site, where managing/editing is only possible for superadmins).

    Regards,
    Tobias

    Thread Starter triprems

    (@triprems)

    Hi Tobias,

    After testing the DOH site with PublishPress Revisions disabled, it seems that we can now edit Tables in TablePress again. We are waiting for DOH staff to make the changes to the production site, so that we can confirm this fix.

    I’ll keep you posted, and thanks for all of your help with TablePress!

    Aloha,

    -Trip

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    great! Thanks for testin this! Sounds like we found the cause for this issue then ??

    Best wishes,
    Tobias

    Thread Starter triprems

    (@triprems)

    Hi Tobias,

    Thanks for all of your help!

    Aloha,

    -Trip

Viewing 15 replies - 1 through 15 (of 16 total)
  • The topic ‘TablePress Error’ is closed to new replies.