I got the following error at the time I try insert a patient:

ERROR: insert failed: INSERT INTO patient_data SET pid = '1', date = NOW(), title = 'Mr.', fname = 'Mauricio', mname = '', lname = 'Gomez', pubpid = '54681', DOB = '1978-04-10', sex = 'Male', ss = '', drivers_license = '27500031', status = 'married', genericname1 = '', genericval1 = '', genericname2 = '', genericval2 = '', street = '', city = '', state = '', postal_code = '', country_code = '', contact_relationship = '', phone_contact = '', phone_home = '', phone_biz = '', phone_cell = '', email = '', providerID = '', pharmacy_id = '0', hipaa_notice = '', hipaa_voice = '', hipaa_mail = '', hipaa_allowsms = '', hipaa_allowemail = '', hipaa_message = '', occupation = '', language = '', ethnoracial = '', financial_review = '', family_size = '', monthly_income = '', homeless = '', interpretter = '', migrantseasonal = ''

Error: Out of range value adjusted for column 'providerID' at row 1

I test it over several versions of Open EMR including last.

I have installed the database three times.

It seems a perfect software and my intention is use this in my clinic but before I need to know if last version is stable or have many bugs.

Could anybody help me ? Thanks in advance.

Attach file:

---

  Dibujo.JPG (141.00 KB)

Undoubtedly, technology problems hold you and your company back. That's not good for business and as such it's a great idea to get the problems fixed quickly. For several small companies, small business computer support isn't confined to one person within the company; rather, it is tech support that is called in.

======================
Project Management Software