582761 - schematic migration on support-stage

Status: VERIFIED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Paul Craciunoiu [:paulc]]

Getting this error on support-stage:

DatabaseError: (1146, "Table 'support_stage_new_mozilla_com.upload_imageattachment' doesn't exist")


* Did schematic run? Check the database with:
** SELECT version FROM schema_version
* If it didn't run (version < 22), please run it.

Comment 1

[Rebecca Billings [:rbillings]]

This is blocking testing

Comment 2

[Dave Miller [:justdave]]

schema_version = 21.

Needs the upgrade script run.

Comment 3

[Dave Miller [:justdave]]

where do I find the upgrade script?  I don't see it in an obvious place in the docroot

Comment 4

[Paul Craciunoiu [:paulc]]

(In reply to comment #3)
> where do I find the upgrade script?  I don't see it in an obvious place in the
> docroot
Once you're in the virtualenv for kitsune you can just run |schematic migrations|

Comment 5

[Dave Miller [:justdave]]

found the script at kitsune/22-image-upload.sql

It's been run.

From what I gather that should have been at kitsune/migrations/22-image-upload.sql

Comment 6

[Paul Craciunoiu [:paulc]]

Yeah, sorry about that.

Seems like I screwed up and forgot to put the migration in the proper folder. It's there now:
http://github.com/jsocol/kitsune/commit/fec585f97d29b26b0e8b5d5b0d958a5c246b3165

Thanks Dave!

Comment 7

[Rebecca Billings [:rbillings]]

Verified- yay!