aethelwulffe wrote on Friday, December 03, 2010:
I have an openemr version (xampp package running on winxp) 3.2.0.
It has been upgraded several times.
Recently, I attempted to do an .odt export of the database, and got a spreadsheet that had a mysql query error saying that users_facility table does not exist. I looked, and only the users_facility.frm file was there, not the rest….and the table does not show up in the database otherwise.
I then copied the xampp directory onto another computer, then started the xampp-control and got the whole shootin’ match moved onto a computer safe to play with.
First, I attempted to add the table, but MyAdmin told me that the table already exists.
I then pulled out the users_facility.frm file, added the table, tried the export…and got a “cannot load page” for the phpMyadmin after selecting the export parameters for .odt
I then downloaded a new xampp package, copied the old files on top of it, and logged in to see if having the three users_facility files helped. No go, right?
Here is the question: How I cleanly re-create the users_facility table?
idea No.1= Re-install a clean xampp package, take notes on the table contents/variables, reload my original database, and re-create the tables? If so, is there anything about the content of the tables I should know? The table isn’t used as far as I know(as per my facility restricition setup in globals.php)
idea No.2= find a way to simply get rid of the conflicting information about the existance of the table in the original database.
Input please folks…I am mostly just an idiot, and help would be appreciated. 