Missing Column in Installed Application Table After Backup Restore

Lone_Wolf · June 30, 2025, 4:10pm

Is a new column added in Installed Application table?

I’ve recently restored a site from a previous backup and noticed that the has_setup_wizard column is not present in the tabInstalled Application table. However, during the migration process, the following patch was executed:
Executing frappe.patches.v16_0.enable_setup_complete #25-06-2025 re-run-patch in support (_723a9fc7c9bbdeff)

Is this potentially a bug or something that requires manual intervention?

avc · June 30, 2025, 5:03pm

Hi @Lone_Wolf:

Probably related to this

github.com/frappe/frappe

fix: setup wizard broken during site restoration

frappe:develop ← rohitwaghchaure:fixed-suupport-42511

opened 11:01AM - 30 Jun 25 UTC

rohitwaghchaure

+8 -0

``` File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py", line… 904, in remove_from_installed_apps remove_from_installed_apps(app) File "/home/frappe/frappe-bench/apps/frappe/frappe/installer.py", line 362, in remove_from_installed_apps frappe.get_single("Installed Applications").update_versions() File "/home/frappe/frappe-bench/apps/frappe/frappe/core/doctype/installed_applications/installed_applications.py", line 29, in update_versions app_wise_setup_details = self.get_app_wise_setup_details() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/frappe/frappe-bench/apps/frappe/frappe/core/doctype/installed_applications/installed_applications.py", line 55, in get_app_wise_setup_details frappe.get_all( File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 2046, in get_all return get_list(doctype, *args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 2021, in get_list return frappe.model.db_query.DatabaseQuery(doctype).execute(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 191, in execute result = self.build_and_run() ^^^^^^^^^^^^^^^^^^^^ File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 232, in build_and_run return frappe.db.sql( ^^^^^^^^^^^^^^ File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 230, in sql self._cursor.execute(query, values) File "/home/frappe/frappe-bench/env/lib/python3.11/site-packages/pymysql/cursors.py", line 153, in execute result = self._query(query) ^^^^^^^^^^^^^^^^^^ File "/home/frappe/frappe-bench/env/lib/python3.11/site-packages/pymysql/cursors.py", line 322, in _query conn.query(q) File "/home/frappe/frappe-bench/env/lib/python3.11/site-packages/pymysql/connections.py", line 563, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/frappe/frappe-bench/env/lib/python3.11/site-packages/pymysql/connections.py", line 825, in _read_query_result result.read() File "/home/frappe/frappe-bench/env/lib/python3.11/site-packages/pymysql/connections.py", line 1199, in read first_packet = self.connection._read_packet() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/frappe/frappe-bench/env/lib/python3.11/site-packages/pymysql/connections.py", line 775, in _read_packet packet.raise_for_error() File "/home/frappe/frappe-bench/env/lib/python3.11/site-packages/pymysql/protocol.py", line 219, in raise_for_error err.raise_mysql_exception(self._data) File "/home/frappe/frappe-bench/env/lib/python3.11/site-packages/pymysql/err.py", line 150, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1054, "Unknown column 'is_setup_complete' in 'SELECT'") ```

Hope this helps.