search

opencats / OpenCATS

Applicant Tracking System (maintained code base)
http://www.opencats.org
Other
528 stars 245 forks source link

data import page not load #570

Open champakakumara opened 2 years ago

champakakumara commented 2 years ago

when we click data import on settings got below error page , how resolve it?

This page isn’t working xxx.xxxxxx.com is currently unable to handle this request. HTTP ERROR 500

RussH commented 2 years ago

Hi can you confirm which version of opencats you're using, and version of php, mariadb. Also the entries from your apache error log and access log when this happens?

champakakumara commented 2 years ago

opencats Version 0.9.4 Countach PHP 5.6.40 mariadb Ver 15.1

[Thu Aug 18 08:56:17.841648 2022] [:error] [pid 13754] [client 10.0.0.53:40276] PHP Fatal error: Class 'Import' not found in /var/www/html/opencats/modules/import/ImportUI.php on line 334, referer: https://xxx.xxxx.com/opencats/index.php?m=settings&a=administration

champakakumara commented 2 years ago

Hi can you confirm which version of opencats you're using, and version of php, mariadb. Also the entries from your apache error log and access log when this happens?

opencats Version 0.9.4 Countach PHP 5.6.40 Server version: 10.1.48-MariaDB

[Thu Aug 18 08:56:17.841648 2022] [:error] [pid 13754] [client 10.0.0.53:40276] PHP Fatal error: Class 'Import' not found in /var/www/html/opencats/modules/import/ImportUI.php on line 334, referer: https://xxx.xxxx.com/opencats/index.php?m=settings&a=administration

champakakumara commented 2 years ago
Operating System: Linux ip-10-0-4-210 5.4.0-1083-aws #90~18.04.1-Ubuntu SMP Fri Aug 5 08:12:44 UTC 2022 x86_64
Operating System Type: CATS thinks your operating system is UNIX.
PHP Version: 5.6.40-47+ubuntu18.04.1+deb.sury.org+1
Database Version: MySQL 10.1.48-MariaDB-0ubuntu0.18.04.1

 

RussH commented 2 years ago

and this is using the Mass Import function from the admin /settings page?

champakakumara commented 2 years ago

Settings: Administration- Data Import (Import resumes, candidates, companies or contacts from files on your computer.)

RussH commented 2 years ago

Okay - so I have a 0.9.4 instance. the import is a long process though.. can you check your max upload size and max execution time is configured in php.ini and not left at the defaults? php.ini max_execution_time = 300 max_input_time = 60 post_max_size = 20M upload_max_filesize = 20M max_file_uploads = 20

champakakumara commented 2 years ago

yes those are configured

RussH commented 2 years ago

I assume if you look in the error log, then immediately above that one line there's another one with something similar to PHP Warning: include_once(): Failed opening 'LEGACY_ROOT/modules/import/Import.php')' for inclusion

if so - the path to import.php needs amended for the app to find it. Please note that there are open vulnerabiities with 0.9.4 and you should only run this if you are not exposing the career portal to the internet. If you are using the career portal you must upgrade to the current release asap. Also there was significant rework for candidate import function in the versions after 0.9.4