672056 - extensions.sqlite broken — results in "you don't have any addons of this type installed" message

Status: VERIFIED DUPLICATE of bug 671894

(Toolkit :: Add-ons Manager, defect)

Description

[Jonathan Protzenko [:protz]]

I remember installing TabMixPlus, but that shouldn't be considered as firm evidence. This resulted in about:addons showing, for the "Extensions" section, a "You don't have any addons of this type installed" message. I, of course, have many addons installed.

I'm on the beta channel. Fiddling around, I first tried deleting extensions.rdf ; didn't help. Went on with deleting extensions.sqlite, and this fixed it. I still have the old extensions.sqlite file, but I'm pretty sure all the tables are empty:
jonathan@ramona:~/.mozilla/firefox/m2zf6dky.default $ sqlite3 extensions.sqlite.bak
SQLite version 3.7.6.3
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
addon              locale             targetApplication
addon_locale       locale_strings     targetPlatform   
sqlite> select * from addon;
sqlite> select * from addon_locale;
sqlite> select * from locale;
sqlite> select * from locale_strings;
sqlite> select * from targetApplication;
sqlite> select * from targetPlatform;
sqlite>

If there's anything I can do to help...

https://support.mozilla.com/en-US/questions/798447#answer-216028
https://support.mozilla.com/en-US/questions/826729

(~10 new people this week for both issues combined, don't know if this is relevant).

Comment 1

[Dave Townsend [:mossop]]

Please attach a copy of extensions.log from your profile folder. Also let us know what extensions you have installed.

Comment 2

[Jonathan Protzenko [:protz]]

Attachment: extensions.log

Here's the list of extensions copy/pasted from about:support

Extensions
      

      
        
          
            
              Name
            
            
              Version
            
            
              Enabled
            
            
              ID
            
          
        
        
        Adblock Plus1.3.9true{d10d0bf8-f5b5-c8b4-a8b2-2b9879e08c5d}Add-on Compatibility [e-mail] Tweaks1.10truejid0-qBnIpLfDFa4LpdrjhAC6vBqN20Q@jetpackChange Panorama [e-mail]0.8truejid1-F9UJ2thwoAm5gQ@jetpackDictionnaire français «Classique»[e-mail]1 by Mozilla [e-mail][e-mail]ökulsárlón Download [e-mail][e-mail] Icon In [e-mail] Mix Plus0.3.8.6true{dc572301-7619-498c-a57d-39143191b318}[e-mail][e-mail] [e-mail] HTTP headers0.17false{8f8fe09b-0bd3-4470-bc1b-8cad42b8203a}SQLite [e-mail][e-mail]

Comment 3

[Jonathan Protzenko [:protz]]

Looks like making sure Ctrl-C copies proper formatting is too hard for about:support. Apparently, I'm expected to use the "Copy information to clipboard button", not do the copy myself.



  Application Basics

        Name
        Firefox

        Version
        6.0

        User Agent
        Mozilla/5.0 (X11; Linux x86_64; rv:6.0) Gecko/20100101 Firefox/6.0

        Profile Directory

          Open Containing Folder

        Enabled Plugins

          about:plugins

        Build Configuration

          about:buildconfig

  Extensions

        Name

        Version

        Enabled

        ID

        Adblock Plus
        1.3.9
        true
        {d10d0bf8-f5b5-c8b4-a8b2-2b9879e08c5d}

        Add-on Compatibility Reporter
        0.8.6
        true
        [e-mail]

        Bugzilla Tweaks
        1.10
        true
        jid0-qBnIpLfDFa4LpdrjhAC6vBqN20Q@jetpack

        Change Panorama Shortcut
        0.1
        true
        [e-mail]

        Collusion
        0.8
        true
        jid1-F9UJ2thwoAm5gQ@jetpack

        Dictionnaire français «Classique»
        4.2
        true
        [e-mail]

        F1 by Mozilla Labs
        0.8.3
        true
        [e-mail]

        Feedback
        1.1.2
        true
        [e-mail]

        Jökulsárlón Download Manager
        0.4
        true
        [e-mail]

        Readability
        1.9
        true
        [e-mail]

        RSS Icon In Awesombar
        1.4
        true
        [e-mail]

        Tab Mix Plus
        0.3.8.6
        true
        {dc572301-7619-498c-a57d-39143191b318}

        Firebug
        1.8.0b5
        false
        [e-mail]

        FireFontFamily
        0.1.1
        false
        [e-mail]

        FoxyProxy Standard
        3.0.1
        false
        [e-mail]

        Live HTTP headers
        0.17
        false
        {8f8fe09b-0bd3-4470-bc1b-8cad42b8203a}

        SQLite Manager
        0.7.5
        false
        [e-mail]

        Zotero
        2.1.8
        false
        [e-mail]

Comment 4

[Dave Townsend [:mossop]]

Looks likely to be a dupe of bug 671894