Internal Server Error in Ubuntu 18.xx

hello to all
I installed erpnext on ubuntu 16, after some times I got Internal Server Errro in my browser,
I thought there is server problem, then Installed ERPnext in a fresh Ubuntu 18.0.4 server, till here is no problem
but when I restored my database the error Internal Server Error raised again.

this is my server memory

server logs

I found other issue related to this problem, most of them says insufficient memory problem
but I have 2 gb memory.

now even if I drop my database still Internal Server Error is showing in the browser

please help

1 Like

can you share logs from ~/frappe-bench/logs/web.error.log

You also have a mysql access denied for root@localhost, so your setup will run into problems later on as well

@saurabh6790 thanks for replying me
sorry before I check your reply I removed the previous erpnext
now I reinstalled erpnext, previously I didn’t run bench migrate.
in this time, after uploading database I run bench --site site_name migrate I got the following error

Executing erpnext.patches.v11_0.rename_supplier_type_to_supplier_group in (71c20db6c21e4ba7)
Traceback (most recent call last):
  File "/usr/lib/python2.7/", line 174, in _run_module_as_main
    "__main__", fname, loader, pkg_name)
  File "/usr/lib/python2.7/", line 72, in _run_code
    exec code in run_globals
  File "/opt/bench/erpnext/apps/frappe/frappe/utils/", line 97, in <module>
  File "/opt/bench/erpnext/apps/frappe/frappe/utils/", line 18, in main
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/", line 722, in __call__
    return self.main(*args, **kwargs)
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/", line 697, in main
    rv = self.invoke(ctx)
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/", line 1066, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/", line 1066, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/", line 895, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/", line 535, in invoke
    return callback(*args, **kwargs)
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/", line 17, in new_func
    return f(get_current_context(), *args, **kwargs)
  File "/opt/bench/erpnext/apps/frappe/frappe/commands/", line 25, in _func
    ret = f(frappe._dict(ctx.obj), *args, **kwargs)
  File "/opt/bench/erpnext/apps/frappe/frappe/commands/", line 222, in migrate
    migrate(context.verbose, rebuild_website=rebuild_website)
  File "/opt/bench/erpnext/apps/frappe/frappe/", line 39, in migrate
  File "/opt/bench/erpnext/apps/frappe/frappe/modules/", line 29, in run_all
    if not run_single(patchmodule = patch):
  File "/opt/bench/erpnext/apps/frappe/frappe/modules/", line 63, in run_single
    return execute_patch(patchmodule, method, methodargs)
  File "/opt/bench/erpnext/apps/frappe/frappe/modules/", line 83, in execute_patch
    frappe.get_attr(patchmodule.split()[0] + ".execute")()
  File "/opt/bench/erpnext/apps/erpnext/erpnext/patches/v11_0/", line 11, in execut                                                                                                                 e
    rename_doc("DocType", "Supplier Type", "Supplier Group", force=True)
  File "/opt/bench/erpnext/apps/frappe/frappe/model/", line 47, in rename_doc
    update_link_field_values(link_fields, old, new, doctype)
  File "/opt/bench/erpnext/apps/frappe/frappe/model/", line 219, in update_link_field_values
    (new, old))
  File "/opt/bench/erpnext/apps/frappe/frappe/", line 199, in sql
    self._cursor.execute(query, values)
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/", line 170, in execute
    result = self._query(query)
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/", line 328, in _query
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/", line 516, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/", line 727, in _read_query_result
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/", line 1066, in read
    first_packet = self.connection._read_packet()
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/", line 683, in _read_packet
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/", line 220, in check_error
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/", line 109, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.InternalError: (1054, u"Unknown column 'reference_doctype' in 'where clause'")

Could you please look at this error,