summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authortimeless%mozdev.org <>2005-01-14 18:49:45 +0100
committertimeless%mozdev.org <>2005-01-14 18:49:45 +0100
commit9212ac2e14c788abc3d585f12888df501d45686a (patch)
tree5ab4861956b4d533f00c9071e80fd62fef99e86a
parent427d238b1a9d03d2da9f561f3abc3b14eb95bf59 (diff)
downloadbugzilla-9212ac2e14c788abc3d585f12888df501d45686a.tar.gz
bugzilla-9212ac2e14c788abc3d585f12888df501d45686a.tar.xz
Bug 276237 Charting is completely broken - can't add datasets to list
patch by Nick.Barnes@pobox.com r=mkanat r=justdave a=justdave
-rwxr-xr-xchecksetup.pl12
1 files changed, 8 insertions, 4 deletions
diff --git a/checksetup.pl b/checksetup.pl
index 865c22a43..bf193497a 100755
--- a/checksetup.pl
+++ b/checksetup.pl
@@ -3992,11 +3992,15 @@ if (TableExists("user_series_map")) {
RenameField('series_categories', 'category_id', 'id');
AddField("series", "public", "tinyint(1) not null default 0");
-
+
# Migrate public-ness across from user_series_map to new field
- $dbh->do("UPDATE series SET series.public = 1 " .
- "WHERE series.series_id = user_series_map.series_id " .
- " AND user_series_map.user_id = 0");
+ $sth = $dbh->prepare("SELECT series_id from user_series_map " .
+ "WHERE user_id = 0");
+ $sth->execute();
+ while (my ($public_series_id) = $sth->fetchrow_array()) {
+ $dbh->do("UPDATE series SET public = 1 " .
+ "WHERE series_id = $public_series_id");
+ }
$dbh->do("DROP TABLE user_series_map");
}