SOLVED: Outlook for mac "outlook can't upgrade your database"

An actual solution to fix the outlook database.

Error: Outlook can't upgrade your database.

Problem: Like a lot of you, I ran into this issue at the worst time possible. I had applied an update to the Office Suite to fix an Excel issue and broke Outlook... My client then tells me she is leaving out of town tomorrow and needs this machine to be working with all her emails accessible by the morning. 

No problem, I set up the account again in a new profile and were good, right? No. 

"Where are all the folders that were On My Mac!??" she says with a panic in her voice. 

I create another new profile and import the one that won't upgrade. The import process goes well and emails and accounts show up but still no "On My Mac" folders recovered. 

Time Machine! I knew time machine would work! 
Enter time machine and restore the profile from last week. Set it as default and try to open; No luck. "Outlook Can't upgrade your database". Back to square one. 

I finally came across a small post on SpiceWorks with someone who actually fixed the issue by forcing outlook to rebuild the database, I will show you how to do this today. 

Solution: The fix is unfortunately quite simple. Go to where the mail database is stored, 
~/Library/Group Containers/UBF8T346G9.Office/Outlook/Outlook 15 Profiles/Main Profile/Data (on mac) and delete or simply move the "Outlook.sqllite" file. Always have backups first. 

Now, assuming you have not changed your default profile, simply open outlook and you should be prompted that there is a problem and outlook needs to rebuild. If you did change your profile, change it back to 'Main Profile'.

This can take a while, mine took ~1hr. After it was done outlook launched and asked to download a bunch of fonts. After downloading, all the accounts and emails were recovered and the "on my mac" section had all the emails and folders the user had setup.

This fix worked for me, I hope it can work for some of you!

Reference: michaelhof : https://community.spiceworks.com/topic/1274738-office-2016-for-mac-manual-database-identity-rebuild  

Solved, Cannot add or change bookmarks in Firefox, Mac.

Cannot add or change bookmarks in Firefox

If you are having the problem of firefox not allowing you to add a bookmark, try the following steps they worked for me. I tried the steps laid out by Mozilla located Here , with little success.

I am using FF Version 51.0, here is what I did.

Locate the users Preferences (HD/Users/UserName/Library/Preferences) folder and open it.

Inside that folder will be .plist files that need to be deleted. Delete any .plist file with mozilla or firefox in the name. These will be recreated when the application opens next.

Open Application support folder (HD/Users/UserName/Library/Application Support). In here will be a folder for Mozilla or Firefox, there may even be a folder for each. Delete the folder(s). 

Launch firefox again, go through the initial setup and see all the problems go away. 

**Note: This will erase all settings and content in firefox. bookmarks, passwords, history, etc...

Move or Delete files with a log. Windows, .BAT

Below are 2 .bat files. One moves files and creates a log of the files moved and the other deletes the files and creates a log.
The way I use this is the backup files go into a folder for offset backups and get copied off site, they then get moved into another folder to store for a longer time and finally deleted after a # of days to preserve space.

MOVE

ECHO OFF

REM Author Daniel Gallant
REM Date Nov, 2016

setlocal ENABLEDELAYEDEXPANSION

REM This program will create a text document with the name of the files older then 'numDays' days, and will then move those files older then 'numDays' days to 'backupArchive'.


REM Change these to:
set "backUpPath=C:\Users\Public\Pictures\Sample Pictures3" REM Specify the folder to move files from
set "logPath=C:\Users\Public\logs" REM Specift the folder to send log file to
set "numDays=2" REM Specify number of days old the files are before they are moved
set "backupArchive=C:\Users\Public\Pictures\archive" REM This is where the files are moved to
set "today=!date:/=-!" REM *DO NOT CHANGE* This is a variable to set todays date in the log file name


REM This lists the files and puts them into a .txt for review after Move.
REM -p= path to backup files; -s= include subdirectiries; -m=type of file to search for; /D=num of days, - means old; /C rum the command in "" from cmd
forfiles -p "%backupPath%" -s -m *.* /D -%numDays% /C "cmd /c echo @path" >> "%logPath%\!today!_Backups-Moved.txt"


REM This command moves the files older then 'numDays'.

forfiles -p "%backupPath%" -s -m *.* /D -%numDays% /C "cmd /c move @path %backupArchive%"



DELETE

@ECHO OFF
REM Author Daniel Gallant
REM Date Nov, 2016

setlocal ENABLEDELAYEDEXPANSION

REM This program will create a text document with the name of the files older then 'numDays' days, and will then delete those files older then 'numDays' days..


REM Change these to:
set "backUpPath=C:\Users\Christian\Pictures" REM Specify the folder to delete files from
set "logPath=C:\Users\Public" REM Specift the folder to send log file to, Folder must be created
set "numDays=30" REM Specify number of days old the files are before they are moved
set "today=!date:/=-!" REM This is a variable to set todays date in the log file name
REM This lists the files and puts them into a .txt for review after delete.
REM -p= path to backup files; -s= include subdirectiries; -m=type of file to search for; /D=num of days, - means old; /C rum the command in "" from cmd
forfiles -p "%backupPath%" -s -m *.* /D -%numDays% /C "cmd /c echo @path" >> "%logPath%\!today!_Backups-Deleted.txt"


REM This command deletes the files older then /D #.

REM forfiles -p "%backupPath%" -s -m *.* /D -%numDays% /C "cmd /c /q del @path"   <- This is for deleting the files.