penguin8r wrote on Wednesday, April 02, 2008:
using OpenEMR 2.8.4-dev pulled from CVS yesterday, if you use the List editor under the admin options & attempt to add anything to the lists, it spits out an Insert error, & then it blanks the list out! All the entries in the list disappear. This happened with the Ethnicity & Language lists both. How do I get some data back in those lists? Manually insert it from MySQL or is there a way to fix it from within OpenEMR?
sunsetsystems wrote on Wednesday, April 02, 2008:
Please post the complete error message.
For manually restoring a list, you can find the relevant insert statements in sql/database.sql.
Thanks,
penguin8r wrote on Wednesday, April 02, 2008:
Thanks Rod! I found it & fixed it. The insert statement in the OpenEMR code seems to try to describe 6 fields in the ‘list_options’ table in the openemr database, when there are actually only 5 fields there. Not a big deal, just don’t try to edit lists from the admin module & you’ll be OK.
sunsetsystems wrote on Thursday, April 03, 2008:
There are 6 columns in that table now… sounds like you created your database before that was finished.
penguin8r wrote on Thursday, April 03, 2008:
I was wondering about that, this was an upgrade from a previous 2.8.4 CVS install, but I ran the DB upgrade script so I thought that would take care of it. Guess I better check it out again…