ajperezcrespo wrote on Monday, March 21, 2005:
Error: INSERT INTO categories SET name=‘X Rays’, value=’’, lft=‘11’, rght=‘12’, parent=‘1’, id=‘3’ :: Duplicate entry ‘3’ for key 1
Thanks
ajperezcrespo wrote on Monday, March 21, 2005:
Error: INSERT INTO categories SET name=‘X Rays’, value=’’, lft=‘11’, rght=‘12’, parent=‘1’, id=‘3’ :: Duplicate entry ‘3’ for key 1
Thanks
sunsetsystems wrote on Monday, March 21, 2005:
Sounds like you need to modify the categories_seq table and set the "id" value to something greater than or equal to the largest ID used in the categories table.
– Rod
rod at sunsetsystems dot com
ajperezcrespo wrote on Tuesday, March 22, 2005:
Thanks
openemr wrote on Friday, June 10, 2005:
Hi Alfonso,
I ran into this also, one of my staff solved it very singlemindly by attempting it 4-5 times on the fifth attempt it worked…
an openemr user
ps and yes the above categories_seq table mod is the correct fix…