Oh well. It was a valiant try at conversion, but it blew up when trying to execute the “Migrating site site1.local”
I believe this is where it was trying to migrate the fresh v12 site down to v11 using the version-11 branches. I never got to the point of a downgraded v11 system to be able to restore the v11 database.
Here is the failure trace:
yarn install v1.17.3
[1/4] Resolving packages...
[2/4] Fetching packages...
[3/4] Linking dependencies...
warning "rollup-plugin-vue > @vue/component-compiler@3.4.4" has unmet peer dependency "postcss@>=6.0".
[4/4] Building fresh packages...
Done in 103.76s.
Patching sites...
Migrating site1.local
Traceback (most recent call last):
File "/usr/lib/python3.6/runpy.py", line 193, in _run_module_as_main
"__main__", mod_spec)
File "/usr/lib/python3.6/runpy.py", line 85, in _run_code
exec(code, run_globals)
File "/home/erp_jmi/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 97, in <module>
main()
File "/home/erp_jmi/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 18, in main
click.Group(commands=commands)(prog_name='bench')
File "/home/erp_jmi/frappe-bench/env/lib/python3.6/site-packages/click/core.py", line 764, in __call__
return self.main(*args, **kwargs)
File "/home/erp_jmi/frappe-bench/env/lib/python3.6/site-packages/click/core.py", line 717, in main
rv = self.invoke(ctx)
File "/home/erp_jmi/frappe-bench/env/lib/python3.6/site-packages/click/core.py", line 1137, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/home/erp_jmi/frappe-bench/env/lib/python3.6/site-packages/click/core.py", line 1137, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/home/erp_jmi/frappe-bench/env/lib/python3.6/site-packages/click/core.py", line 956, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/home/erp_jmi/frappe-bench/env/lib/python3.6/site-packages/click/core.py", line 555, in invoke
return callback(*args, **kwargs)
File "/home/erp_jmi/frappe-bench/env/lib/python3.6/site-packages/click/decorators.py", line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File "/home/erp_jmi/frappe-bench/apps/frappe/frappe/commands/__init__.py", line 25, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File "/home/erp_jmi/frappe-bench/apps/frappe/frappe/commands/site.py", line 227, in migrate
migrate(context.verbose, rebuild_website=rebuild_website)
File "/home/erp_jmi/frappe-bench/apps/frappe/frappe/migrate.py", line 44, in migrate
frappe.get_attr(fn)()
File "/home/erp_jmi/frappe-bench/apps/frappe/frappe/patches/v11_0/sync_user_permission_doctype_before_migrate.py", line 6, in execute
frappe.reload_doc('core', 'doctype', 'user_permission')
File "/home/erp_jmi/frappe-bench/apps/frappe/frappe/__init__.py", line 799, in reload_doc
return frappe.modules.reload_doc(module, dt, dn, force=force, reset_permissions=reset_permissions)
File "/home/erp_jmi/frappe-bench/apps/frappe/frappe/modules/utils.py", line 160, in reload_doc
return import_files(module, dt, dn, force=force, reset_permissions=reset_permissions)
File "/home/erp_jmi/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 26, in import_files
reset_permissions=reset_permissions)
File "/home/erp_jmi/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 31, in import_file
ret = import_file_by_path(path, force, pre_process=pre_process, reset_permissions=reset_permissions)
File "/home/erp_jmi/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 65, in import_file_by_path
ignore_version=ignore_version, reset_permissions=reset_permissions)
File "/home/erp_jmi/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 132, in import_doc
doc.insert()
File "/home/erp_jmi/frappe-bench/apps/frappe/frappe/model/document.py", line 241, in insert
d.db_insert()
File "/home/erp_jmi/frappe-bench/apps/frappe/frappe/model/base_document.py", line 312, in db_insert
), list(d.values()))
File "/home/erp_jmi/frappe-bench/apps/frappe/frappe/database.py", line 199, in sql
self._cursor.execute(query, values)
File "/home/erp_jmi/frappe-bench/env/lib/python3.6/site-packages/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/home/erp_jmi/frappe-bench/env/lib/python3.6/site-packages/pymysql/cursors.py", line 328, in _query
conn.query(q)
File "/home/erp_jmi/frappe-bench/env/lib/python3.6/site-packages/pymysql/connections.py", line 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/erp_jmi/frappe-bench/env/lib/python3.6/site-packages/pymysql/connections.py", line 732, in _read_query_result
result.read()
File "/home/erp_jmi/frappe-bench/env/lib/python3.6/site-packages/pymysql/connections.py", line 1075, in read
first_packet = self.connection._read_packet()
File "/home/erp_jmi/frappe-bench/env/lib/python3.6/site-packages/pymysql/connections.py", line 684, in _read_packet
packet.check_error()
File "/home/erp_jmi/frappe-bench/env/lib/python3.6/site-packages/pymysql/protocol.py", line 220, in check_error
err.raise_mysql_exception(self._data)
File "/home/erp_jmi/frappe-bench/env/lib/python3.6/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.IntegrityError: (1048, "Column 'show_preview_popup' cannot be null")
erp_jmi@v12:~/frappe-bench$
I am not able to decipher the source of the underlying problem, but it looks like something has changed in v12 that it can no longer be downgraded to v11 (just my guess).
Hmm… once it is broken like this you cannot get it back either. Going to have to strip the server and start over.
BKM