After upgrade system would not boot reinstalled using 11.6 now cannot see Systems page

[JNoble921]

Hello,

Thank you for any help with this.

Recently I update to 11.2 beta and then I was not able to boot my machine.

I "upgraded" to 11.1 u 6, everything appears to be fine however when I open the web interface I get the following message when I open the System tab.

Code:

Environment:

Software Version: FreeNAS-11.1-U6 (caffd76fa)
Request Method: GET
Request URL: https://192.168.1.10/system/


Traceback:
File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
  64.				 return self.cursor.execute(sql, params)
File "./freenasUI/freeadmin/sqlite3_ha/base.py" in execute
  412.		 execute = self.locked_retry(Database.Cursor.execute, query, params)
File "./freenasUI/freeadmin/sqlite3_ha/base.py" in locked_retry
  389.				 rv = method(self, *args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/django/core/handlers/exception.py" in inner
  42.			 response = get_response(request)
File "/usr/local/lib/python3.6/site-packages/django/core/handlers/base.py" in _legacy_get_response
  249.			 response = self._get_response(request)
File "/usr/local/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response
  178.			 response = middleware_method(request, callback, callback_args, callback_kwargs)
File "./freenasUI/freeadmin/middleware.py" in process_view
  162.		 return login_required(view_func)(request, *view_args, **view_kwargs)
File "/usr/local/lib/python3.6/site-packages/django/contrib/auth/decorators.py" in _wrapped_view
  23.				 return view_func(request, *args, **kwargs)
File "./freenasUI/system/views.py" in home
  685.	 tabs = appPool.hook_app_tabs('system', request)
File "./freenasUI/freeadmin/apppool.py" in hook_app_tabs
  61.		 return self._get_array('hook_app_tabs', name, request)
File "./freenasUI/freeadmin/apppool.py" in _get_array
  27.				 method(arr, func(*args, **kwargs))
File "./freenasUI/system/hook.py" in hook_app_tabs_system
  71.					 obj = model.objects.order_by('-id')[0]
File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py" in __getitem__
  295.		 return list(qs)[0]
File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py" in __iter__
  256.		 self._fetch_all()
File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py" in _fetch_all
  1087.			 self._result_cache = list(self.iterator())
File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py" in __iter__
  54.		 results = compiler.execute_sql()
File "/usr/local/lib/python3.6/site-packages/django/db/models/sql/compiler.py" in execute_sql
  835.			 cursor.execute(sql, params)
File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
  64.				 return self.cursor.execute(sql, params)
File "/usr/local/lib/python3.6/site-packages/django/db/utils.py" in __exit__
  94.				 six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/local/lib/python3.6/site-packages/django/utils/six.py" in reraise
  685.			 raise value.with_traceback(tb)
File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
  64.				 return self.cursor.execute(sql, params)
File "./freenasUI/freeadmin/sqlite3_ha/base.py" in execute
  412.		 execute = self.locked_retry(Database.Cursor.execute, query, params)
File "./freenasUI/freeadmin/sqlite3_ha/base.py" in locked_retry
  389.				 rv = method(self, *args, **kwargs)

Exception Type: OperationalError at /system/
Exception Value: no such column: system_advanced.adv_consolescreensaver

 

[dlavigne]

How did you upgrade exactly? You can't go from 11.2 back to 11.1, unless you reboot into an existing 11.1 boot environment or reinstall.

 

[JNoble921]

I upgraded to 11.2 using the web interface

Then I was not able to boot.

Then I downloaded 11.1 iso from the site burned it to a DVD. Then booted up using that and did the upgrade option to maintain my configuration.

Now I get the above error message when I log in.

I hope this answers your question. It is confusing. Thank you very much for asking and helping.

 

[pschatz100]

If you can save your configuration, then do so. It is always a good idea to have a backup of your configuration.

You did not say what version you were running when you upgraded to 11.2, but can you reboot back into that version? If yes, then maybe you can do that and then run the upgrade to 11.1. Another option - if you have saved your configuration - would be to do a clean install of 11.1 (or 11.2beta if you want that version) and then restore the configuration.

If you search the forum, there are lots of threads that talk about this. It is not difficult.

 

[JNoble921]

I ended up getting a copy of my config and clean installing 11.1 u 5 or u 6 and then using the old configuration

 

[pschatz100]

Sometimes a clean install is the best way to go...

Glad you got your problem resolved.