Importing CSV gives 500 Internal Server Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • livewire
    Senior Member
    • Nov 2016
    • 100

    Importing CSV gives 500 Internal Server Error

    Hi

    Im having the latest version of ESPO CRM.. Everything works fine except for importing leads through a CSV file i get error 500... When i select the csv it shows all the data and when i press import, after a like 20 seconds i get error 500 in a small red box and when i view though firebug it says "500 Internal Server Error" ....

    If i import like 100 leads around 20-30 gets uploaded before i get the error...Its not a time out issue coz i have set it to 300 seconds. An i dont have access to error logs


    Can someone please tell me what might be causing it and how to fix?

    Thanks
  • tanya
    Senior Member
    • Jun 2014
    • 4308

    #2
    Hi
    It's difficult to guess the problem reason. Did you try to import in idle mode?

    Comment

    • livewire
      Senior Member
      • Nov 2016
      • 100

      #3
      How do i go to idle mode?

      Comment

      • tanya
        Senior Member
        • Jun 2014
        • 4308

        #4
        Import > Step 1 > Properties > Execute in idle (for big data; via cron) (Check the box)

        Comment

        • livewire
          Senior Member
          • Nov 2016
          • 100

          #5
          Hi

          When i execute in idle mode, it says importing but none of the leads are getting imported

          Comment

          • tanya
            Senior Member
            • Jun 2014
            • 4308

            #6
            Did you check apache error log file? Espo logs as well.
            Is it possible you have leads with the same ids?

            Comment

            • livewire
              Senior Member
              • Nov 2016
              • 100

              #7
              I dont have access to apache error logs and there are no errors in the espo logs


              I have around 1000 leads, when i select check for duplicates (checkbox not checked) and run import. After a few minutes i get the internal server error

              When i select check for duplicates (checkbox not checked) and idle mode, not a single lead gets imported

              When i disable duplicate check, within a few minutes all the leads get uploaded.

              But i need to check for duplicates while uploading

              Comment

              • livewire
                Senior Member
                • Nov 2016
                • 100

                #8
                Any help on this please?

                Comment

                • zenedee
                  Junior Member
                  • Aug 2017
                  • 1

                  #9
                  The first thing you need to know about an "Internal Server Error" is that the error can only be resolved by fixes to the Web server software. It is not a client-side problem meaning that the problem is not with your browser, your computer, or your internet connection. There are a number of causes for a 500 Internal Server Error to display in a web browser.

                  Zene
                  Why am I getting a 500 Internal Server Error message? They indicate that the server failed to complete the request because server encountered an error. How to fix the HTTP error code

                  Comment

                  Working...