40% OFF EVERYTHING
Our 10th BIRTHDAY SALE
Buy Now

Server crash when using Import

This topic contains 11 replies, has 3 voices, and was last updated by  Paolo 8 years, 2 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • March 1, 2016 at 7:16 am #131054

    Trevor
    Expired Member
    Post count: 58

    After upgrading core (1.5.8) and all plugins the server now crashes when I start an import. It does about +/-50 (sometimes more, sometimes less) listings and then the server cpu goes crazy and the server crashes everytime.

    March 1, 2016 at 7:19 am #131059

    Trevor
    Expired Member
    Post count: 58

    Notify me of follow-up replies via email selected

    March 1, 2016 at 7:54 am #131121

    Trevor
    Expired Member
    Post count: 58
    This reply has been marked as private.
    March 1, 2016 at 4:29 pm #131546

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    please provide a link and admin credentials too.

    Thank you,

    March 1, 2016 at 4:59 pm #131592

    Trevor
    Expired Member
    Post count: 58
    This reply has been marked as private.
    March 1, 2016 at 5:43 pm #131676

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    you shouldn’t be using ” (double quotes) in titles. That is a CSV delimiter and it is breaking all your data order.

    Please see image attached.

    Thanks

    March 1, 2016 at 6:23 pm #131695

    Trevor
    Expired Member
    Post count: 58

    The double quotes are used because there are commas in the title. This is standard csv practice so that the line can be read properly using the delimiter and not a comma used in the text. This same file with double quotes was used prior to upgrading and worked 100%. The file also gets read correctly beyond these lines which tells me that it is reading correctly.

    March 1, 2016 at 6:41 pm #131706

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hello,

    That csv has a post type “gd_healthcare” but your site does not have that post type setup?

    Stiofan

    March 1, 2016 at 8:27 pm #131840

    Trevor
    Expired Member
    Post count: 58

    It wasn’t used for the main site but is used for a sub site where there is a gd_healthcare post type setup.

    March 1, 2016 at 10:59 pm #131910

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    I’m sorry, I opened the file on my new laptop for the 1st time using open office and where my delimiters to be wrong.

    Your file looks correct now that I opened it correctly.

    What is taking far too long is the server to add listings to the database.

    It is taking over 20 seconds every 5 listings, which means 4 seconds per listing for the 1st 15 than over 30 seconds and it aborts the operation. (see image attached)

    Normally it should do it in milliseconds.

    What hosting plan are you using there?

    Let us know,

    Thanks

    March 2, 2016 at 7:01 am #132046

    Trevor
    Expired Member
    Post count: 58

    Looks like the adage of deactivate all plugins and work from there always works!!

    I think it was an SEO plugin that was automatically updating the sitemap and submitting to search engines for each listing import which would work fine for manual input but not for import!!

    Any suggestions for a multisite seo geodirectory friendly plugin?

    March 2, 2016 at 5:08 pm #132366

    Paolo
    Site Admin
    Post count: 31206

    We only mantain compatibility with Yoast, so that would be the plugin we suggest to use in any case.

    Thanks for letting us know! 🙂

  • Author
    Posts
Viewing 12 posts - 1 through 12 (of 12 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket