"Error: This table could not be loaded!" in WPEngine

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.

[["","","","",""],["","","","",""],["","","","",""],["","","","",""],["","","","",""]]

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 ??

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.

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.

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.

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.

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.

Hi Michael,

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

Regards,
Tobias