Auto Import stopped working with 3.6

Hi,

thanks for your post, and sorry for the trouble.

Unfortunately, I don’t really have an idea what might be causing this. I’ve been following the development of WordPress 3.6 rather closely, and from what I saw, there were no relevant changes to the cron functionality.

So, the question is: Why are cron jobs not executed on your site? That’s what you’ll have to find out. Sometimes it might be enough to deactivate and re-activate the Extension and to set the settings again and save them.
Also, you will need to make sure that there are people visiting your site (without being logged-in), and without hitting a cache of some sort. Because if visitors only see cached pages, the cron functionality is not called.

Regards,
Tobias

We recently updated to WordPress 3.6 and actually I’m not able to upload a .CVS file at all–when I try uploading, it either takes me to a blank page or gives me an error that the page cannot be displayed. Any thoughts on what might be causing that?

Thanks!

Hi,

thanks for your post, and sorry for the trouble.

That would actually indicate that there’s some problem with file uploading on your server.

Can you therefore please set the WP_DEBUG constant in wp-config.php to true? Maybe that helps us by showing an error message.

Regards,
Tobias

Hi again,

if that does not help, please try again after temporarily deactivating all other plugins besides TablePress, and switch to the WordPress default theme TwentyThirteen, to rule out that any conflicts with other plugins.
Then, reactivate the other plugins again one by one, and check the import each time. Once it breaks again, we have found the plugin that causes the problem.

Also, about how many rows/columns does the table in the CSV file have?

Regards,
Tobias

Hi Tobias,

thank you for your reply. I enabled wp_debug, but it doesn’t log any error related to the problem.

Btw, I had the same error with the blank page that mamuran has. The reason was the unescaped ” within the .csv-strings (“field 1”; “field 2″; Fiel”d” 4″;..). I had to remove the table (because updating didn’t work even after the csv-file was corrected) and import the file again. Manually importing did work after this.

I am totally aware of how the cron_jobs work, but there are lately many users on the site so this should not be a problem. I will try to deactive the plugin and see if it helps!

Cheers,

Marc

So, i guess i came closer.

I disabled the plugin, and entered the csv-soruces one by one again. i found out that this file https://marathon.ergebniscenter.de/2013/teilnehmerlisten/5km was the reason all the other four tables were no longer updating (it was, btw, the last file i entered again). If i disabled updating this table, all the other tables work nicely. If i enable this table, too, none of the tables is updated.

so i manually updated the table, enabled auto-import again and now none of the tables are updating, and it doesn’t matter if i enable oder disabled auto-import for this one table.

So i deleted the related table, updating now works fine again.

I imported the same csv-file again into a new table, enabled auto-updating for it and voila: Now every table updates fine (at least until it breaks again ?? ).

I still don’t know how such a behavior is possible, maybe you have an idea! I guess this is related to the table itself; deleting and importing into a new table seems to help if updating won’t work – sometimes.

Hi,

thanks for further investigating this!

That sounds really weird, and to be honest, I have no idea why that suddenly works. That table content has nothing to do with the auto import, so that’s really strange.
But good to hear that it’s working now ??

(One other idea could be that the PHP Memmory Limit is reached, so just a precaution, you could maybe increase the value of the WP_MEMORY_LIMIT constant in wp-config.php.)

Regards,
Tobias

Well I tried deleting the old table and uploading the new one–to no avail. But, I exported the old table first, so I pasted the new content in from the new .CSV file and it worked–so maybe in this instance it was a corrupt Excel file. Thanks for your help though!

Hi,

that also sounds weird, but yes, it could be possible.

Best wishes,
Tobias

So it stopped working a few days ago again. In the end I believe the reason is the php memory limit. increasing it to 96M worked so far, i hope this will be enough for the future ??

Hi,

ah, very nice! Good to hear that increasing the memory limit helped! That’s most likely the reason for this issue then ??

Regards,
Tobias

I would like to reopen this case. the auto imported stopped working again. this time i adde the tables again, disabled and enabled the plugins (network site), but still i won’t manage to import all tables.

if still have have five tables i wanna update. if i enable all five to auto update, the cron just returns an error. If i enable just four, it works (i disabled the largest table). Only enabling the largest table (around 1000 lines, 5 columns, 44 KB) works. All in all there are about 3000 lineas of data to import.

i increased the memory limit to 256 MB (of which 40 MB are used),and changed some settings within the php.ini as well: Max: Post 64M, Upload 64M, Input 120s, Exec 300s.

tl;dr; importing the tables one by one works, importing multiple (big) tables won’t work, all php limits are increased to an amount where no problems should exist.

Any idea if we can debug this case?

Hi,

sorry to hear that you are still having issues ??
This still sounds like a PHP Memory Limit issue to me. I don’t really see a different possibility here.
Can you maybe try setting WP_MEMORY_LIMIT even higher, maybe 512M?

Regards,
Tobias

Although its shared hosting, i managed to increase the limit to 512MB, but it still won’t work. nevertheless 200mb ram for importing less than 200kb data should be enough, shouldn’t it?

Hi,

yes, that should be enough, unless there’s something weird going on with loops (think of infinite loops).
Unfortunately, I don’t really see what else we could try here ?? The probem is that those crons are terribly hard to debug ??

Regards,
Tobias