Support » Plugin: TablePress - Tables in WordPress made easy » auto import not working after WP update 4.5

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

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    Most likely, this is not related to the WordPress update.
    I suggest that you invest things like the PHP Memory Limit or the WP cron jobs. There are a few plugins that could be helpful in investigating the cron jobs:
    http://wordpress.org/plugins/core-control/
    http://wordpress.org/plugins/wp-crontrol/
    http://wordpress.org/plugins/wp-cron-control/

    For the memory: Please try increasing the PHP memory limit on the server, by increasing the value of the WP_MEMORY_LIMIT constant in the wp-config.php file, e.g. to 512M, via the instructions from https://codex.wordpress.org/Editing_wp-config.php#Increasing_memory_allocated_to_PHP

    Regards,
    Tobias

    I think it is because of the update.

    I get this…

    ( ! ) Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; WP_Import has a deprecated constructor in /Users/USERNAME/PROJECTNAME/Wordpress/wp-content/plugins/wordpress-importer/wordpress-importer.php on line 38

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    this is not actually an error, but just a warning. This will be fixed in a future version of the WordPress Importer plugin. To get rid of it now, you could simply deactivate that plugin now. After an initial import you are probably no longer using it anyways.

    Regards,
    Tobias

    Thread Starter zmoerloos

    (@zmoerloos)

    Hi, we solved the problem by increasing the memory limit as you suggested.

    thanks, Zef

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi Zef,

    awesome! Great to hear that this helped!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

    Hi Tobias,

    Firstly thanks again for all your work on tablepress. It’s an awesome plugin!

    Anyway, I bought the auto import plugin a while ago, but am just trying to get it set up now. At the moment though it doesn’t seem to be triggering the imports. I have been looking at memory as you suggest above. My host uses HHVM as the server technology and we have a full 16GB. However the about section is reporting the following: –

    · Website: https://www.brenclosures.com.au
    · TablePress: 1.7
    · TablePress (DB): 32
    · TablePress table scheme: 3
    · Plugin installed: 2014/08/20 02:16:49
    · WordPress: 4.5.1
    · Multisite: no
    · PHP: 5.6.99-hhvm
    · mysqli Extension: true
    · mySQL (Server): 5.5.5-10.0.23-MariaDB-0ubuntu0.15.10.1
    · mySQL (Client):
    · ZIP support: yes
    · UTF-8 conversion: yes
    · WP Memory Limit: 40M
    · Server Memory Limit: 256M
    · Magic Quotes: off
    · WP_DEBUG: false
    · WP_POST_REVISIONS: true

    I thought that it may not be able to detect the memory so added the following to the wp-config.php file: –

    define(‘WP_MEMORY_LIMIT’, ‘1024M’);

    I have had a look in php.ini and that just has “max_input_vars = 10000;
    ” and there’s no mention of memory in the .htaccess file. However, I am still only seeing 256MB in the about section.

    Anyway, I also use WP-Cron so ran the cron job manually and got the following error: –

    There was a problem spawning a call to the WP-Cron system on your site. This means WP-Cron events on your site may not work. The problem was:
    Connection timed out after 3000 milliseconds

    Any idea what is going on? Is this likely to be an error due to the 256MB of memory the plugin is seeing? Is there anything you can think of that might be happening that would explain why you are only seeing 256MB of mmemory?

    Thanks
    Simon

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi Simon,

    thanks for your post, and sorry for the trouble.

    In this case, I don’t think that the issue is caused by the memory limit, but raising it shouldn’t hurt.
    The variable in question here is not that “Server Memory Limit” but that “WP Memory Limit”. That’s directly printing the value of the WP_MEMORY_LIMIT constant, so that you should see 1024M there… Where exactly did you add that define('WP_MEMORY_LIMIT', '1024M');? Is it in the wp-config.php as it should be?

    Now, the actual problem seems to be that cron jobs aren’t properly spawned. I’m not sure why, but it might be related to that HHVM setup. Cron jobs in WP basically execute an HTTP request to WP itself, and this doesn’t seem to be working, i.e. it seems that PHP can not make HTTP requests properly (or they are blocked on the receiving end). This is where you could start your investigation. Another idea could be to use a real server cron job, e.g. via https://tommcfarlin.com/wordpress-cron-jobs/ or http://support.hostgator.com/articles/specialized-help/technical/wordpress/how-to-replace-wordpress-cron-with-a-real-cron-job

    Regards,
    Tobias

    Hi Tobias,

    Sorry for the delay in getting back to you. I had various issues to fix but seem to have them all working now.

    – Cron jobs – These weren’t running at all, so my host has now fixed these up and I can confirm that they are running. Other plugins like Wordfence are running automatically, but tablepress auto import (tablepress_table_auto_import_hook) seems to refuse to run at regular intervals. – I seem to have fixed this now, so it is running hourly.

    – Memory – Both tablepress and wordfence were reporting a lot less memory than the site has available. I wasn’t able to set this as normal, but changing the default values seemed to allow WordPress to report more memory to the plugins and both now show 512MB (HHVM actually gives it 6GB).

    Having said all that, I am still nowhere further forward. I could see if I can get the host to sort out cron on the server as the links above, but as I can now run this one manually, all others run ok and I still get nothing, I’m not sure that is really the problem. Have you any other thoughts on what it might be?

    Wp-Cron is showing that I am running the following: –
    Hook name: tablepress_table_auto_import_hook
    Arguements: []
    Next Run: 2016-05-16 03:12:16
    Event Schedule: Once Hourly

    Is there anywhere I can see what is actually running to make sure that isn’t corrupted or anything?

    Cheers
    Simon

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi Simon,

    unfortunately, I still can’t really make sense of this 🙁

    I suggest to try again step by step. That is, try if the manual import is working for all import sources. If a table import raises an error (e.g. due to an invalid syntax), this might stop the cron import.
    Then, turn on the automatic import for one table again, and so on.

    Regards,
    Tobias

    Hi Tobias,

    I’ve just deleted the old table, then imported it in again with no issues. I then set up auto import on this single table making sure it was set to CSV and gave it the same url on dropbox public folder.

    After that I have run the cron manually and get a response that it has “Successfully executed the cron event tablepress_table_auto_import_hook”. All looks good at this point except that the table stays the same.

    I have the cache switched off, I have tried looking in a different browser and in incognito mode, still it is the same. Memory is now showing as
    · WP Memory Limit: 40M
    · Server Memory Limit: 512M
    So that all seems good, but I can up it more if you want. We are actually on a VPS running 6GB of memory, so that shouldn’t be an issue.

    I have tried the auto import on other sites too with no luck, although these are on shared hosting with low memory.

    Any other ideas? I’d really like to get this running on one of this companies sites at least, but at the moment I am really struggling with it.

    I have just tried moving the file to a different location too and that one didn’t work either.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    hhm, could it be the Dropbox URL, maybe? Depending on how they do redirects, that might be the cause, if the server is not following them when run as an unpriviledged user.
    That would be my first guess now, given that you are having trouble importing this file on multiple installations.

    Can you maybe try uploading the CSV file to a static location on a server and then try that again?

    Regards,
    Tobias

    Hi Tobias,

    That’s what I thought too. I was wondering whether the way dropbox duplicates in chunks rather than files might not show that an update had taken place, but I have also tried a static location with no luck either.

    Do you think looking at alternate file formats apart from csv would make a difference?

    Cheers
    Simon

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi Simon,

    no, I don’t think that the other formats would make a difference. They use the same routine to retrieve the data, but then simply parse it differently.

    Regards,
    Tobias

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘auto import not working after WP update 4.5’ is closed to new replies.