OpenCATS icon indicating copy to clipboard operation
OpenCATS copied to clipboard

Error while importing candidate CV in bulk

Open ztobs opened this issue 5 years ago • 2 comments

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

ztobs avatar Apr 14 '20 16:04 ztobs

Is the server time and timezone on OpenCATS correct?

cptr13 avatar May 08 '20 15:05 cptr13

Yes, I made sure to set the server time zone.

ztobs avatar May 08 '20 19:05 ztobs