516052 - Run runonce/upgrade_versions.py on preview db

Status: VERIFIED FIXED

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

Description

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

runonce/upgrade_versions.py needs to be run on the previewdb...

Comment 1

[Stephen Donner [:stephend] Not actively reading bugmail]

QA: verify that advanced-search URL such as https://preview.addons.mozilla.org/en-US/firefox/search?q=adblock+plus&cat=all&as=1&appid=1&lver=3.5&atype=0&pp=20&pid=0&sort=&lup= work.

Comment 2

[chizu]

oremj says this was run.

Comment 3

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

Reoppening, not sure why it didn't apply, but:

the versions table shouldn't have null items in the version_int column:

http://pastebin.mozilla.org/671200

If I can get DB write access, I can do this myself.

Comment 4

[Wil Clouser [:clouserw]]

This is blocking QA.  Marking as major.

Comment 5

[Dave Miller [:justdave]]

>>> from upgrade_versions import translate
>>> translate("0.8")
'00080000200100'
>>> translate("1.6")
'01060000200100'

Looks like it translates those two correctly in the script...

looking in the database, the entire column is NULL.   Looks to me like it didn't actually get run.  FWIW, that column does have valid data in it in production, so maybe it got ran there instead?

Anyhow, I just ran it on preview, and it appears to have updated.

Comment 6

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

Thanks - that did the trick:

https://preview.addons.mozilla.org/en-US/firefox/search?q=adblock+plus&cat=all&as=1&appid=1&lver=3.5&atype=0&pp=20&pid=0&sort=&lup=

This version specific search now works.

Comment 7

[Stephen Donner [:stephend] Not actively reading bugmail]

w00t, yay; https://preview.addons.mozilla.org/en-US/firefox/search?q=adblock+plus&cat=all&as=1&appid=1&lver=3.5&atype=0&pp=20&pid=0&sort=&lup does indeed work, thanks!