• Resolved andreulloveras

    (@andreulloveras)


    Hi,
    I have an issue with the Automatic Table Import. I have 2 csv that autoupload every hour in my wordpress.

    So i need to auto import two tables. I have the table STOCK and the table PRICE. When I try to AutoImport (using server or url is the same) one table it works perfectly. It works also for PRICE and for STOCK. I use the option of 15 min upload, and it works, every 15 min is updated perfectly. In the column Last Auto Import appears the datetime and @ success.

    The problem is when I try to auto import STOCK and PRICE. It ends only importing the first that appears in the auto import list. It does not appear any error or issue. THe column Last Auto Import appears blank, but if I check the table STOCK (that is the first that appear in the list) is updated every 15 min, and in the ALL TABLES tab appeears last modified every 15 minutes. The other table does nothing and dont update.

    I don’t know how to solve this and what is happening there, because separately it works perfectly, but when i try to auto import the two tables it does not work. The source and the activated check is ok and i tried to change it and save more than 20 times.

    Thank you in advance and thanks for your great plugin!

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    thanks for your question, and sorry for the trouble.

    This sounds really strange. One thing that I could imagine happening here is that the PHP memory limit is reached. Can you maybe try increasing that? One way would be to change the WP_MEMORY_LIMIT to e.g 512M in your site’s wp-config.php, via the instructions from https://codex.wordpress.org/Editing_wp-config.php#Debug

    Another idea might be to update to a recent version of PHP 7, as those need much less memory than e.g. older PHP 5.x versions.

    Regards,
    Tobias

    Thread Starter andreulloveras

    (@andreulloveras)

    Hi,
    Thank you Tobias but my WP_Memory_Limit is 512M, so i’m now checking and i’m going to update to PHP 7.

    I will report to you the results.
    Thank you.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    thanks! I hope you can find something!
    It’s also worth checking your server’s PHP error log here. Maybe that has more information.

    Regards,
    Tobias

    Thread Starter andreulloveras

    (@andreulloveras)

    I updated to version 7 and still happens the same, i’ll try to reinstall the plugin if it solves the issue…

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    no, reinstalling will not help.
    Did you find something in the error log file?

    Regards,
    Tobias

    Thread Starter andreulloveras

    (@andreulloveras)

    This is my error log

    PHP Fatal error: Out of memory (allocated 616562688) (tried to allocate 1159168 bytes) in /*************************************/wp-includes/wp-db.php on line 1924

    thank you!

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    so this does indicate a memory limit issue. I’m afraid you might have to increase the limit even more, to 1024M or so.

    And it’s interesting that the never version of PHP didn’t help…

    Regards,
    Tobias

    Thread Starter andreulloveras

    (@andreulloveras)

    I have the memory incresed to 1024M and in 2048M in WP_MEMORY_LIMIT but it don’t help, I think that the problem is that my host (1&1) don’t allow me to increase the memory more, so i’m contacting with they.
    I’ll report you if it solves the problem!

    Thank you Tobias!

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    yes, that will be the best then.
    Unfortunately, there’s nothing really that I can do here 🙁

    Regards,
    Tobias

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Automatic Table Import’ is closed to new replies.