[Summary view] [Print] [Text view]

   1  
   2  UPGRADING
   3  ---------
   4  Instructions for upgrading to this release from different versions are 
   5  included below.  To upgrade, start with the version you are currently 
   6  running and perform all subsequent steps.
   7  
   8  
   9  UPGRADING FROM THE 2003-09-20 CVS SNAPSHOT RELEASE
  10  --------------------------------------------------
  11  Upgrading from props-cvs-2003-09-20 is easy.  Just overwrite your existing 
  12  files (except for config.php and any templates you want to save!)
  13  
  14  Also, get rid of the 'cacheable' column in the props_tags
  15  table, as the cache subsystem has been entirely removed:
  16  
  17  mysql> ALTER TABLE props_tags DROP COLUMN cacheable;
  18  
  19  (This step is recommended but not necessary for the system to function)
  20  
  21  
  22  UPGRADING FROM 0.6PR2
  23  ---------------------
  24  To upgrade from 0.6PR2, you'll obviously
  25  need to overwrite all the files from your
  26  current site.  In addition, you'll need to 
  27  make several database changes from within the
  28  MySQL command-line utility.
  29  
  30  First, you'll need to add two new tags to 
  31  the props_tags table:
  32  
  33  INSERT INTO props_tags VALUES ('photos','standalone_photo');
  34  INSERT INTO props_tags VALUES ('globaltags','edition_id');
  35  
  36  Second, drop the now-obsolete props_keywords,
  37  props_keyword_story_xref and props_archives_searches_temp
  38  tables:
  39  
  40  mysql> DROP TABLE props_keywords;
  41  mysql> DROP TABLE props_keyword_story_xref;
  42  mysql> DROP TABLE props_archives_searches_temp;
  43  
  44  Third, get rid of the 'cacheable' column in the props_tags
  45  table, as the cache subsystem has been entirely removed:
  46  mysql> ALTER TABLE props_tags DROP COLUMN cacheable;
  47  
  48  Next, you'll need to add FULLTEXT indexes on
  49  three columns in the props_stories table:
  50  
  51  mysql> ALTER TABLE `props_stories` ADD FULLTEXT (`headline`);
  52  mysql> ALTER TABLE `props_stories` ADD FULLTEXT (`body_content`);
  53  mysql> ALTER TABLE `props_stories` ADD FULLTEXT (`end_content`);
  54  
  55  At this point, you may want to look into 
  56  changing MySQL's minimum keyword size from
  57  4 to 3.  The process for changing this varies 
  58  between versions - see mysql.com for details.
  59  
  60  Finally, enter the following to rebuild the 
  61  FULLTEXT keyword indexes:
  62  
  63  mysql> REPAIR TABLE props_stories QUICK;
  64  
  65  
  66  UPGRADING FROM 0.6RC3
  67  ---------------------
  68  Overwrite your existing files (but save a copy of your config.php settings 
  69  for reference, and any templates you want to save!)
  70  
  71  Tags are no longer registered in the database, so you can drop that DB
  72  table:
  73  
  74  mysql> DROP TABLE props_tags;
  75  
  76  Also, the paid archives user signup survey has been entirely removed due
  77  to extreme bloat.  So, you can get rid of all these tables:
  78  
  79  mysql> DROP TABLE props_users_signup_survey_questions;
  80  mysql> DROP TABLE props_users_signup_survey_results;
  81  mysql> DROP TABLE props_users_survey_checkboxfields;
  82  mysql> DROP TABLE props_users_survey_radiobuttonfields;
  83  mysql> DROP TABLE props_users_survey_selectfields;
  84  mysql> DROP TABLE props_users_survey_textfields;
  85  
  86  And, their functions can be removed from the list of valid administration functions:
  87  
  88  mysql> delete from props_administrator_functions where function = 'edit_survey_questions';
  89  mysql> delete from props_administrator_functions where function = 'survey_question';
  90  mysql> delete from props_administrator_functions where function = 'delete_survey_question';
  91  mysql> delete from props_administrator_functions where function = 'reorder_survey_questions';
  92  mysql> delete from props_administrator_functions where function = 'view_survey_results';
  93  
  94  UPGRADING FROM 0.6RC3
  95  ---------------------
  96  Simply overwrite your existing files (but save a copy of your config.php settings 
  97  for reference, and any templates you want to save!)
  98  
  99  There were no changes to the database structure between RC3 and RC4.
 100  
 101  
 102  UPGRADING FROM 0.6.1 or 0.6.2
 103  -----------------------------
 104  This is a *huge* upgrade.  MAKE SURE TO BACK UP all your web site files, config.php settings 
 105  and a dump of your MySQL database before proceeding.  If anything goes wrong you will 
 106  then be able to restore your site.
 107  
 108  Make sure you upgrade your copy of config.php, as it contains some new config variables 
 109  and constants!
 110  
 111  Then, execute the supplied sql/props-mysql-upgrade-from-0.6.1-or-0.6.2.sql 
 112  in MySQL, as such:
 113  
 114  # mysql [databasename] < props-mysql-upgrade-from-0.6.1-or-0.6.2.sql
 115  
 116  (View that file for details on the changes it makes to the db)
 117  
 118  Finally, you'll need to go into the Admin Account Management screen and allow appropriate 
 119  user groups to access the Polls and Users admin screens.
 120  
 121  UPGRADING FROM 0.7 RC1 TO 0.7 RC2
 122  ---------------------------------
 123  
 124  A column named 'assigned' has been added to the props_photos table.  
 125  You will need to create and populate it as follows:
 126  
 127  mysql> ALTER TABLE props_photos ADD COLUMN assigned int(1) NOT NULL default 0;
 128  mysql> CREATE TABLE props_photos_temp (
 129    photo_id int(11) NOT NULL,
 130    caption text,
 131    subcaption text,
 132    credit varchar(60) default '',
 133    credit_suffix varchar(60) default '',
 134    width int(11) NOT NULL default '0',
 135    height int(11) NOT NULL default '0',
 136    file_extension varchar(6) default NULL,
 137    assigned int(1) NOT NULL default '0',
 138    PRIMARY KEY  (photo_id);
 139  )
 140  mysql> INSERT INTO props_photos_temp 
 141          SELECT props_photos.photo_id, caption, subcaption, credit, credit_suffix, width, height, file_extension, (COUNT(story_id) > 0) AS assigned 
 142              FROM props_photos 
 143              LEFT JOIN props_story_photo_xref 
 144              ON props_photos.photo_id = props_story_photo_xref.photo_id 
 145              GROUP BY photo_id;
 146  mysql> TRUNCATE TABLE props_photos;
 147  mysql> SELECT * FROM props_photos_temp INTO props_photos;
 148  mysql> DROP TABLE props_photos_temp;
 149  
 150