The One with the Thoughts of Frans

Archive for Software

Fix Firefox Adressbar Autofill Broken

After updating to the latest Firefox ESR 68.8, for some reason my Firefox stopped autofilling the addressbar.

Our first stop lies in Help → Troubleshooting information → Places Database (which will take you to about:support).

Click verify integrity, it will probably detect an issue, and then it claims it will replace it on the next startup.

> Task: checkIntegrity
– Unable to fix corruption, places.sqlite will be replaced on next startup

But oddly enough, nothing of the sort happened! Not to worry, right at the top there’s the profile directory, which indicates where the places.sqlite file can be found. Rename it to something like .bck or .old, or just outright delete it if you don’t care, and success! Everything will be working again.

> Task: checkIntegrity
+ The places.sqlite database is sane
+ The favicons.sqlite database is sane

Unfortunately you’ll have to repopulate the autofill if you take this approach.


But I didn’t want to admit defeat. Surely it can’t be too hard to salvage our old database. As an aside, but not strictly relevant to what I did here, I think it’s always useful to have sqlitebrowser installed. That way you can browse the data and run SQL commands on it. For example, if you open places.sqlite and run PRAGMA integrity_check on it… Oh dear, it says the same thing as Firefox: database disk image is malformed.

But we have a trick up our sleeve: command line SQLite. My initial plan was to play around with export and import to determine where the error was located since SQLite didn’t want to say, but that seemed a bit tedious. Essentially to try it table by table, and once I’d identified the table, basically to keep cutting it in half. But as luck would have it, SQLite 2.29 and higher has a built-in error correction feature. Docs here.

sqlite3 places.sqlite ".recover" | sqlite3 places_fixed.sqlite
Error: near line 378367: NOT NULL constraint failed:

All that was left was to give it a try and all was well with the world again — or at least with Firefox. The SQLite error recovery command found the error and fixed it up all by itself. So now I still have all of my location history. Useful? Maybe not in this particular case, but good to know if anything like this should happen in the future on some more important data.


KOReader 2020.05 “May Storm”

As one of the maintainers of KOReader, a versatile a document and image viewer, I’m proud to announce the latest release.

Good news for Kobo users! There’s a new launcher for apps and scripts called NickelMenu, and it’s supported starting with this version of KOReader.

We’d like to thank all contributors for their efforts. Some highlights since the previous release include:

Full changelogclosed milestone issues

CommentsTags: ,

KOReader 2020.04 “Eating Ghosts”

As one of the maintainers of KOReader, a versatile a document and image viewer, I’m proud to announce the latest release.

koreader-2020 04-coronavirus-evillll

By staying inside and reading, humans have become resistant.

We’d like to thank all contributors for their efforts. Some highlights since the previous release include:

Full changelogclosed milestone issues

CommentsTags: ,

KDE Compact Window Switcher Missing?

Let’s face it, all of KDE’s task switchers other than Compact are awful in varying degrees. Unfortunately I found it to be missing. Luckily the solution is simple on Debian/Ubuntu.

sudo apt-get install kwin-addons

And there you have it. Happy window switching!


KOReader 2020.03 “Skating Bird”

As one of the maintainers of KOReader, a versatile a document and image viewer, I’m proud to announce the latest release.


There’s this upcoming videogame called Skatebird. The demo was quite promising. But what you didn’t know is that many of those birbs read heaps and gobs of classic literature from Project Gutenberg and Just like us!

Quite a bit of effort was put into PocketBook this month to make it more maintainable going forward. By creating our own toolchain (koreader/koxtoolchain#22), we can now build the binaries with an up-to-date GCC instead of the years-old GCC 4.8 in the official toolchain, which was starting to become problematically outdated. This is no panacea; most PocketBook issues are unrelated, but a higher maintenance burden can be quite demotivating and gets in the way of addressing actual issues.

In-page footnotes are now enabled by default (#5908). We’re quite fond of them, but if you’d like to disable them you can do so in the document menu (second from the left in the top menu) → Style tweaksMiscellaneousIn-page footnotes.

We’d like to thank all contributors for their efforts. Some highlights since the previous release include:

  • Make dictionary margin depend on font size (#5865) @Frenzie
  • Footnote popups: CSS: remove some vertical margin (#5863) @poire-z
  • Font menu: show only 5 items per page (#5863) @poire-z
  • Style tweaks: reorganize in submenus, add a few (#5863) @poire-z
  • Get rid of the old PB TC (#5860) @NiLuJe
  • Statistics: revamp settings, add calendar settings (#5867) @poire-z
  • CoverBrowser: fix “Extract and cache” crash (#5874) @poire-z
  • Warn if color rendering is enabled on a grayscale device. (#5871) @NiLuJe
  • TextBoxWidget: handle tabs and tabstops (#5870) @poire-z
  • [Android] Prevent previous book reopening in some situations (#5880) @pazos
  • continuous: do not limit visible area to page area (#5885) @yparitcher
  • Add “message at top of screen” screensaver (#5739) @RenaKunisaki
  • Add support for PocketBook InkPad X (#5890) @KucharczykL
  • Disable HW dithering on Kindle (#5893) @NiLuJe
  • Style tweaks: force List items bullet/decimal style (#5897) @poire-z
  • Migrate books to normalized xpointers (#5897, #5904) @poire-z
    This means highlights should be a lot more stable from now on, across rendering setting changes or rendering engine improvements.
  • kosync: validate username and password against empty/blank strings (#5894) @pazos
  • Avoid writting highlights into read-only PDFs (#5889) @pazos
  • TOC: validate and fix misordered page numbers (#5907) @poire-z
  • Style tweaks: enable EPUB/FB2 in-page footnotes by default (#5908) @poire-z
  • SDL2 MacOS HiDPI (#5917) @magicmirror1365
  • PathChooser: fetch ‘show_hidden’ setting on each use (#5923) @poire-z
  • Correct Frontlight status on suspend when screensaver mode is ‘Leave … (#5928) @clarkspark

Full changelogclosed milestone issues

CommentsTags: ,

Switching Audio Output Devices in Broken Sword 5 (OpenAL)

Shamelessly lifted from Norbert Preining in case I forget. I still haven’t actually continued Broken Sword 5 past the first few rooms, just like a few years ago.

Create a file named ~/.alsoftrc with this in it.


CommentsTags: ,

KOReader 2020.02 “90 % Cocoa”

As one of the maintainers of KOReader, a versatile a document and image viewer, I’m proud to announce the latest release.

Thanks to @tcrs the program has now been ported to the Remarkable (#5828).

Additionally, OTA update reliability should be better from now on, by switching to zsync2 with a few custom patches (#5810). The update from 2019.12 to 2020.01 managed to sometimes trigger an edge condition where the OTA update would just keep looping without ever finishing. Furthermore, the download progress will now be printed directly to the screen on supported devices, so you’ll always know exactly what’s happening.

By switching to the connectivity manager on Android, we should stop falsely triggering an unconnected message in some edge cases such as Ethernet, which you typically don’t see on the platform (#5801).

And as a final little unexpected gift, @poire-z implemented a calendar view for the reading statistics, so you can easily see what you were reading when (#5854).

An illustration of the calendar view.

We’d like to thank all contributors for their efforts. Some highlights since the previous release include:

  • Style tweaks: adds “Enforce steady line heights”
  • Wikipedia Save as EPUB: better gallery rendering
  • cre: default to enable crengine call cache
  • View HTML: adds another extended debug view ((#5800)) @poire-z
  • Update fonts & add Noto Sans Devanagari UI (#5803) @NiLuJe
  • [i18n] GetText: ignore fuzzy strings (#5807) @Frenzie
  • Allow running shell scripts from the FileManager/Favorites (#5804) @NiLuJe
  • Switch to zsync2 (#5810) @NiLuJe
  • Stop using the “calibre catalog” wording (#5813) @NiLuJe
  • File search & BookInfo: Don’t traverse hidden folders if we’re not showing them (#5816) @NiLuJe
  • end of document: add go to beginning (#5814) @yparitcher
  • Some improvements to the file browser speed when very large folders are involved. On a slow Kobo, you’d have needed at least 500 files in one folder to even have a chance to notice. (#5819, #5827) @Frenzie
  • Add “searchable” capabilities to OPDS catalogs (#5823) @bateast
  • Add searchable version of flibusta OPDS catalog (#5826) @avsej
  • android: switch to connectivity manager (#5801) @pazos
  • Remarkable port (#5697, #5828, #5834) @tcrs
  • Open more varieties of CBT with some upstream MuPDF patches (#5835) @q3cpma
  • Don’t waste time on dir/file attributes in subdirs (#5819, #5827, #5858) @Frenzie @yparitcher
  • Print zsync2’s output on screen (#5824) @NiLuJe
    This is really useful because it gives you a much better idea how much time is remaining for an OTA update.
  • skimto: add beginning and end as hold callback (#5820) @yparitcher
  • crengine: various table and other fixes (#5840) @poire-z
  • [doc] Add some basic info on using ffi-cdecl (#5808) @tcrs
  • Footer: bold font option (#5849) @poire-z
  • Spelling: for example, Wi-Fi, turn on/off (#5855, #5855) @comradekingu
  • Statistics: new Calendar view (#5854) @poire-z
  • PRSTUX fixes (#5857) @v01d

Full changelogclosed milestone issues

CommentsTags: ,

KOReader 2020.01 “Indoor”

The KOReader translation project has migrated to Weblate. Please head over there if you’re interested in assisting with localization. More information is available here.

A small fix, but important if you used it, the LoginDialog widget no longer crashes on switching focus (#5749).

We’ve also added Liberapay link (#5770), in the form of a “sponsor” button in the top right here on GitHub. We’ve often received requests for something like this, and the platform looks promising.

We’d like to thank all contributors for their efforts. Some highlights since the previous release include:

  • Weblate migration (#5713, #5719, #5720, #5722, #5734) @Frenzie (hat tip to @yparitcher for some related fixes)

  • Unbreak the KUAL extension (#5715) @NiLuJe

  • [feat] Adds Document> Auto-save book metadata sub-menu (#5687) @poire-z

  • android: import from Storage Access Framework (#5686) @pazos
    Add an option to the filemanager “plus” menu to import files in current path using Android storage access framework.

    The new menu entry will be displayed on Android 4.4+. Once the user select one or more files in the dialog these files will be imported on the specified folder.

    Only supported mimetypes can be imported.

    On folders outside the file sandbox the “import files here” entry will be disabled.

  • Style tweaks: In-page footnotes: add some classic classnames (#5727) @poire-z

  • [feat] Option to change page gap in continuous mode (#5705) @mustafa-001

  • [RTL UI] Bidi-wrap filenames, paths, urls, metadata (#5696) @poire-z
    This also helps correctly displaying RTL and bidi filenames and directories in a LTR UI.

  • PicDocuments: fix crash on hold + pan (#5742) @poire-z

  • android: call EPD test from within KOReader (#5737) @pazos

  • [UX] Footer: add option to set font size (#5736) @robert00s

  • android: share text (#5745) @pazos

  • LoginDialog: fix crash on focus switch (#5749) @poire-z

  • Remove DSCROLL_MODE and DGLOBALGAMMA (#5754) @robert00s

  • Unbreak OTA on Kindle (#5758) @NiLuJe

  • [UX] Footer: add option to set progress bar min width (#5757) @robert00s

  • bump crengine: support inline-block, better text selection (#5763) @poire-z

  • bump android, fixes ntx landscape tearing, thanks to @char11 (#5769) @pazos

  • cre: add toggle-able crengine call cache (#5773) @poire-z

  • [UX] Keyboard for Arabic and languages with Arabic script (#5569) @WaseemAlkurdi

  • Make Inverted Portrait a first-class citizen (#5783) @NiLuJe

  • [UX] Footer: add options to show title and current chapter (#5775) @robert00s

  • [fix, plugin] Evernote exporter only writes one documents clippings when txt export used, rest is ignored (#5774) @mustafa-001

  • add turkish q keyboard layout (#5795) @mustafa-001

Full changelogclosed milestone issues

CommentsTags: ,

Enable 60 Hz and 10-bit (HDR) on 2018 Sony UHD/4k TV

Rather annoyingly, you have to manually turn on “enhanced format” HDMI to actually get that which is advertised on the box. I spent a little while fiddling with different ports, cables and my video card before I finally realized. See here for the full details.

  • Press the HOME button on the remote control
  • Select Settings
  • Select External inputs in the TV category
  • Select HDMI signal format and set to Enhanced format

CommentsTags: , ,

Virtualbox Needs Extension Pack for USB

To share USB in VirtualBox guests, you need to install the extension pack on the host. On Debian, that’s the virtualbox-ext-pack package. At first I thought I needed guest additions or something like that, but that wasn’t the problem.

$ apt show virtualbox-ext-pack
Package: virtualbox-ext-pack
Version: 6.0.12-1
Status: install ok installed
Priority: optional
Section: contrib/misc
Maintainer: Debian Virtualbox Team 
Installed-Size: 130 kB
Pre-Depends: debconf
Depends: virtualbox (>= 6.0.12-dfsg-0~) | virtualbox-6.0, virtualbox (<< 6.0.12-dfsg-z) | virtualbox-6.0, wget, debconf (>= 0.5) | debconf-2.0
Download-Size: unknown
APT-Manual-Installed: yes
APT-Sources: /var/lib/dpkg/status
Description: extra capabilities for VirtualBox, downloader.
 VirtualBox requires an extension pack to provide support for Remote
 Desktop Protocol, USB 2.0, PXE booting for Intel network cards, etc.
 This PUEL-licensed extension pack is free for personal use.
 This package downloads the extension pack from internet during install.

N: There is 1 additional record. Please use the '-a' switch to see it


« Newer EntriesOlder Entries »