ERPNext 15 bench database restore = Internal Server Error

ERPNext
, ,
1

Hello dear reader thank you for being here :sunny:

When downloading the database backup from ERPNext and casually restoring it via bench to a new site like advised in the documentation I get following salad:

ERPNext

grafik
grafik1296×259 24.8 KB

bench

erpnext@vmd66950:~/frappe-bench$ bench --site site15p.local restore /home/erpnext/1.sql.gz
Table `tabDefaultValue` not found in file.
Traceback (most recent call last):
  File "<frozen runpy>", line 198, in _run_module_as_main
  File "<frozen runpy>", line 88, in _run_code
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 114, in <module>
    main()
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 20, in main
    click.Group(commands=commands)(prog_name="bench")
  File "/home/erpnext/frappe-bench/env/lib/python3.11/site-packages/click/core.py", line 1157, in __call__
    return self.main(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/erpnext/frappe-bench/env/lib/python3.11/site-packages/click/core.py", line 1078, in main
    rv = self.invoke(ctx)
         ^^^^^^^^^^^^^^^^
  File "/home/erpnext/frappe-bench/env/lib/python3.11/site-packages/click/core.py", line 1688, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/erpnext/frappe-bench/env/lib/python3.11/site-packages/click/core.py", line 1688, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/erpnext/frappe-bench/env/lib/python3.11/site-packages/click/core.py", line 1434, in invoke
    return ctx.invoke(self.callback, **ctx.params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/erpnext/frappe-bench/env/lib/python3.11/site-packages/click/core.py", line 783, in invoke
    return __callback(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/erpnext/frappe-bench/env/lib/python3.11/site-packages/click/decorators.py", line 33, in new_func
    return f(get_current_context(), *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/commands/__init__.py", line 29, in _func
    ret = f(frappe._dict(ctx.obj), *args, **kwargs)
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/commands/site.py", line 147, in restore
    _restore(
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/commands/site.py", line 235, in _restore
    validate_database_sql(decompressed_file_name, _raise=not force)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/installer.py", line 879, in validate_database_sql
    raise frappe.InvalidDatabaseFile
frappe.exceptions.InvalidDatabaseFile

grafik

Salad is nice and all, but not on my bench. Is the downloaded file from the ERPNext web view not viable? Why are public files, private files & config not available onsite either?

Environment 1: Frappecloud (backup)
Environment 2: Debian 12 (restore)
Fresh install of: Frappe 15 ; ERPNext 15 (running errorless)

1 Like