Auto import doesnt like URL which works manually

  • Resolved joepetrie

    (@joepetrie)


    6 years, 5 months ago

    Hi Tobias,

    Fabulous plugin. Really. Thank you very much for inventing!

    I have recently imported some tables from an AWS S3 bucket. It works fine when doing an individual manual import, but for some reason when I try to set up an auto-import, it is immediately rejected with the error message: “Error: The source for the import is invalid or could not be accessed.”…when I try to save the changes.

    There are of course access controls to AWS buckets but since it works manually, I dont think it should be this. (plus I can access it from multiple browsers).

    I am wondering if the name of the table and the URL need to be a particular format (e.g. filename and extension included or not). I did have the complete URL for both. Then I tried different variants.

    Unless there is some fundamental reason why the autoimport and AWS dont like each other I am at a loss to understand why manual import works fine and auto import wont even accept the setup configuration

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    Just to be sure: When configuring the Auto Import, you need to use the “Save Auto Import Configuration” button and not the “Import” button.
    If you are already doing that, I can only assume that the server is stripping some HTTP POST data variables from the request, so that TablePress (or rather the Extension) can not detect that you clicked that button. It will then think that you clicked the “Import” button, and then detects that nothing was entered into the (manual) URL field.

    Regards,
    Tobias

    Thread Starter joepetrie

    (@joepetrie)

    Hi Tobias,

    Yes I am indeed using the Save Auto Import Configuration button. I updated TP and I checked I am using the latest version of WP.

    I just manually replaced the table from the same URL – so I can even “update” the table manually.

    UPDATE: The Save Auto Import Configuration button seems to just want to do a manual import (as you suggest). If I complete the manual fields but then press Save Auto Import Configuration button – the table updates (manually). Is the button configured correctly?

    Otherwise, how can I achieve an auto-update of tables?

    Joe

    • This reply was modified 6 years, 5 months ago by joepetrie.
    • This reply was modified 6 years, 5 months ago by joepetrie.
    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    yes, the button is configured correctly, but for some reason (most likely) your server is not passing that configuration through to the plugin.
    This could be caused by a very long list of tables in the auto import configuration, which results in a long list of variables being sent from the browser to the server. Then, some server are configured too strictly (e.g. in security software) and remove the large amount of data from the request.

    Regards,
    Tobias

    Thread Starter joepetrie

    (@joepetrie)

    Hi Tobias,

    You were indeed correct. The web hosting company changed the max_input_vars limit from 1000 to 5000 and the auto-import configuration is now accepted.

    The next challenge is for the auto update to run, which it isnt. I think this is a server caching issue. When they installed LiteSpeed I realised I had to re-save any page for any updated table to display. I’ll keep you informed! ??

    Thanks for your help,

    Joe

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    nice find! I hope that you can make it work!
    Caching might indeed play a role here, due to how the WordPress cron system works. It might be necessary to use an actual server cron job for this, see e.g. https://www.siteground.com/tutorials/wordpress/real-cron-job/

    Regards,
    Tobias

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Auto import doesnt like URL which works manually’ is closed to new replies.