DB Error while trying to install V6 with an existing DB

[Reynaldo_Angeles]

How would I go about fixing this error. Right now we are running version 5.2 and we are trying to upgrade to version 6. Well more like installing the new version with an existing DB. While trying to do so I get this error.

ERROR. unable to execute SQL: 'DROP TABLE IF EXISTS patient_data’ due to: Cannot delete or update a parent row: a foreign key constraint fails

[juggernautsei (Sherwin Gaddis)]

Process is usually the way to fix something like this. The process I take when upgrading is this.

1. Export the current database into an SQL file
2. Do a full install of the newer version and creating a new database
3. Truncate the new database and import the previous database into the new
4. Run sql_upgrade.php

This is what I do for a major version upgrade.

[Reynaldo_Angeles]

Thanks for the step by step process. You wouldn’t happen to know how to reset the TOTP Verification?

[stephenwaite]

HELP! Can't access due to 2FA

I found the solution by myself! Let me explain it here, just in case someone has the same problem: Followed these instructions: https://www.open-emr.org/wiki/index.php/FAQ#What_do_I_do_if_I_am_locked_out_of_OpenEMR.3F Open login_mfa_registrations MySQL table. Leave all fields blank and save. Log in to OpenEMR with the usual username and the password “pass” (as instructions above) Change user’s password for a new one.

[Reynaldo_Angeles]

Thank You! I really appreciate this as I couldn’t find a fix for this anywhere.

[stephenwaite]

all the thanks goes to @joanwilly