Error in execution of <bleachbit.Command.Function instance>

[daniel CURTIS]

Hi.

A couple of weeks ago, I've started to notice an error message during cleaning files (right after BleachBit scan result) etc. It's a red font message, at the beginning of the removing process. I have no idea what is the reason and what could have had an impact on this issue. Error message is related to the Firefox v58.0.2 (earlier versions also) and '@USER/.mozilla/firefox/*.default/places.sqlite' file.

● An error in a BleachBit window:

Error in execution of <bleachbit.Command.Function instance at 0xb553b80c>
Traceback (most recent call last):
  File "/usr/share/bleachbit/bleachbit/Worker.py", line 84, in execute
    for ret in cmd.execute(self.really_delete):
  File "/usr/share/bleachbit/bleachbit/Command.py", line 146, in execute
    self.func(self.path)
  File "/usr/share/bleachbit/bleachbit/Special.py", line 280, in delete_mozilla_url_history
    FileUtilities.execute_sqlite3(path, cmds)
  File "/usr/share/bleachbit/bleachbit/FileUtilities.py", line 307, in execute_sqlite3
    '%s: %s' % (Common.decode_str(exc), path))
DatabaseError: no such table: moz_favicons: /home/test1/.mozilla/firefox/*.default/places.sqlite

● A console error - the same time as above message (`sudo bleachbit` command):

debug: DeepScan.scan: searches= {'/home/test1': [u'^~wr[a-z][0-9]{4}\\.tmp$', u'^ppt[0-9]{4}\\.tmp$']}
Error in execution of <bleachbit.Command.Function instance at 0xb553b80c>
Traceback (most recent call last):
  File "/usr/share/bleachbit/bleachbit/Worker.py", line 84, in execute
    for ret in cmd.execute(self.really_delete):
  File "/usr/share/bleachbit/bleachbit/Command.py", line 146, in execute
    self.func(self.path)
  File "/usr/share/bleachbit/bleachbit/Special.py", line 280, in delete_mozilla_url_history
    FileUtilities.execute_sqlite3(path, cmds)
  File "/usr/share/bleachbit/bleachbit/FileUtilities.py", line 307, in execute_sqlite3
    '%s: %s' % (Common.decode_str(exc), path))
DatabaseError: no such table: moz_favicons: /home/test1/.mozilla/firefox/*.default/places.sqlite
debug: DeepScan.scan: searches= {'/home/test1': [u'^~wr[a-z][0-9]{4}\\.tmp$', u'^ppt[0-9]{4}\\.tmp$']}

However, even with above error messages, BleachBit continue to work and remove all the files etc. (Please note also, that not every file can be and is removed, due to the "permission denied" message, when BleachBit is not running, executed as the superuser via sudo(8). In such a case, it's let say: 68/170 files deleted.) Here are some technical informations (if something more is needed, please let me know):

✗ Release (`lsb_release -rd` command):
    Description: Ubuntu 16.04.4 LTS
    Release: 16.04
✗ Linux: 4.4.0-116-generic (i386/x86_32)
✗ BleachBit: 1.10-1
✗ python3.5: 3.5.2-2ubuntu0~16.04.4

Thanks, best regards.

[Andrew Ziem (ahziem1)]

I see you are using the old BleachBit 1.10. Please note that Ubuntu repositories often have ancient versions of BleachBit because they do not update them except with a new Ubuntu release. The latest Ubuntu release will have a new version of BleachBit, but the older Ubuntu versions have old versions of BleachBit.

This is problematic because Ubuntu updates the browsers, and new versions of browsers sometimes require code changes in BleachBit to support them.

Sorry if this is a rant. :)

Anyway, the error about moz_favicons was fixed in the new release: https://www.bleachbit.org/news/bleachbit-20 . This site always has the latest version of BleachBit, and it has .deb packages for easily installation on Ubuntu.

[daniel CURTIS (anoda)]

Hello Andrew. Thanks for an answer and I'm sorry - I should check blechabit.org website first. Yes, I know, that Ubuntu, especially an "older" releases, often have an ancient versions etc. Anyway, "no such table: moz_favicons for some Firefox profiles" error is fixed in BleachBit v2.0, so there is one solution: install a new version directly from website, because the latest version available in Ubuntu is v1.15-2 ("Bionic").

Once again; thank You very much.

[daniel CURTIS (anoda)]

Bleachbit v2.0 contains a fix for DatabaseError: "no such table: moz_favicons for some Firefox profiles".