Error 500 - what does it mean Error 500 during import of CSV file

[rafal]

Hi

I am trying to import more than 4000 records and every time I am receiving Error 500 , and import fails. Do you know what might be the reason?

Regards
Rafal

[tanya]

Hello,
check server error log, please

[rafal]

Maybe simple question and stupid one, but how to do this, which file I should open? I am using Bitnami version.

[tanya]

https://docs.bitnami.com/aws/apps/elk/troubleshooting/debug-errors-apache/

[rafal]

Do You have any idea what has happened. Maybe I should turn off firewall?

[Mon Oct 08 08:30:07.457860 2018] [mpm_winnt:notice] [pid 8532:tid 756] AH00422: Parent: Received shutdown signal -- Shutting down the server.
[Mon Oct 08 08:30:09.459859 2018] [mpm_winnt:notice] [pid 7296:tid 200] AH00364: Child: All worker threads have exited.
[Mon Oct 08 08:30:09.501859 2018] [mpm_winnt:notice] [pid 8532:tid 756] AH00430: Parent: Child process 7296 exited successfully.
[Mon Oct 08 08:30:25.228858 2018] [ssl:warn] [pid 908:tid 748] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Mon Oct 08 08:30:25.463859 2018] [ssl:warn] [pid 908:tid 748] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Mon Oct 08 08:30:25.488861 2018] [mpm_winnt:notice] [pid 908:tid 748] AH00455: Apache/2.4.34 (Win32) OpenSSL/1.0.2o PHP/7.1.22 configured -- resuming normal operations
[Mon Oct 08 08:30:25.488861 2018] [mpm_winnt:notice] [pid 908:tid 748] AH00456: Apache Lounge VC14 Server built: Jul 15 2018 10:55:21
[Mon Oct 08 08:30:25.488861 2018] [core:notice] [pid 908:tid 748] AH00094: Command line: 'D:\\00_BAC~1\\EspoCRM\\ESPOCR~1.3-2\\apache2\\bin\\httpd.exe -d D:/00_Backup/EspoCRM/espocrm-5.4.3-2/apache2 -f D:\\00_BAC~1\\EspoCRM\\ESPOCR~1.3-2\\apache2\\conf\\httpd.conf'
[Mon Oct 08 08:30:25.533860 2018] [mpm_winnt:notice] [pid 908:tid 748] AH00418: Parent: Created child process 3108
[Mon Oct 08 08:30:26.527859 2018] [ssl:warn] [pid 3108:tid 644] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Mon Oct 08 08:30:26.738858 2018] [ssl:warn] [pid 3108:tid 644] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Mon Oct 08 08:30:26.761862 2018] [mpm_winnt:notice] [pid 3108:tid 644] AH00354: Child: Starting 64 worker threads.
[Mon Oct 08 08:39:49.974859 2018] [php7:error] [pid 3108:tid 1352] [client ::1:64916] PHP Fatal error: Maximum execution time of 120 seconds exceeded in D:\\00_Backup\\EspoCRM\\espocrm-5.4.3-2\\apps\\espocrm\\htdocs\\application\\Espo\\ORM\\ DB\\Mapper.php on line 739, referer: http://localhost/espocrm/

Thanks in advance
Rafal

[rafal]

Hi

I just want to share my solution with all who will face the same problem.

In PHP folder there is a file php.ini, which contains max_execution_time line, by default it is set to 120 what means that PHP will stop script after 120s. Setting it to 0 we are forcing PHP not to stop script.

In my case upload of more than 5000 records took long time since my computer is a little bit slow. That is why I have faced this problem I think.

Regards
Rafal

[tanya]

If you have big count of records in import file, you can run import in idle mode

[rafal]

Hi Tanya

It was also not working for me. I am not sure why.

You know I am mechanical engineer starting to work with such high class IT solutions. :-) So most of these things is difficult for me.

Thanks

Regards
Rafal

[tanya]

did you configure cron?