292140 - List of Newest extensions is different on index.php vs. showlist.php and rss/index.php

Status: RESOLVED INVALID

(addons.mozilla.org Graveyard :: Public Pages, defect)

Description

[Jason Chu]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8b2) Gecko/20050422 Firefox/1.0+
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8b2) Gecko/20050422 Firefox/1.0+

Currently, the list of Newest extensions at extensions/index.php lists the most
recently added or updated extensions.  However, the lists of Newest extensions
at extensions/showlist.php?category=Newest and rss/index.php?list=newest list
the most recently added extensions only (not updated ones).  For example,
currently the first item on extensions/index.php is Auto Reset Browser 0.1.1
which was an update but the first item on the other lists is Whois Lookup 0.1
which was a new extension.  In fact, the faulty lists do not ever show version
0.1.1 of Auto Reset Browser, only the version when the extension was initially
added to the DB.

Can't really tell why yet without access to a test DB but it seems that the
GROUP BY clause at
http://lxr.mozilla.org/update1.0/source/extensions/showlist.php#147 is causing
the problems with showlist.php and it seems that using main.DateAdded instead of
version.DateAdded (like the other 2 queries are doing) at
http://lxr.mozilla.org/update1.0/source/rss/index.php#95 is causing the problems
with rss/index.php.

Reproducible: Always

Comment 1

[Colin Ogilvie [:cso]]

I think this is a duplicate of bug 278281, certainly from discussion on IRC it
seemed to have the same cause.

*** This bug has been marked as a duplicate of 278281 ***

Comment 2

[Colin Ogilvie [:cso]]

(In reply to comment #0)
> Can't really tell why yet without access to a test DB but it seems that the
> GROUP BY clause at
> http://lxr.mozilla.org/update1.0/source/extensions/showlist.php#147 is causing
> the problems with showlist.php and it seems that using main.DateAdded instead of
> version.DateAdded (like the other 2 queries are doing) at
> http://lxr.mozilla.org/update1.0/source/rss/index.php#95 is causing the problems
> with rss/index.php.

Think the problem is more deep-rooted than this, as neither of these fixes
produce the results I was expecting. Removing the |GROUP BY| means the query
fails. I have a rogue extension in the RSS feed as well, thats not elsewhere.

I'll reopen this, as I'm not convinced its a duplicate now.

The

Comment 3

[Gabriel Seah]

16th January 2006, 2:58AM GMT:

10 Newest Firefox Extensions listing (https://addons.mozilla.org/extensions/?application=firefox):
   1. deviantART : Koh33 Extension 0.2, January 16, 2006
   2. Tab Mix Plus 0.3, January 16, 2006
   3. Amazing webpage emailer 0.91, January 15, 2006
   4. MediaPlayerConnectivity 0.5.0, January 15, 2006
   5. KwikSearch 0.5, January 15, 2006
   6. Gmail Manager 0.4.2, January 15, 2006
   7. FlagFox II 2.2.1, January 15, 2006
   8. Bookmarks LinkChecker 0.6.8.2, January 15, 2006
   9. Ambience 0.4, January 15, 2006
  10. PageStyle2Tab 0.6.3, January 15, 2006

Extensions - List - Newest - Page 1 (https://addons.mozilla.org/extensions/showlist.php?application=firefox&category=Newest):

1. KwikSearch 0.5
2. Ambience 0.4
3. Quick Preference Button 0.0.9
4. VietTrans Extension 1.0
5. ImageBot 2.0.0
6. InTranslate 0.1a
7. Go To Yahoo! 0.5
8. PingPong 0.3
9. FlyyyStatusBar 0.83
10. TheGamerNation Forums Browser 0.1.1

RSS feed (https://addons.mozilla.org/rss/?application=firefox&type=E&list=newest):

1. KwikSearch 0.5 for Firefox
2. VietTrans Extension 1.0 for Firefox
3. FlyyyStatusBar 0.83 for Firefox
4. TheGamerNation Forums Browser 0.1.1 for Firefox
5. ViewMyCurrency 0.38 for Firefox
6. Backgroundimage Saver 0.1 for Firefox
7. Quick Preference Button 0.0.9 for Firefox
8. Hexult 1.1 for Firefox
9. Closy 1.0.0 for Firefox
10. FlagFox II 2.1.1 for Firefox


Please confirm, thank you.

Comment 4

[Micah Bucy]

the extensions on https://addons.mozilla.org/extensions/?application=firefox is currently

   1. FoxGame 1.0.1, February 01, 2006
   2. TimeTracker 1.0.1, January 20, 2006
   3. Adblock Plus 0.6, January 17, 2006
   4. Wizz RSS News Reader 0.3.3, December 23, 2004
   5. Status-bar Calculator 0.9, February 21, 2006
   6. Traction Control 1.01, January 28, 2006
   7. Forecastfox l10n 0.7.2006012201, February 08, 2006
   8. Internote 1.0, February 07, 2006
   9. Furlan (fur) Language Pack 1.5, February 11, 2006
  10. termBlaster Firefox Extension 1.0b.2, December 23, 2005

Now its even worse than it was, ones dating back to 2004 definitely should not be on here.  Currently on https://addons.mozilla.org/extensions/showlist.php?application=firefox&category=Newest

  1. duimShow 0.2.0
  2. Gmail Skins 0.9
  3. printclose 1.0
  4. BrowseAtWork 0.3
  5. Photo Map 0.73
  6. Ynet Helper 0.1
  7. AOL Toolbar 1.0.6
  8. easyGestures 3.3
  9. Status-bar Calculator 0.9
 10. Stylish 0.2.1

Currently RSS matches https://addons.mozilla.org/extensions/?application=firefox


      

Comment 5

[Michael Morgan [:morgamic]]

AMO BUGSPAM FOR COMPONENT MOVE AND DELETE (FILTER ME)