using search bar in file explorer locks up explorer (searchapp.exe fault) windows 10

I had a machine that kept crashing when you put anything in the search bar in file explorer. After digging through the event viewer I found a couple errors related to explorer and searchapp.exe.

The program explorer.exe version 10.0.19041.3031 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Security and Maintenance control panel.
Process ID: eb0
Start Time: 01da64db37e76e8d
Termination Time: 0
Application Path: C:\Windows\explorer.exe
Report Id: d463be71-c367-4d54-880b-949063fd7db7
Faulting package full name:
Faulting package-relative application ID:
Hang type: Cross-process

Followed by another error

Faulting application name: SearchApp.exe, version: 10.0.19041.3031, time stamp: 0x30ed67b0
Faulting module name: KERNELBASE.dll, version: 10.0.19041.3086, time stamp: 0xe1ac3f79
Exception code: 0xc000027b
Fault offset: 0x000000000012d8b2
Faulting process id: 0x2d74
Faulting application start time: 0x01da64fa00f853da
Faulting application path: C:\WINDOWS\SystemApps\Microsoft.Windows.Search_cw5n1h2txyewy\SearchApp.exe
Faulting module path: C:\WINDOWS\System32\KERNELBASE.dll
Report Id: 2ba6b73b-8e4b-48d0-8c47-0feb8675b02a
Faulting package full name: Microsoft.Windows.Search_1.14.10.19041_neutral_neutral_cw5n1h2txyewy
Faulting package-relative application ID: CortanaUI

After a little digging I found this post on tenforums because of finding the searchapp.exe crash logs, not from searching “file explorer crashes when using search” which was my initial approach. So hopefully this helps someone who’s having difficulty fixing this issue, and trying my way first.

  1. 1.
    1. Click/tap on the Download button below to download the file below.
    The downloadble .reg file below will delete the registry key below.
    2. Save the .reg file to your desktop.
    3. Double click/tap on the downloaded .reg file to merge it.
    4. When prompted, click/tap on RunYes (UAC), Yes, and OK to approve the merge.
    5. restart pc to apply
    6. You can now delete the downloaded .reg file if you like.
  2. 2.
    1 .Click/tap on the Download button below to download the .bat file below.
    Contents of the .bat file for reference:
    @echo off
    REG ADD "HKCU\Software\Microsoft\Windows\CurrentVersion\ImmersiveShell\StateStore" /V ResetCache /T REG_DWORD /D 1 /F
    taskkill /f /im explorer.exe
    start explorer.exe
    2. Save the .bat file to your desktop. 3. Unblock the .bat file. 4. Run the .bat file. 5. You will now notice your screen flicker as a command prompt quickly opens and closes to run the command to reset the live tile cache, then restarts the explorer process to apply.

    As the original post on tenforums mentioned, don’t forget to restart the computer after applying the fixes. Again, credit to the guys over on tenforums for coming up with the fix, files linked here  just in case the posts disappear.

    Thanks for reading,
    Ross Bannister

mysql error 1356 references invalid table(s) or column(s) or function(s) or definer/invoker of view webmin

Long story short, I recovered a mysql backup from my old LAMP server and afterwards I kept getting a view error when editing users. After many hours of trying to find a fix I was about to dump and rebuild the mysql.user schema since it was what was messed up since it had old user rights and everything from my old server. I googled for hours and hours trying to fix it finally what did it was one simple command….

mysql_upgrade --force

boom user view worked
boom I can edit and add users again through the webmin interface.
Thanks for reading hope this helped!

How to get Motorola CPS radio programming software.

I was looking for dealers to help get me setup with Motorola’s programming software so I could program some Motorola cp200d’s myself. I stumbled upon North Georgia Communications. The President of the company replied fast requesting more information, I called and got more information from him including directions on how to pay. Just a heads up, you are not paying him for the software, you’re paying for instructions on how to obtain the software. The President of the company Ken is pretty full of himself, but does supply some good information. What my $103 got me was a copy of cps 2.0 and instructions on how to get an account to activate it. More or less you are paying him for his expertise on how to obtain it and operate it to program your radios if you aren’t good at reading documentation.
tl;dr no dealers can sell Motorola software it must be purchased from the official Motorola shop online. This is not disclosed before the purchase, they waited to tell that tidbit till after.

below is exactly what he sends when you purchase “the software” from him.
backup download

Automate picture and video offloading!

When I would come home from hunting and it came time to offload all the video and from my cameras I’d have to sit there and manually copy the files over and wait, then swap cards, manually copy and wait, I generally have 4 cards to offload upto 100GB of data at a time. So I decided to look into how to automate it all, first thing that came to mind was autorun but apparently it has been removed from usb devices in newer versions of windows. After come googling I came across a software that brings autorun back to windows, called “APO USB Autorun” [link to download below].

I decided to play around with this new software a bit and though to myself if each device just had a script on it that moved all the files over with an autorun function boom I could just pop the cards in and let it do its thing automatically!

One downside with this method is you have to use a USB card reader, and you have to plug the card reader in, to the usb port, not just plug the sd card into the reader, so keep that in mind.

Below is the code in its entirety what you want to do is make both files in the base directory of your SD card one named “filecopy.bat” and “autorun.inf” an easy way to do this is to right click in the directory and go to New>Text Document and replace the NewTextDocument.txt with the required file names.

After you have the files created open autorun.inf with notepad or notepad++ and paste this into it.


Save that file, then do the same for filecopy.bat

@echo off
::>>time and date stamp YYYYMMDD, HHMMSS and YYYY-MM-DD_HH-MM-SS
for /f "delims=" %%a in ('wmic OS Get localdatetime  ^| find "."') do set dt=%%a
set datestamp=%dt:~0,8%
set timestamp=%dt:~8,6%
set YYYY=%dt:~0,4%
set MM=%dt:~4,2%
set DD=%dt:~6,2%
set HH=%dt:~8,2%
set HH=%dt:~8,2%
set Min=%dt:~10,2%
set Sec=%dt:~12,2%
set stamp=%MM%-%DD%-%YYYY%
::uncomment next 2 lines to preview the date stamp
::echo %stamp%
::>>creates subfolder under date for camera, leave blank if you want all pictures in one directory
set camname=nikon
::>>destination location of your video files \cameraname\ should be uniquie per camera name so files are organized by camera
set servpath=\\server\pictures\%stamp%\%camname%\
::>>source location of video files %cd% automatically uses your sd cards drive letter including first slash E.G. G:\
set vidpath="%cd%DCIM\100NIKON"
::>> creates new directory in the offload folder with the date and camera subfolder
if not exist "%servpath%" mkdir "%servpath%"
::>> copies files from %vidpath% to %servpath%
copy "%vidpath%" "%servpath%"
::>> creates temp directory for text comparison files if it doesnt exist
if not exist "%cd%temp" mkdir %cd%temp\
::>>writing a text file containing all the file contents from vidpath and servpath
dir "%vidpath%" /-p /a-d /o:gn | FIND "/" > %cd%temp\DirContents.txt
dir "%servpath%" /-p /a-d /o:gn | FIND "/" > %cd%temp\servercp.txt
::>> comparing file contents of both directories to make sure they mattch before wiping the card
::>> then if file lists and sizes dont match it goes down to :files_differ and deletes temp folder and files from %vidpath%
fc /b %cd%temp\servercp.txt %cd%temp\DirContents.txt > nul
if errorlevel 1 goto files_differ
::>> if all files and filesizes match in %vidpath% and %servpath% then it deletes the originals from %vidpath% then removes temp folder
del /q "%vidpath%\*"
rmdir /q /s "%cd%temp"
::>> uncomment next line to get verification message
::msg %username% copy success!
::>> if copy failed this removes the temp directory and the new subfolder in
rmdir /q/s "%cd%temp"
rmdir /q /s "%servpath%"
::>> uncomment next line to get fail message
::msg %username% Copy failed please retry

it’s pretty much self explanatory the only things you need to touch are below, and I think I commented everything well enough.

  • set camname=nikon
  • set servpath=\server\pictures\%stamp%\%camname%\
  • set vidpath=”%cd%DCIM\100NIKON\”

“camname=camnamehere” This setting will only add a folder for a certain camera in the dated folder where pictures/videos are dumped. EG C:/pix/01/14/2020/camnamehere/ so you want to be sure to use different names on each SD card if you want them organized.
“set servpath=\server\pictures\%stamp%\%camname%\” This setting represents the base folder where you would like to dump pictures/videos to EG mines in a windows share on my server called pictures.
“set vidpath=”%cd%DCIM\100NIKON\”” This setting tells the script where your pictures are on the SD card. LEAVE %CD% and do not add a backslash after it this is a variable that automatically puts your drive letter in, so if your card looks like this on your pc D:\DCIM\100NIKON and that’s the folder the pictures are in that is what you will type “%cd%DCIM\100NIKON\”

Upon completion of configuring the batch file and the file, go ahead and install “APO USB Autorun” which can be found HERE, unplug your card reader and plug it back in, it should start copying!

Tip, to do multiple at once, get a usb hub and multiple readers then just plug the hub in it should run the script on all drives when they are all detected.

Invoice Plane: mPDF taking a long time to generate pdf files remotely

I had an issue where if I was using my outside domain address to connect to the web server it would take roughly 4 minutes to generate a PDF after googling for what seemed like an eternity I saw something that caught my eye in a random discussion about mPDF not related to invoice plane.

So, firstly PDF’s generate fine when using a local address eg but if i connected to it using it would take minutes to generate a PDF or send an email with PDF attached.

SOLUTION: enable SSL on the web server and connect using https, yes its that simple that solved my issues all together.

dumb short topic i know, but holy cow it took me forever to find that fix and it had nothing to do with invoice plane so hopefully someone having the same issue finds this and it helps.

Thank you for reading!

Current Server Setup 2/18/2018

Man its changing quickly figured it deserved another post since I’ve added another server into the mix to handle the video camera recording. Reason being using Intel Quicksink on the newer Intel cpu’s takes a huge load off of the cpu and saves a ton in power consumption, also I wanted to learn how Active Directory and Domain Controllers worked.

Server 1:

The OG server is running server 2012 r2 Datacenter with hyper-v for the virtual machines.
For main storage there is an array of 5x 2TB hitachi drives in Raid 5. contacam has its own 1tb blue. There is a 2tb WD green I use to offload raw footage from my cameras onto, finally the operating system with the rest of the vm disks are on a WD Blue 1TB SSD

Continue reading “Current Server Setup 2/18/2018”

Setting up Transmission and OpenVPN on Debian using only CLI, with auto start and VPN up check script. Private Internet Access

To begin, lets start with installing Transmission and OpenVPN.
To install Transmission

sudo apt install transmission-daemon

Once it is installed you will want to access the web GUI from another machine so lets go into the settings.json and tweak a few things so you can access it. 

First we need to stop transmission 

sudo service transmission-daemon stop

Then with your favorite editor go ahead and open the settings file, I prefer nano so 

nano /etc/transmission-daemon/settings.json

We need to just change a couple lines, where I have 192.168.10.* type your lan range be it 192.161.* or 192.168.0.* the * is a wildcard that will let anyone on your lan access the transmission web-GUI.

“rpc-authentication-required”: false,
“rpc-bind-address”: “”,
“rpc-enabled”: true,
“rpc-whitelist”: “192.168.10.*”,

Continue reading “Setting up Transmission and OpenVPN on Debian using only CLI, with auto start and VPN up check script. Private Internet Access”

How did I miss?

I think I have the buck I shot last year haunting me, I cannot for the life of me slow down and concentrate on what im doing, 3 weekends in a row shot and missed 3 deer from not taking an extra half a second to make sure im using the correct range marker in my scope that buck fever tho.

Hopefully i can get past this i had it really bad for 3 years with rifle, after i harvested my first deer i haven’t got buck fever with a rifle since. It’s pretty rough knowing that in the last 3 weekends i could have put 3 deer in the freezer but my nerves caused me to lose out. 

Two of the three deer ive shot at were at 30 yds and for some reason I used the 20 yd marker for both, shot went right under. Then the one i had at 20 yds…… i used the 30 yd marker. In practice I don’t have any issues ranging and shooting guess i just need more practice. Thanks for reading and watching! More videos coming soon.

Current Server Setup 11/1/2018

The server has changed in many ways since its first build with an old 775 socket celeron and 2gb of ram, to a dual xeon 771 setup, to a dual 6 coreopteron with 32gb of ram, back to a xeon 771 with 32gb of ram, and now its an i3-2120 i5-2400 with 16gb of ddr3 ram.

The server is running server 2012 r2 Datacenter with hyper-v for the virtual machines. here is a quick rundown of the virtual machines.

For main storage there is an array of 5x 2TB hitachi drives in Raid 5. contacam has its own 1tb blue, lancache has its own 300GB 10k velociraptor, there is a 500GB seagate I keep images of most of the vm’s on. finally the operating system with the rest of the vm disks are on a samsung 250GB samsung SSD.

Contacam: Running windows 10 ltsb and contacam software to manage my home security cameras. [4 cores 1GB-4GB dynamic meory]  
switched from contacam to motioneye in a docker, much less resources pretty cool webgui overall better imo.

switched from contacam to motioneye in a docker, much less resources pretty cool webgui overall better imo.

Continue reading “Current Server Setup 11/1/2018”