- 08 Sep 2011, 14:33
#1352
Hi everybody
i m tryind to import a resume through the data import function.
i put the pdf file already in the right folder and CATS detect the file ,
i edit the information for this Resume like the name and lastname and email to let this resume bee a new candidate and then save the information
but wenn a i want to go to step 4 and upload the file i have the exception
MySQL Query Failed: Incorrect datetime value: '2011-09-08T15:30:12+02:00' for column 'date_created' at row 1
UPDATE candidate SET date_created = "2011-09-08T15:30:12+02:00", date_modified = "2011-09-08T15:30:12+02:00" WHERE candidate_id = 2 AND site_id = 1
it look like the function try to update the database with a not valid format for the date.
did anybody had this problem ,
ps i changed the format from date_created from datetime to varchar and then it work , but i m not sure that it can be a good solution because this may cause other problems in other function or pages.
thanks a lot
i m tryind to import a resume through the data import function.
i put the pdf file already in the right folder and CATS detect the file ,
i edit the information for this Resume like the name and lastname and email to let this resume bee a new candidate and then save the information
but wenn a i want to go to step 4 and upload the file i have the exception
MySQL Query Failed: Incorrect datetime value: '2011-09-08T15:30:12+02:00' for column 'date_created' at row 1
UPDATE candidate SET date_created = "2011-09-08T15:30:12+02:00", date_modified = "2011-09-08T15:30:12+02:00" WHERE candidate_id = 2 AND site_id = 1
it look like the function try to update the database with a not valid format for the date.
did anybody had this problem ,
ps i changed the format from date_created from datetime to varchar and then it work , but i m not sure that it can be a good solution because this may cause other problems in other function or pages.
thanks a lot