The problematic field was mainly the person.birthdate, which was all set to
0000-00-00 instead of NULL (beside others, having a strange default date as
well).
Adding &zeroDateTimeBehavior=convertToNull to the jdbc connection string in
the openmrs-runtime.properties might solve it, as mentioned somewhere before
on the mailing list.
I found that when doing a clean installation of OMRS 1.8.3, the default
timestamp values of some of the fields in obs, encounter and person have a
strange default value ('0002-11-30 00:00:00'):
(Taken from the mysql manager client, after the setup):
encounter:
`encounter_datetime` datetime NOT NULL DEFAULT '0002-11-30 00:00:00',
`date_created` datetime NOT NULL DEFAULT '0002-11-30 00:00:00',
obs:
`date_created` datetime NOT NULL DEFAULT '0002-11-30 00:00:00',
`obs_datetime` datetime NOT NULL DEFAULT '0002-11-30 00:00:00',
My table settings:
InnoDB, Encoding: UTF-8 Unicode (utf8), Collation: utf8_general_ci
On Tue, 24 Apr 2012 21:09:17 -0700, Darius Jazayeri
<[email protected]> wrote:
>Hi Jonathan,
>
>At the root of the error message is: Caused by: java.sql.SQLException:
>Cannot convert value '0000-00-00' from column 4 to TIMESTAMP
>
>You must have some (illegal) dates in your database that are set to zero.
>Is this something you can clean up?
>
>-Darius
>
>On Tue, Apr 24, 2012 at 8:43 PM, Jonathan Galingan
<[email protected]>wrote:
>
>> I tried:
>>
>> curl -i -u "admin:Password1"
>> http://localhost:8080/openmrs/ws/rest/v1/patient?q=123
>>
>> and it worked
>>
>> I tried:
>>
>> curl -i -u "admin:Password1"
>> http://localhost:8080/openmrs/ws/rest/v1/patient?q=john
>> and I get this error
>> http://justpaste.it/xhr
>>
>> I tried:
>> curl -i -u "admin:Password1"
>> http://localhost:8080/openmrs/ws/rest/v1/patient?q=james
>> and I get the same error
>>
>> but if I tried:
>> curl -i -u "admin:Password1"
>> http://localhost:8080/openmrs/ws/rest/v1/patient?q=jam
>> it works
>>
>> I think this is a bug with the web service. Could anybody interpret the
>> error? thanks
>>
>>
>> On Tue, Apr 17, 2012 at 6:12 AM, Jonathan Galingan
<[email protected]>wrote:
>>
>>> Oh. I see. I think I've got it. Thanks a lot.
>>>
>>> The switch to patient did the trick.
>>>
>>>
>>> On Tue, Apr 17, 2012 at 2:44 AM, Darius Jazayeri
<[email protected]
>>> > wrote:
>>>
>>>> Hi Jonathan,
>>>>
>>>> Are you intentionally using the person resource rather than the patient
>>>> one? Because for 95% of use cases, the patient resource is the right
one.
>>>> (Also, you can't search on the person resource for patient ids.)
>>>>
>>>> I peeked quickly at the code, and I think the person resource delegates
>>>> its searching
>>>> to org.openmrs.api.db.hibernate.HibernatePersonDAO.getPeople(String,
>>>> Boolean). This method *does* look at the given, middle, family, and
>>>> family2 name components. If you're actually intending to search via the
>>>> person resource, and you're really seeing this bug, I'll research further.
>>>>
>>>> Assuming you actually want the patient resource, as far as I know
>>>> whatever you pass as its q parameter is treated identically to the patient
>>>> search box in OpenMRS. (I.e. you can find partial names, or exact
>>>> identifiers)
>>>>
>>>> -Darius
>>>>
>>>> On Mon, Apr 16, 2012 at 11:29 AM, Jonathan Galingan <
>>>> [email protected]> wrote:
>>>>
>>>>> When I tried:
>>>>> http://localhost:8080/openmrs/ws/rest/v1/person?q=john
>>>>>
>>>>> it only searched through patients that have a given name "john" . I
>>>>> wanted to also get people with the middle name or last name of
"Johnson"
>>>>> Would anybody know how to make the webservices do that?
>>>>>
>>>>> I then tried:
>>>>> http://localhost:8080/openmrs/ws/rest/v1/person?q=john_smith
>>>>>
>>>>> it now searched through patients that have a given name "john" while
>>>>> the middle name or last name is "smith." Is it possible to make this to
>>>>> return a patient named "smith Johnson"?
>>>>>
>>>>> For the identifier I tried:
>>>>> http://localhost:8080/openmrs/ws/rest/v1/person?q=123
>>>>>
>>>>> I have a patient with an id of "123" but it did not search for it.
>>>>> Would I need to change the q to something else?
>>>>>
>>>>> On Mon, Apr 16, 2012 at 9:39 PM, Friedman, Roger (CDC/CGH/DGHA)
(CTR) <
>>>>> [email protected]> wrote:
>>>>>
>>>>>> the q parameter will search both name and ID. i would search on id
>>>>>> and then verify that the name returned is the one expected.****
>>>>>>
>>>>>> ** **
>>>>>>
>>>>>> *From:* [email protected]
[mailto:[email protected]] *On
>>>>>> Behalf Of *Jonathan Galingan
>>>>>> *Sent:* Sunday, April 15, 2012 8:46 PM
>>>>>> *To:* [email protected]
>>>>>> *Subject:* [OPENMRS-IMPLEMENTERS] Help with webservices****
>>>>>>
>>>>>> ** **
>>>>>>
>>>>>> Hi, I'm trying to replicate the patient search box of OpenMRS in
>>>>>> OpenERP to integrate the two. ****
>>>>>>
>>>>>> ** **
>>>>>>
>>>>>> Would anybody know how a complete name with identifier could be
>>>>>> searched through the webservices?****
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Jonathan D. Galingan, MD****
>>>>>>
>>>>>> Project Manager for Computerization****
>>>>>>
>>>>>> Philippine General Hospital****
>>>>>>
>>>>>> ** **
>>>>>> ------------------------------
>>>>>>
>>>>>> Click here to unsubscribe<[email protected]?
body=SIGNOFF%20openmrs-implement-l>from OpenMRS Implementers' mailing
list
>>>>>> ****
>>>>>> ------------------------------
>>>>>> Click here to unsubscribe<[email protected]?
body=SIGNOFF%20openmrs-implement-l>from OpenMRS Implementers' mailing
list
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Jonathan D. Galingan, MD
>>>>> Project Manager for Computerization
>>>>> Philippine General Hospital
>>>>>
>>>>> ------------------------------
>>>>> Click here to unsubscribe<[email protected]?
body=SIGNOFF%20openmrs-implement-l>from OpenMRS Implementers' mailing
list
>>>>>
>>>>
>>>> ------------------------------
>>>> Click here to unsubscribe<[email protected]?
body=SIGNOFF%20openmrs-implement-l>from OpenMRS Implementers' mailing
list
>>>>
>>>
>>>
>>>
>>> --
>>> Jonathan D. Galingan, MD
>>> Project Manager for Computerization
>>> Philippine General Hospital
>>>
>>>
>>
>>
>> --
>> Jonathan D. Galingan, MD
>> Project Manager for Computerization
>> Philippine General Hospital
>>
>> ------------------------------
>> Click here to unsubscribe<[email protected]?
body=SIGNOFF%20openmrs-implement-l>from OpenMRS Implementers' mailing
list
>>
>
>_________________________________________
>
>To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to
[email protected] with "SIGNOFF openmrs-implement-l" in the
body (not the subject) of your e-mail.
>
>[mailto:[email protected]?body=SIGNOFF%20openmrs-
implement-l]
>
_________________________________________
To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to
[email protected] with "SIGNOFF openmrs-implement-l" in the body
(not the subject) of your e-mail.
[mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]
