TablePress Auto Update does not work

Hi,

@ahmad: Great to hear that deactivating “Maintenance Mode” fixed it for you as well! ??
And thanks for wanting to donate, I really appreciate it!

@ian: Ok, that’s strange. I’m not really sure why this is not working then. Are the tables for the auto import configured correctly?

Regards,
Tobias

Yes, it’s the same table as the manual import with just extra rows added.

Hi,

I mean: Is it configured correctly on the “Auto Import” screen, that the Extension adds to TablePress, with the correct source and format and everything?

Regards,
Tobias

Yes, seems to be all correct. I have a request in with my hosting company to check wp-cron jobs are allowed. I’ll let you know what they say.

Thanks for your help so far on this!

Hi,

yes, that’s a good idea.
If that does not help, I can offer to take a direct look at this on your site’s admin area, but I’m not very optimistic that I will find something…

Regards,
Tobias

Ooops…looks like my client is on a shared hosting package that doesn’t allow cron jobs due to security issues and load management on the servers. Sorry for wasting your time.

You have a great plugin and one I will look at again in the future. Thanks!

Hi,

no, hold on! What you mean are regular cron jobs. Those are not allowed on most servers (for reasons you mentioned). That’s why WordPress has it’s own system, called “WP Cron” that emulates cron jobs.
And that’s what TablePress uses in that Extension. However, if you can’t get that to work, a custom solution might be necessary…

Regards,
Tobias

Is there any max. of how many tables can be synced?
I have app. 200 tables and it always stops after app- 130 tables.
I have tried to disable all plugins, that didn’t help.
In the Auto Import section the colomn Last Auto Import doesn’t show anyting.

The auto import works great for all the tables that is synced, and it newer stops the same place. Sometimes after 120 tables, sometimes after 140 tables, and if I disable the sync of the first 100 tables, the last 100 is working perfect, so there is nothing wrong with the tables.

Thanks for a great plugin.

Hi,

thanks for your post, and sorry for the trouble.

My assumption here is that the PHP Memory Limit or the maximum execution time for the PHP process is reached during the import. As the load on the server probably varies, this happens between 100 und 140 tables on your server.

To find the exact reason, I suggest that you take a look into the error log file on the server. Maybe that gives us some hints.
If we are lucky, we can then fix this by increasing the memory limit or the allowed execution time, but depending on your webhost company, this might not be possible/allowed.
In that case, I don’t really see a fix for this, unfortunately. The Auto Import Extension is just not robust enough to handle so many syncs, at this time.
Therefore, if this is really a criticial feature for your site, you might need to think about a custom PHP/mySQL solution for your tables, or only use the Auto Import Extension for those tables where it’s really necessary.

Sorry for not having better news ??

Regards,
Tobias

Thank you.
I have tried to increase the memory limit.
The error log file doesn’t show anything.

Hi,

ah, thanks for trying that. Really unfortunate that there’s nothing in the error log ??
I hope that the increased memory limit helps, otherwise, I’m out of ideas. Sorry ??

Regards,
Tobias

It seems like increasing the memory limit did help
Thank you.

Hi,

ah, very cool! ?? Great to hear that this indeed did the trick!

Best wishes,
Tobias