OpenCATS
OpenCATS copied to clipboard
Error while importing candidate CV in bulk
Expected behavior and actual behavior.
Its supposed to greet me with a success page but instead im getting
MySQL Query Failed: Incorrect datetime value: '2020-04-14T16:20:16+01:00' for column vennit_talents.candidate.date_created at row 1
UPDATE candidate SET date_created = "2020-04-14T16:20:16+01:00", date_modified = "2020-04-14T16:20:16+01:00" WHERE candidate_id = 3 AND site_id = 1
Steps to reproduce the problem.
{siteurl}/index.php?m=import&a=massImport
mass import at this url and then it asked to manually parse some docs.
After I did that and clicked import, i got those errors
What version of opencats are you running?
v0.9.4
Release or downloaded from Git?
Installed from the script for Ubuntu 16
WAMP or LAMP?
Virtualmin on AWS
What version of PHP and MySQL are you running
php5.6 and AWS RDS mariaDB 10.3.20
attach appropriate error logs. Please attach [apache/mysql] error/access logs as needed.
[Tue Apr 14 16:48:25.253841 2020] [fcgid:warn] [pid 20812] [client xx.xx.xx.xx:41932] mod_fcgid: stderr: PHP Notice: MySQL Query Error: Incorrect datetime value: '2020-04-14T16:19:41+01:00' for column xx_talents.candidate.date_createdat row 1 - UPDATE candidate SET date_created = "2020-04-14T16:19:41+01:00", date_modified = "2020-04-14T16:19:41+01:00" WHERE candidate_id = 2 AND site_id = 1 in /home/xx/xx/xx/public_html/lib/DatabaseConnection.php on line 188, referer: https://xx.com/index.php?m=import&a=massImportEdit&postback=1&documentID=34 [Tue Apr 14 16:48:46.304835 2020] [fcgid:warn] [pid 20814] [client xx.xx.xx.xx:35335] mod_fcgid: stderr: PHP Notice: MySQL Query Error: Incorrect datetime value: '2020-04-14T16:20:16+01:00' for columnxx_talents.candidate.date_created at row 1 - UPDATE candidate SET date_created = "2020-04-14T16:20:16+01:00", date_modified = "2020-04-14T16:20:16+01:00" WHERE candidate_id = 3 AND site_id = 1 in /home/xx/xx/xx/public_html/lib/DatabaseConnection.php on line 188, referer: https://xx.com/index.php?m=import&a=massImportEdit&postback=1&documentID=34
Is the server time and timezone on OpenCATS correct?
Yes, I made sure to set the server time zone.