FrontAccounting forum — Cannot Add Employee in HRM Module

Re: Cannot Add Employee in HRM Module

2022-12-16T16:34:51Z

I'm getting errors trying to write to the database so I'm unable to update the employees in the HRM module. Any help would be appreciated.

mysqli_connect(): Headers and client library minor version mismatch. Headers:100508 Library:100236 in file: /home/myweb/public_html/acctg2/includes/db/connect_db_mysqli.inc at line 33
/home/myweb/public_html/acctg2/includes/db/connect_db_mysqli.inc:33:    mysqli_connect('localhost','myweb_fron201','36(b1m2S!p','','3306')
/home/myweb/public_html/acctg2/includes/session.inc:579:    set_global_connection()
/home/myweb/public_html/acctg2/modules/FrontHrm/manage/employee.php:16:    include_once('/home/myweb/public_html/acctg2/includes/session.inc')


trigger_error('DATABASE ERROR : Could not write employee data
error code : 1366
 
error message : Incorrect integer value: '' for column `myweb_fron201`.`0_employee`.`emp_id` at row 1

I've done some research on this issue in the FrontAccounting forum. I noticed that this error code in relation to NOT being able to update a database has been in existence since 2008.

Re: Cannot Add Employee in HRM Module

2022-04-21T07:56:30Z

Hello

Please download the latest FrontHrm from this repo and install it manually to avoid the issue:
https://github.com/notrinos/FrontHrm/ar … ads/FA.zip
Read post #1 in THIS THREAD for more detailed instruction.

Regards

Re: Cannot Add Employee in HRM Module

2022-04-19T17:20:53Z

Getting same issue, I am able to create department , Salary scale. But I am not able to create new employee.

When I press "Add New Employee Details" button, nothing happened.

Re: Cannot Add Employee in HRM Module

2022-04-06T11:41:37Z

did you get any way through this?

Re: Cannot Add Employee in HRM Module

2022-01-19T02:42:21Z

boxygen wrote:

Set the debug mode to On and then try again and see the error logs. Share those Logs here.

DATABASE ERROR : Could not write employee data
error code : 1366
error message : Incorrect integer value: '' for column `u9619550_fron771`.`0_employee`.`emp_id` at row 1
sql that failed was : INSERT INTO 0_employee VALUES ('', 'inge', 'indra', '0', '', '', '', '1974-01-19', '', '2021-01-01', '0', '0', '', '')

/home/u9619550/public_html/latihan/includes/errors.inc:208: trigger_error('DATABASE ERROR : Could not write employee data
error code : 1366
error message : Incorrect integer value: '' for column `u9619550_fron771`.`0_employee`.`emp_id` at row 1
sql that failed was : INSERT INTO 0_employee VALUES ('', 'inge', 'indra', '0', '', '', '', '1974-01-19', '', '2021-01-01', '0', '0', '', '')

','256')
/home/u9619550/public_html/latihan/includes/errors.inc:236: display_db_error('Could not write employee data','INSERT INTO 0_employee VALUES ('', 'inge', 'indra', '0', '', '', '', '1974-01-19', '', '2021-01-01', '0', '0', '', '')','')
/home/u9619550/public_html/latihan/includes/db/connect_db_mysqli.inc:91: check_db_error('Could not write employee data','INSERT INTO 0_employee VALUES ('', 'inge', 'indra', '0', '', '', '', '1974-01-19', '', '2021-01-01', '0', '0', '', '')','1')
/home/u9619550/public_html/latihan/modules/FrontHrm/includes/db/employee_db.inc:56: db_query('INSERT INTO 0_employee VALUES ('', 'inge', 'indra', '0', '', '', '', '1974-01-19', '', '2021-01-01', '0', '0', '', '')','Could not write employee data')
/home/u9619550/public_html/latihan/modules/FrontHrm/manage/employee.php:353: write_employee('','inge','indra','0','','','','19/01/1974','','01/01/2021','0','0','','')

Re: Cannot Add Employee in HRM Module

2020-09-01T03:13:39Z

Hi Niyaz, please read post #1 in this thread to get fix for your problem: https://frontaccounting.com/punbb/viewtopic.php?id=6860

Re: Cannot Add Employee in HRM Module

2020-08-19T21:24:05Z

in config.php set

$go_debug = 2;

Re: Cannot Add Employee in HRM Module

2020-08-19T19:04:28Z

Debug Option in Browser or Debug from Setup Option in software. Please help how to do that

Re: Cannot Add Employee in HRM Module

2020-08-18T08:03:44Z

Set the debug mode to On and then try again and see the error logs. Share those Logs here.

Cannot Add Employee in HRM Module

2020-08-17T07:48:22Z

I cannot able to add Employee in HRM . When I tried to click on add. not showing any error message also not making success.

How can I fix?