Changeset 2188

Timestamp:

09/09/10 04:54:54 (17 months ago)

Author:

shibuya246

Message:

[Branch 1.5] install-upgrade, add fix for alter table, post_title to text

Files:

• branches/1.5/install/install-upgrade.php (modified) (3 diffs)

branches/1.5/install/install-upgrade.php

@@ -677 +677 @@
             // Change post_title column from `post_title` varchar(255) NULL, to `post_title` text NULL,
             $exists = $h->db->column_exists('posts', 'post_title');
-            if (!$exists) {
+            if ($exists) {
                     $sql = "ALTER TABLE " . TABLE_POSTS . " MODIFY post_title text NULL";
                     $h->db->query($h->db->prepare($sql));
@@ -716 +716 @@
                 }
 
+                // Change post_title column from `post_title` varchar(255) NULL, to `post_title` text NULL,
+                $exists = $h->db->column_exists('posts', 'post_title');
+                if ($exists) {
+                        $sql = "ALTER TABLE " . TABLE_POSTS . " MODIFY post_title text NULL";
+                        $h->db->query($h->db->prepare($sql));
+                }
+
                 // update "old version" for next set of upgrades
                 //$old_version = "1.4.2";
@@ -728 +735 @@
 
 
-//      // loop through all sites to insert this setting into each one's SETTING TABLE
-//      $sql = "SELECT site_id FROM " . TABLE_SITE;
-//      $sites = $h->db->get_results($h->db->prepare($sql));
-//
-//      $sql = "SELECT settings_siteid FROM " . TABLE_SETTINGS . " WHERE settings_name = %s";
-//      $result = $h->db->get_results($h->db->prepare($sql, 'MULTI_SITE'), ARRAY_N);
-//      if (!$result) { $result = array(); }
-//      //var_dump($result);
-//      if ($sites) {
-//          foreach ($sites as $site) {
-//              if (in_array($site->site_id, $result)) {
-//                  $sql = "UPDATE  " . TABLE_SETTINGS . " SET settings_value = %s WHERE settings_name = %s";
-//                  $h->db->query($h->db->prepare($sql, '', ''));
-//              } else {
-//                  $sql = "INSERT INTO " . TABLE_SETTINGS . " (settings_name, settings_value, settings_default, settings_note) VALUES (%s, %s, %s, %s)";
-//                  $h->db->query($h->db->prepare($sql, '', '', '', ''));
-//              }
-//          }
-//      }
+
 
 ?>