Opening Firefox from the CLI reveals the following as the cause of the error:
Query failed: Error: Error(s) encountered during statement execution: no such table: moz_favicons
The symptoms of this issue are that in the address bar you cannot hit enter to browse to a site/url/address and your history cannot be accessed, nor does your history show up in the address bar when typing previously used addresses.
This usually happens because you've restored places.sqlite from a NEWER version of Firefox where the structure of the database has changed. The solution is to upgrade to a newer version of Firefox.
Eg. your source browser is Firefox Version 65 and your destination was running Firefox 50 so this is why it happens.
firefox, workingopening, cli, reveals, query, encountered, execution, moz_favicons, browse, url, accessed, typing, previously, addresses, ve, restored, sqlite, newer, database, upgrade, eg, browser, destination,