501025 - Collections marked as favorites sometimes appear in the Addon Collector, sometimes not.

Status: RESOLVED DUPLICATE of bug 513100

(addons.mozilla.org Graveyard :: Collector Extension, defect)

Description

[Manuel Brotz]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.11) Gecko/2009060308 Ubuntu/9.04 (jaunty) Firefox/3.0.11
Build Identifier: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.11) Gecko/2009060308 Ubuntu/9.04 (jaunty) Firefox/3.0.11

I did make some collections, all works great. But when i mark them as favorites, they sometimes appear in the Addon Collector, sometimes not. I have tried different strategies to get them displayed, but nothing works. Hitting the reload-button in the Addon Collector doesnt help. Also logout and then login doesnt help.

Thats very frustrating, they just wont appear.

Reproducible: Always

Steps to Reproduce:
Happens every time i use the Addon Collector.



Some additional information about my configuration, given from the extension "MR Tech Toolkit":

Created: Mon Jun 29 2009 00:33:01 GMT+0200 (CEST)
UserAgent-String: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.11) Gecko/2009060308 Ubuntu/9.04 (jaunty) Firefox/3.0.11
Build-ID: 2009060308

Activated Extensions: [26]
- Adblock Plus 1.0.2: http://adblockplus.org/
- Add Bookmark Here ² 3.5.20090621: https://addons.mozilla.org/firefox/addon/3880
- Add-on-Sammler 1.0.3: http://www.google.com/search?q=Firefox%20Add-on-Sammler
- BetterPrivacy 1.29: http://netticat.ath.cx/extensions.html
- CodeBurner for Firebug 1.1: http://tools.sitepoint.com/codeburner
- Copy Links 0.1.6: http://ku.myftp.org/
- Cycle Input Focus 1.0.0: http://www.google.com/search?q=Firefox%20Cycle%20Input%20Focus
- Download Statusbar 0.9.6.5: http://downloadstatusbar.mozdev.org/
- Firebug 1.3.3: http://www.getfirebug.com/
- Ghostery 1.5.1: http://www.google.com/search?q=Firefox%20Ghostery
- JSView 2.0.5: http://forum.softwareblaze.com
- Link Alert 0.8.2.1: http://linkalert.googlepages.com/
- Locationbar² 1.0.3: http://design-noir.de/mozilla/locationbar2/
- Menu Editor 1.2.6: http://menueditor.mozdev.org/
- MR Tech Toolkit 6.0.3.3: http://www.mrtech.com/extensions/
- NoScript 1.9.3.3: http://noscript.net
- NoSquint 2.0b5: http://urandom.ca/nosquint/
- Organize Status Bar 0.6.3: http://yellow5.us/firefox/osb/
- PDF Download 2.2.0.2: http://www.pdfdownload.org
- Tab Mix Plus 0.3.7.3: http://tmp.garyr.net
- Text2Link 1.9.2: http://text2link.jeffreyjmorgan.com/
- Update Notifier 0.1.5.4: http://www.longfocus.com/firefox/updatenotifier
- Update Scanner 3.0.4: http://updatescanner.mozdev.org
- View Source Chart 2.7: http://jennifermadden.com
- Web Developer 1.1.6: http://chrispederick.com/work/web-developer/
- Xmarks 3.1.1: http://www.xmarks.com/

Deactivated Extensions: [2]
- All-in-One Sidebar 0.7.10: http://firefox.exxile.net/aios
- Ubuntu Firefox Modifications 0.7: http://www.google.com/search?q=Firefox%20Ubuntu%20Firefox%20Modifications

Total Extensions: 28

Installed Themes: [1]
- Default: http://www.mozilla.org/

Installed Plugins: (7)
- Default Plugin
- Demo Print Plugin for unix/linux
- DivX® Web Player
- QuickTime Plug-in 7.2.0
- Shockwave Flash
- VLC Multimedia Plugin (compatible Totem 2.26.1)
- Windows Media Player Plug-in 10 (compatible; Totem)

Comment 1

[Manuel Brotz]

Now i have created a new profile with the profile manager, and then i have installed the Addon Collector and logged in. Then all collections, which i have marked as favorites appeared!!! So i have uninstalled and reinstalled the Addon Collector in my default profile and logged in, but it didnt help!

Comment 2

[Brian King [:kinger]]

Dave,

This sounds like a corrupted DB in the first profile to me. Can you suggest any remedies?

Comment 3

[David McNamara [:mackers]]

(In reply to comment #2)
> This sounds like a corrupted DB in the first profile to me. Can you suggest any
> remedies?

Yes, you could be right. Deleting the sqlite file should fix it. 

Please remove the files in the following directory and restart firefox.

~/.firefox/Profiles/xxx/[e-mail]*

Comment 4

[Manuel Brotz]

Hi

Thank you very much! You were right!
Deleting the DB fixed it! :)

But this case should be recognized by the Addon Collector and automatically fixed.
If possible.

Greetz M. Brotz

Comment 5

[David McNamara [:mackers]]

I'm not sure the correct behaviour for this.

We could:

1) delete the corrupt sqlite file when we can't open it.

2) delete the sqlite file on extension uninstall so at least a reinstall fixes the problem.

3) both of these.

Comment 6

[Fred Wenzel [:wenzel]]

If the DB does not contain data that's irreplaceable (i.e., if it'll just be rebuilt with info from the web app), I'd vote for both.

Comment 7

[David McNamara [:mackers]]

Yes, the DB is purely a cache. The data will be replaced with content retrieved via the API.

Comment 8

[Philipp Bödeker]

got the same problem on Windows XP.
first the collections appeared then they didnt, then i made a new collection and it appeared again but now again its broken.
Also the names of my Collections in the 'Send To' Menu have old names and vary in count.
ill try deleteing the sql file now.

Comment 9

[jens persson]

I'm having this or some related problem on two hosts:

 * Ubuntu Gnu/Linux 9.04 - Firefox 3.5.2
 * Windows XP - Firefox 3.5.2

I have tried deleting the database on the windows host but it did not help :-(
the database reappear though.

I have not tried to create a new profile.

Se also my comments on bug 499900

Comment 10

[jens persson]

My problem seems to be the one described in 507236, when having illegal characters in the collection names ( ' in Web Developer's Toolbox) removing that collection everything works perfectly.

Comment 11

[David McNamara [:mackers]]

I suspect one of the changes I checked in for bug 507236 (r48616) might also help with this.

Comment 12

[Philipp Bödeker]

removing Web Developer's Toolbox doesnt help here
though now i dont have fav collections with probably illegal characters

Comment 13

[David McNamara [:mackers]]

Version 1.0.4 of the Add-on Collector has been released, possibly fixing this problem for some users. Please try it out:

https://addons.mozilla.org/en-US/firefox/addon/11950