Column 'modifier' cannot be null

Management and Administration
1

juggernautsei wrote on Tuesday, June 14, 2016:

When we try to post a payment by clicking the Payment button in the left nav with the defaults in place and entering a check number we get the error below. What are we doing incorrectly?

ERROR: insert failed: INSERT INTO ar_activity (pid,encounter,code_type,code,modifier,payer_type,post_time,post_user,session_id,pay_amount,account_code) VALUES (?,?,?,?,?,0,now(),?,?,?,‘PCP’)

Error: Column ‘modifier’ cannot be null

/var/www/html/openemr/library/sql.inc at 627:sqlInsert
/var/www/html/openemr/interface/patient_file/front_payment.php at 202:idSqlStatement(INSERT INTO ar_activity (pid,encounter,code_type,code,modifier,payer_type,post_time,post_user,session_id,pay_amount,account_code) VALUES (?,?,?,?,?,0,now(),?,?,?,‘PCP’),Array)

2

osverdlov wrote on Tuesday, June 14, 2016:

Sherwin, what version do you use?

3

juggernautsei wrote on Wednesday, June 15, 2016:

4.2.1 and I have tried the 4.2.2 and it does the same thing.

4

teryhill wrote on Wednesday, June 15, 2016:

Sherwin can you tell me the steps you are using to get the error. I have 6 installs on 4.2.1 and none of them have reported any problem.

Terry

5

juggernautsei wrote on Wednesday, June 15, 2016:

Here is the video

Funny thing is that it does not happen all the time. I have tried the same steps in other installations and no problem. But it is reproducable. It is random. Can’t quite figure out what causing it.

6

osverdlov wrote on Wednesday, June 15, 2016:

Do you see any warnings or notices in PHP log?

7

juggernautsei wrote on Wednesday, June 15, 2016:

Unfortunately no.