Auto Import Won’t Import All Tables

Hi,

thanks for your post, and sorry for the trouble.

You already mention the most common issues here. In your case, I would guess memory limit, or that one table (the 152nd) causes problems. Can you check if manually importing those last 10 tables works (to be sure that their URL/path works)?

With version 1.3, you should be seeing a few more error details in the last column in the Auto Import configuration. Do those maybe help?

Regards,
Tobias

All of the problem tables can be imported/updated manually. I just went through and imported using the URLs of each table to update.

I don’t see any information in the last column in the Auto Import Configuration…there is just a “-” in the last column “Last Auto Import”. It used to show the date.

i deactivated all plugins and tried to increase memory a bit more (768mb) but that doesn’t seem to have helped.

Is this a question for the host?

Hi,

yes, it would be good to get the host involved here, and ask them to check the server error log files for hints regarding the problem.

Regards,
Tobias

I have been in touch with the host (siteground). They initially reported that there were timeout issues showing up and we set up a Real Cron job. However, the issue persisted.

I chatted again with them today…they are no longer showing any issues in the error log related to the cron.

However, I’m still having issues with many tables not updating (even more than before). And I still dont see anything in the “Last Auto Import” column. Does this LOOK for changed data and ONLY update if info is different?

I tried deactivating all plugins except TablePress and the Auto Import plugin to see if i could get anything to change but i didn’t notice any effect. I’ve turned off caching. I’m not sure what else to do. You don’t have your own cron URL for this plugin, right?

Hi,

having a server cron job is definitely a good thing here.

The Auto Import will in fact import every (configured) table, it will not check/compare for changed data, but import and replace “no matter what”.
Thus, it should show an entry for every (configured) table in that “Last Auto Import” column.

And no, there’s no custom URL for triggering the cron system or anything like that. TablePress integrates into the WordPress Cron system here.

You could maybe try investing this more with plugin like “WP Crontrol” or the Cron Manager component of the “Core Control plugin (there are few more for this purpose, but I only have used these two so far). They show all WordPress cron jobs and allow triggering them as well, which might help in finding more information on this issue. Beyond that, we’d probably have to investigate this more on the code level, I’m afraid.

Regards,
Tobias

SO interestingly, as i’ve stated, the “Last Auto Import” column just has a dash (-) even for those that are working properly. Which seems to indicate there might be some other issue. It used to update that column when I saved the configuration.

I will look at other Cron options but if you could investigate further, I’d appreciate it.

Hi,

If you want, I can take a direct look at this on your site. Could you therefore please get in touch via email (the address is in the main plugin file “tablepress.php”)? I can’t promise a solution though.

Regards,
Tobias