kylenave wrote on Sunday, September 13, 2015:
When I create a new encounter, the encouter form shows a completely different date. The wrong date is NOT the date of another encounter.
Has anyone else seen anything like this?
Thanks.
kylenave wrote on Sunday, September 13, 2015:
As an update - I figured out WHAT is happening but not why.
In the “form_encounter” table, the encounter # started duplicating older encounter numbers.
At around id = 875, the encounter matches id = 152… that is the first time this appears to happen.
153 and 154 are NOT duplicated, but then encoutners 155-163 are all duplicated and then 170-180 are duplicated.
kylenave wrote on Sunday, September 13, 2015:
OK - now I know why…
First, yes, I did inject data directly into the database. I was populating existing data for a practice without knowing that the “sequences” table existed and what is does.
Now I do =)
So now I have some data repairs to make… Hopefully someone else finds this useful.
robertovasquez wrote on Monday, September 14, 2015:
I only know two programmers that will be able to insert data manually without getting errors.