291330 - extensions/showlist.php throwing mySQL error

Status: VERIFIED INVALID

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

Description

[Peter Gahzinia]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.7) Gecko/20050414 Firefox/1.0.3
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.7) Gecko/20050414 Firefox/1.0.3

I have just installed the auto copy extension and have not yet closed Firefox
and reopened it. 

I went to the next page, or possibly two or more pages forward, and in the web
page was this error message:

Warning: Invalid argument supplied for foreach() in
/opt/update/extensions/showlist.php on line 365

and that appeared between the BBCodeXtra 0.2.2 and the bbs2chreader 0.2.0
extensions.

I opened a new instance of firefox, and the error appeared again in the same spot.

Reproducible: Always

Steps to Reproduce:
1. go to
https://addons.update.mozilla.org/extensions/showlist.php?application=firefox&numpg=10&pageid=3
2. The error will appear towards the middle of the page
3.

Actual Results:  
The error appeared in the same place as before.

Expected Results:  
All extensions from 21 - 30 were returned, but I wouldn't expect to be given
that error message.

Comment 1

[Matthias Versen [:Matti]]

That is an error in the page itself (as you can very easy see if you open the
URl in another browser). That means that the product "firefox" is wrong

moving to Update/listings

Comment 2

[alanjstr]

The problem is that the author's account has been deleted.  I'm having justdave
remove the extension, but we'll leave this bug open to fix the php issue.

Comment 3

[alanjstr]

Ok, so we have two problems:
1) Deleting the author should have deleted the extension: Bug 281273
2) The displaying page should have detected that the author was missing and
handled it gracefully

DB Entry cleaned up, so there should be no visual errors right now.