Fixing corrupt SQLITE database in home-assistant

sudo apt-get install sqlite3

Enter config dir of home-assistant

cd/home/homeassistant/.homeassistant
 sudo systemctl stop home-assistant@homeassistant.service

sqlite3 home-assistant_v2.db

Windows 10 / Cortana search not working

Many people are having issues with Windows 10 search not working.
After having tried "everything", I found an sollution.

So I will start with what worked for me:

Scanning for messed up stuff pt. 1 

1. Press Windows + X from desktop.
2. Then click on Windows Powershell (Admin)
3. Then type in sfc /scannow and press Enter

Wait...
If it works, you're done! If not, continue below!

Index rebuild

1) Run file explorer
2) click adress bar of file explorer, type in control p, click on "control panel"
3) choose view as large icons
4) choose indexing options
5) choose advanced
6) choose rebuild

If this also doesent work, in the same indexing options window you have a "Troubleshoot search and indexing", choose what your problem is, say yes to run as administrator and choose problem again.

If still it doesent work, continue reading...

Regedit

1. inside the powershell admin you started earlier, type regedit
2. go to Computer\HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Run
3. add new String with value C:\Windows\System32\ctfmon.exe
4. go to Computer\HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Search
5. add if missing REG_DWORD BingSearchEnabled, set value to 1
6. add if missing REG_DWORD CortanaConsent, set value to 1

If everything is still broken, try scanning for messed up stuff pt. 2

1. Go back to the powershell admin started earlier
2. DISM.exe /Online /Cleanup-image /Scanhealth
3. DISM.exe /Online /Cleanup-image /Restorehealth