Support » Plugin: TablePress » "Error: This table could not be loaded!" in WPEngine

  • Hey Tobias, taking a shot in the dark here. Do you happen to know of any possible conflicts with WPEngine Production environment and TablePress?

    Got a client that’s trying to add new tables, and each time, it’s giving a “Error: This table could not be loaded!” error. However, I tried on a fresh staging and it worked just fine.

    I know they have their staging and prod environments configured slightly differently for the nature of the work done on each.

    Any thoughts you have would be appreciated.

    https://wordpress.org/plugins/tablepress/

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

    (@tobiasbg)

    Hi,

    thanks for your question, and sorry for the trouble.

    No, I’m not aware of any compatibility issues. My assumption here is that something is disturbing the saving process of the new tables.

    Can you see the table entries in the wp_posts table? They should all have a value of “tablepress_table” for the “post_type” field. Also, they should be valid JSON code.

    Regards,
    Tobias

    Definitely seeing the posts in the tables, but it’s with empty JSON data. That may or may not be an issue, since most of my tests were doing no data involved at the time.

    [["","","","",""],["","","","",""],["","","","",""],["","","","",""],["","","","",""]]
    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    ok, that means that the post content is saved correctly.
    Can you now please also check if there’s an entry in the wp_options table, with the name “tablepress_tables”? That should be a JSON array of the table IDs with a mapping to the post ID (the ID of the field in the wp_posts table).

    Regards,
    Tobias

    Indeed there is, but there is definitely a difference.

    Did cross checking, there’s about 18 IDs from tablepress_table post type posts that are missing from the tablepress_tables option. The high number would likely be because we tried many times out of frustration at the time 😀

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    ok, that would explain this. If TablePress does not find the table ID in that array, it will not load the table.

    However, when now adding new tables, a new entry should be appended to that array in the tablepress_tables option…

    Regards,
    Tobias

    I’ll do what I can to investigate/trace my way through the code, with that lead.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    sounds good! If you find something, please let me know!

    Regards,
    Tobias

    Just as a quick followup, I believe the issue may be occurring somewhere between _update_post_id() method, called in TablePress_Table_Model and add() method, and the update method in TablePress_WP_Option. Had to take a break earlier, and can’t recall if I was for sure getting the right new data before passing into update() or not.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    I just remembered seeing issues with options being saved on some servers before. Sometimes, the mySQL database somehow is tripped up. Could you therefore please try “REPAIR”ing the mySQL tables? An easy way for that should be via phpMyAdmin.

    Regards,
    Tobias

    Noted, I’ll see what I can do, thanks for the feedback and leads.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    sure! Please let me know what you find!

    Regards,
    Tobias

    Looks like repair won’t be an option, the affected tables above are both InnoDB

    I did checks and they all checked out fine, for what it may be worth.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi Michael,

    ok, 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

    Should receive an email regarding setting up a password, etc. Emailing directly for some extra details, that need to remain off the forum.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi Michael,

    thanks! I’ve received the email and will take a look as soon as possible!

    Regards,
    Tobias

Viewing 15 replies - 1 through 15 (of 17 total)
  • The topic ‘"Error: This table could not be loaded!" in WPEngine’ is closed to new replies.