Data Table not showing for general users

Resolved tenetdesignstudio
(@tenetdesignstudio)

1 year ago

I have a data table app built in WP Data Access that is connected to a database that is separate from but on the same server as the WP database. The connection works fine and the page/table loads correctly if I’m logged in, but when I try to open the page in incognito (so how anyone else would see it), something isn’t working right and neither the table nor some of the rest of the content on the page loads.

I have tried removing the WPDA shortcode from the page to make sure there wasn’t a different problem, but the page loads fine if the WPDA shortcode isn’t in there. So it is definitely related to WPDA.

I have the Authorization for the Data Table app set to “Anonymous Access” so that it should be displayed for anyone.

What am i missing?

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

Viewing 6 replies - 1 through 6 (of 6 total)

Thread Starter tenetdesignstudio
(@tenetdesignstudio)

1 year ago

While I was waiting for answers, I tried disabling plugins and found the SiteGround Speed Optimizer was causing the problem. I then narrowed it down to the Front-End Combine JavaScript Files setting. If I turn that off, everything works fine. I tried just excluding /plugins/wp-data-access/public/../assets/js/wpda_rest_api.js from combination, but that wasn’t enough. Any ideas what else would need to be excluded in order to leave the Combine JS Files setting on for everything else, but for this page to still work? For now, I have just left Combine JS Files set to off so the page will load. Would appreciate any suggestions. Thanks!

Plugin Contributor Kim L
(@kimmyx)

1 year ago

Hi @tenetdesignstudio,

Thanks for the post!

We just recently responded to your ticket regarding this, and confirmed the table is now loading for us.

Any ideas what else would need to be excluded in order to leave the Combine JS Files setting on for everything else, but for this page to still work?

Could you try excluding everything that’s listed under WP Data Access?

Let us know how it goes. 🙏

Thread Starter tenetdesignstudio
(@tenetdesignstudio)

1 year ago

Sorry I posted in two places. I wasn’t sure which would be the best. Thank you so much for responding in both! The only thing listed in the options to exclude that referred to WPDA specifically was the one I excluded (/plugins/wp-data-access/public/../assets/js/wpda_rest_api.js). There were no others starting with /plugins/wp-data-access or that seemed to be directly related by name. I tried also excluding anything that had to do with apis, but it still didn’t work, so there must be something else. I’m just not sure which one and there are a lot.

Plugin Author Passionate Programmer Peter
(@peterschulznl)

1 year ago

Hi @tenetdesignstudio,

Apps access the REST API to request data. A query, for example, uses path:
/wp-json/wpda/app/select

Can you try to exclude this path?

Please let us know if this resolves the issue.

Thread Starter tenetdesignstudio
(@tenetdesignstudio)

12 months ago

I looked for anything along those lines, but still didn’t have any luck until I also disabled the combination of javascript files setting. So, with wpda_rest_api, jquery.min.js, and jquery-migrate.min.js excluded from deferral and combination of files disabled, the table is working. Side note, I noticed the sub-menu drop downs weren’t working either, but if I exclude the Elementor frontend and runtime pieces from deferral and leave the combination of js files disabled, that’s working too. As soon as I enable combination of js files, both the table and the sub-menus stop working. I tried excluding all of the same things + the files in jquery/ui/ and elementor’s dialog and sticky files from combination, but no luck so far unless I leave that disabled. I had hoped to be able to isolate the problem so I could turn those settings on, but maybe I just need to leave well enough alone. Thanks for the suggestions!

Plugin Contributor Kim L
(@kimmyx)

12 months ago

Hi @tenetdesignstudio,

Thanks so much for the update.

You can also try to reach out to SiteGrounds support for suggestions on how to properly utilize their settings without affecting other plugin scripts.

Let us know if we can help with anything else. 😊

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Data Table not showing for general users’ is closed to new replies.