I have 9 WP Data tables on my site. They are all working fine from the user end. However, I need to update them to make them responsive. The main one saved just fine (using SQL query - SELECT * FROM `weeklyspecials`) but when I try to edit and save any of the others (using SQL query such as SELECT * FROM `weeklyspecials` WHERE `SubCat` LIKE '%beer%' - the screen goes white with the following in the upper left hand corner: 

Thu, 20 Apr 2017 15:03:39 GMT

Please help.

Beth

That's odd because Wordfence shows your login as successful and I was able to log in just fine from both the back end and front end. (see attached)  I show no failed login attempts. Can you please try it from the front end?

Choose any of them EXCEPT WeeklyTable (ID = 1) which is the only one that works. Make a change, such as click to make it horizontal scrollable or click off to make it not responsive, then click Save. 

WeeklyTable queries a SQL table without any parameters. The others query the same table but with parameters. You should know this also happens when I create a NEW WPDataTable. Works fine when querying the table without parameters, does not work if parameters are set.

In other words, this works: SELECT * FROM `weeklyspecials` 

This does not work: SELECT * FROM `weeklyspecials` WHERE `SubCat` LIKE '%beer%'

Have attached what happens when the problem occurs. ALL of them work fine as they are from the front end but I need to be able to EDIT them. :)

Thanks. I recently replaced my live site with my staging site. That may be part of the problem. I will contact Bluehost for help. Once we figure it out, I will let you know in the event this may happen with other users.

Turns out it is a conflict with the Wordfence Security plugin. No worries. I can deactivate Wordfence while editing WPDatatables then reactivate it when done. That should solve my issue...  hope this helps if others encounter the same thing.