Hey everyone!
With the holiday season upon us, we want to share our upcoming working hours:
- New Year: Our team will be off on January 1st and 2nd. We’ll be back on Friday, January 3rd, to respond to any messages received during this time.
- Weekend: As usual, we don’t work on weekends, so January 4th and 5th will also be non-working days.
- Orthodox Christmas: Our office will be closed on Monday and Tuesday, January 6th and 7th for the holiday.
After that, we’ll return to our regular schedule and assist you as quickly as possible.
In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.
Thanks a bunch for your understanding and support!
Warm regards and happy holidays!
TMS
I was having trouble with page load times, so I enabled caching on all of my tables (100+). After doing so, page load times were greatly improved, but the tables weren't updating. After reading your documentation, I implemented the Google Sheets API. I received a "success" message indicating all of my tables should now update instantaneously, but they are still not updating. I thought maybe it was because I still had caching enabled, but when I try to do so I get an error message that just says "Forbidden."
Sorry, when I try to disable caching, I get the Forbidden error.
Hi Rick,
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
If i understood, this forbidden error happens when you try to disable caching on a table in the back-end of our Plugin settings,
or in the main plugin settings, in the cache option?
The 403 Forbidden Error happens when the web page (or another resource) that you’re trying to open in your web browser is a resource that you’re not allowed to access. It’s called a 403 error because that’s the HTTP status code that the webserver uses to describe that kind of error.
You usually get this error for one of two reasons. The first is that the owners of the webserver have properly set up access permissions and that you’re really not allowed access to the resource. The second reason is that the owners of the webserver have improperly set up permissions and you’re getting denied access when you really shouldn’t be.
You need to contact your hosting provider because you have an issue with your permissions.
Once you do that please let us know if everything is back in order.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thanks for getting back to me Milos. I don't think it's a 403 error because I was allowed to enable caching - I just can't go back to the default state of caching disabled. I've attached a screenshot - it literally just says "Forbidden" and it happens when I try to save the table. In this particular case, I unchecked the box for Cache data but it happens when I change any of the settings and click Save Changes.
The urgency is higher now because the tables are still not updating. I'm wondering if I should undo the integration with the Google Sheets API, disable caching, and then try implementing the Google Sheets API again?
Attached files: Create-a-Table-‹-Simplifya-Market-Guide-—-WordPress.png
The data in our tables was getting stale and clients were starting to complain, so I had to try something even before you had a chance to reply. I removed the integration with the Google Sheets API and that did get rid of the "Forbidden" error. Then I was able to go into Settings and enable auto updates. I installed WP Crontrol and added a cron job to update my tables every 15 minutes. Finally, I went into each of my tables and checked the box to auto update cache. After some testing, everything seems to be working great!
Hi Rick,
sorry for this delay between replies.
1. I see what you mean, you are right - that is not the 403 error coming from WordPress,
but it seems it is the response from the Google API, perhaps there was a misconfiguration or a misstep for setting up the Google API method with our Plugin;
2. But , if you plan to have a lot of tables, we found it is better to not use the Google API method,
because after a while with a large number of tables, you would reach the "Google Quota API limit",
which would cause a new error "Too Many Requests" from the Google API.
So, the best option in your use case is, as you did now, to remove the Google API from our Plugin,
and just go for our 'standard Google Sheet' table connection,
combined with our own Cache and Auto Update Cache function via Cron Job,
and i see that everything seems to work perfect, happy to see that.
We will be here though, let us know if you encounter any issue with this, we will be happy to help.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables