530008 - [AMO] tm-stage-01 missing test database?

Status: RESOLVED FIXED

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

Description

[Wil Clouser [:clouserw]]

I was looking at the list of dbs in bug 530005 and noticed `addons_reskin-test` wasn't in it.  Tests have been broken on preview for a long time - is it because the database was deleted?

If that database isn't there it should be and it should have test data in it.  If it's empty you should be able to import /site/app/config/sql/remora.sql and then /site/app/tests/data/remora-test-data.sql I think, but it's been a while.  If this isn't the case I'm on IRC and can help.

Comment 1

[matthew zeier [:mrz]]

dave, can you bump this up in your queue?  been here for nearly 1.5 months.

Comment 2

[Dave Miller [:justdave]]

OK, I attempted this finally (really sorry for the delay, it was stupid to let this sit)

The test data import fails with the following error:

ERROR 1136 (21S01) at line 1039: Column count doesn't match value count at row 1

Line 1039 is:
INSERT INTO `tags` VALUES (1,'test',0,'2009-06-30 06:30:36');

Comment 3

[Dave Miller [:justdave]]

The tags table has 5 columns, the test data is only inserting 4.

if I add the modified date to the test data, I then get this error:

ERROR 1136 (21S01) at line 1044: Column count doesn't match value count at row 1

1044 is:
INSERT INTO `users_tags_addons` VALUES (5,1,9,'2009-06-30 18:30:36');

Same issue.

I successfully imported the data by adding an additional date for the modification date column to both of those lines (I just reused the same date that was in the creation date field).   You may want to fix those in SVN though.