diff options
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/class/update.class.php | 35 |
1 files changed, 34 insertions, 1 deletions
diff --git a/lib/class/update.class.php b/lib/class/update.class.php index 9ccd966b..bd1be7af 100644 --- a/lib/class/update.class.php +++ b/lib/class/update.class.php @@ -210,6 +210,11 @@ class Update { $version[] = array('version' => '340005','description' => $update_string); + $update_string = '- Remove Random Method config option, ended up being useless.<br />' . + '- Check and change album_data.art to a MEDIUMBLOB if needed.<br />'; + + $version[] = array('version' => '340006','description' => $update_string); + return $version; } // populate_version @@ -769,9 +774,37 @@ class Update { */ public static function update_340006() { - $sql = "ALTER TABLE `album_data` CHANGE `art` `art` MEDIUMBLOB NULL DEFAULT NULL"; + $sql = "DESCRIBE `album_data`"; + $db_results = Dba::query($sql); + + while ($row = Dba::fetch_assoc($db_results)) { + if ($row['Field'] == 'art' AND $row['Type'] == 'blob') { + $blob_needed = true; + } + } // end while + if ($blob_needed) { + $sql = "ALTER TABLE `album_data` CHANGE `art` `art` MEDIUMBLOB NULL DEFAULT NULL"; + $db_results = Dba::query($sql); + } + + // No matter what remove that random method preference + $sql = "DELETE FROM `preference` WHERE `name`='random_method'"; $db_results = Dba::query($sql); + $sql = "SELECT `id` FROM `user`"; + $db_results = Dba::query($sql); + + User::fix_preferences('-1'); + + while ($r = Dba::fetch_assoc($db_results)) { + User::fix_preferences($r['id']); + } + + self::set_version('db_version','340006'); + + return true; + + } // update_340006 } // end update class |