#111 ERROR: insert failed: INSERT INTO patient_data

[Mauricio Gomez]

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

[Mauricio Gomez]

[Mauricio Gomez]

Sorry I did not comment: it is happen when I try insert a patient. Could anybody help me ? Thanks in advance !

[Brady Miller]

hey,

Need some mroe info:
Operating system, OpenEMR version and package (source vs xampp vs ubuntu vs package)

Ensure your php.ini settings are correct:
http://www.openmedsoftware.org/wiki/FAQ#What_are_the_correct_PHP_settings_.28can_be_found_in_the_php.ini_file.29_.3F

I am guessing you problems will lie in your mysql configuration file. What is your 'sql-mode' setting in this file?

-brady

[Mauricio Gomez]

Brady

Fist of all thanks a lot for your support !

Like you told me...

1) I will ensure my php.ini settings are correct ( http://www.openmedsoftware.org/wiki/FAQ#What_are_the_correct_PHP_settings_.28can_be_found_in_the_php.ini_file.29_.3F )

2) I will check in my mysql configuration file. What
is my 'sql-mode' setting in this file?

After that, I will let you know what I got.

Thanks and regards.

Mauricio.

[Mauricio Gomez]

Brady

It works now thanks a lot for your support !

I checked in my mysql configuration file and commented this line with semi-colon:
# Set the SQL mode to strict
;sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Thanks again and regards, Mauricio from Argentina.