Support » Plugin: TablePress » Auto Import stops working

  • Resolved zlevine1

    (@zlevine1)


    First off, I would like to thank you for creating this amazing plugin!

    I have 9 tables, all of which are configured for “Auto Import” at 15-min intervals.
    Every once in a while one or sometimes a few of the tables stop automatically importing.
    I’ve read the FAQ as well as related threads and as so, I’ve increased the amount of RAM allocated to PHP in the wp-config file, however that did not seem to help.

    What’s worked for me in the past was deleting the table and re-creating it with a different ID number. However, when I try that now, all but one of my tables automatically imports: The last table auto-imports one time after it is re-created however it does not keep auto-importing at the 15-min interval that I’ve set as the other tables do.

    Any ideas as to what could be causing this?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your question, and sorry for the trouble.

    Unfortunately, the auto import is very hard to debug, because it runs asynchronously. :-/
    The first thing to check is if the configured values (import source, format, …) work when using them with a manual/normal import.

    Increasing the RAM and maybe other PHP configuration values (like maximum execution time) would then be my next guesses.

    Does the “last one” (which doesn’t keep auto-updating right now) work fine if you temporarily deactivate the auto import for the other tables, i.e. if it’s the only one?

    Regards,
    Tobias

    Sorry for the delay in replying to this.

    So, I’ve increased the RAM on my machine and I also increased the maximum execution time by adding set_time_limit(300); to the end of my wp-config.php file.

    I can also confirm that everything works fine when updated through a manual/normal import.

    When I deactivate the auto import feature for the other tables, the last table still does not auto-update.

    Any suggestions as to what the problem could be?

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for checking all this.

    One other idea (if the server and the service plan with the web host company supports them) is to use a real server cronjob, which can be more stable. The setup is slightly different for each company, but here’s a fairly common set up guide:
    https://www.siteground.com/tutorials/wordpress/setup-cron-job.htm

    Regards,
    Tobias

    Thank you πŸ™‚

    I’ve actually switched to crontab a long time ago (when I first encountered this issue) so I think there still may be something else going on, however I was able to fix this by deleting all of the tables and re-importing them all from scratch as ‘new’ tables.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    ah, ok πŸ™‚ The real crontab should then provide some reliability here.
    It’s strange that it works after recreating the tables, but ok πŸ™‚ That’s good!

    Regards,
    Tobias

Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.