OpenCATS icon indicating copy to clipboard operation
OpenCATS copied to clipboard

data import page not load

Open champakakumara opened this issue 2 years ago • 9 comments

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

champakakumara avatar Aug 18 '22 05:08 champakakumara

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?

RussH avatar Aug 18 '22 07:08 RussH

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 avatar Aug 18 '22 09:08 champakakumara

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 avatar Aug 18 '22 09:08 champakakumara

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

 

champakakumara avatar Aug 18 '22 09:08 champakakumara

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

RussH avatar Aug 18 '22 12:08 RussH

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

champakakumara avatar Aug 19 '22 03:08 champakakumara

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

RussH avatar Aug 19 '22 11:08 RussH

yes those are configured

champakakumara avatar Aug 22 '22 05:08 champakakumara

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

RussH avatar Sep 02 '22 09:09 RussH