Help, I mistakenlly Deleted something in the Database

chope wrote on Saturday, December 06, 2014:

Hello,

Can I get any help, I made a fatal error which is yet to be clear to me how I will be such lame. :(

I mistakenly deleted some database tables, the table I believe is on User info on “WHO” part of the new user registration. Here is the error I am getting.

Error 1

Error 2
Image links

http://s21.postimg.org/6bxphork7/error2.png

Help on how to resolve this will be appreciated.
Thanks.

mdsupport wrote on Saturday, December 06, 2014:

Error message is about a column in patient_data table. If correct, you should look at restoring latest backup.

chope wrote on Sunday, December 07, 2014:

The most unfortunate is that I didn’t have any backup before the incident and I have registered about 50 patients (within 24 hours) before the incident.

sapiens110 wrote on Sunday, December 07, 2014:

To my knowledge, there is not much you can do if the patient_data table is dropped without backup. But I suggest setting up an automated backup or to do it manually on a daily basis( depending on the number of patients). Check out the wiki on backup and restore.

mdsupport wrote on Sunday, December 07, 2014:

@Chope, it would be instructive to the community if you describe how database tables got dropped. With limited pieces of info you provide it is hard to know your options. If you have technical skills, your last resort will be to use log to reconstruct data after you have repaired the database destruction.

Best.

fsgl wrote on Monday, December 08, 2014:

Would suggest:

  1. reconstruct last name column with the Layout Editor, not phpMyAdmin. See attachment.
  2. designate a field as unused, (UOR), in the Editor instead of dropping columns.
  3. backup often & regularly.