Hi @hlpedersen7,
>>> Our main database is called pgsmnorg_test – would the fact that it says test be a factor?
Yes, that can be the problem. For tables stored within the WordPress schema, the schema name is automatically updated to the WordPress schema on the target machine. When you use a remote or external database, the schema name remains unchanged. You could prevent this issue by keeping the schema names equal. If that is not possible you can change the schema names manually in your export files or in the Data Explorer. Can you tell me which plugin tools you used? I can then tell you where to change the schema names.
>>> I should also mention – when I’m signed in as a user to WordPress, I can see the database. But if I view the website without being signed in to WordPress, the database contents can’t be seen.
Which shortcode are you using? Do you have the free or the premium version?
Thanks,
Peter
Hi Peter,
Thanks so much for the response.
The table is stored within the WordPress schema. I didn’t use any plugin tool to transfer from the staging site to the live site – our hosting service did the work for us (Just Host).
As for shortcode, here is the first data table: [wpdataaccess pub_id=”1″]
As a non-profit, we use the free version.
Would it be better to upload the table to a remote database on my hosting server and then connect through there?
Thanks,
Heather
Hi Heather,
>>> The table is stored within the WordPress schema.
Can you access the table in the Data Explorer? Can you confirm the data is there?
>>> As for shortcode, here is the first data table: [wpdataaccess pub_id=”1″]
There is no restriction on user access for this shortcode. Is there another plugin blocking access to your shortcode? Do you see the table header and footer?
>>> Would it be better to upload the table to a remote database on my hosting server and then connect through there?
If your tables is stored in your WordPress database, you’re fine.
Can you please check your publication? Is the data correct? If you test the publication from from the Data Publisher, does it work?
Let me know,
Peter
>>Can you access the table in the Data Explorer? Can you confirm the data is there?
Yes, I can see the data in the Data Explorer!
>>There is no restriction on user access for this shortcode. Is there another plugin blocking access to your shortcode? Do you see the table header and footer?
Yes, I can see the table header and footer – just no data appears in the table.
>>Can you please check your publication? Is the data correct? If you test the publication from from the Data Publisher, does it work?
Yes, from Data Publisher, the test is working great!
Also, I’ve had some members go in and try to see the database. If they use Firefox or Safari, they’ve been able to see it. With Chrome, it just shows the table header and footer. Now, when I try Safari, I only see header/footer.
Thank you, thank you.
Heather
Hi Heather,
When you open the inspector, do you see any errors?
Thanks,
Peter
I’m sorry Peter, where do I find the inspector?
Sorry Heather! 🙂
If you open the page in Chrome, just right click somewhere in your page. You’ll see a menu popup. Click on Inspect to open the inspector. Then click on Console and refresh your page. Please let me know if you see any errors.
Can you give me temporary access to the page so I can see whats happening? You can use the contactform on the plugin website to send it in private.
Thanks,
Peter
Ah! There is an error: Uncaught ReferenceError: wpda_datatables_ajax_call jquery.min.js?ver=3.5.1.:2 is not defined
at HTMLDocument.<anonymous> (<anyonymous>:25:54)
at e (jquery.min.js?ver=3.5.1:2)
at t (jquery.min.js?ver=3.5.1:2)
I will send you the password to the page through the contactform. Again, thank you!
Hi Peter,
I just went in and now it looks like when I refresh, clear cookies, that everything shows up on Chrome! I’m not sure what happened but it seems to be all there. Thank you, thank you.
Hi Heather,
It now works for me as well. Could this be a caching issue on your server? I did not clear my cache, it just works now. Are using a chaching plugin? If you are using a chachinig plugin, it might a good idea to clear your cache after installing or updating a plugin or theme.
Hope you like the plugin! 🙂
Have a great weekend,
Peter