$Id: UPGRADE.txt,v 1.7 2002/06/11 13:53:33 mdruilhe Exp $
  =============================================================================

			Release notes for w-agora 4.1.4
  
  =============================================================================

CHANGES
-------

  * main changes in this version 
  ------------------------------
  - This release include a major security fixe preventing malicious users to run external PHP scripts 
  from your server.
  No change have been made in the database & files structures compared with previous 4.1.3, 
  so no update script is necessary if you have 4.1.3 installed.

  * main changes in version 4.1.3
  --------------------------------
  - This release include a new statistics module that needs forums access to be logged.
    A new table sitename_log has been added for this purpose. 
 
  * main changes in version 4.1.2
  --------------------------------
  - The extra forum fields : cle, parent, childs, thread, newest (never used before) have been 
  definitively removed form the user table. The userid field becomes the primary key.
  - In order to save DB queries, the field "att_size" in the forum table is checked. As a result
  it must be updated properly while attachments are made to the notes (done in upgrade script)
  - The 'inline' field in the attachment table is now used, it was previously not set, so old
  attachments will not be displayed inline, unless this field is set to 1 (done in upgrade script)


MIGRATE
-------

  * Migrating from 4.1.x version to 4.1.4
  ---------------------------------------
  1. As usual, backup your old w-agora installation (both the w-agora tree and the database)

  2. Unpack the new w-agora distribution over the current installation (see the README)

  3. Depending on your old w-agora version, you may have to run the following upgrade scripts:
	tools/upgrade_412.php3 (4.1.1 -> 4.1.2)
	tools/upgrade_412.php3 (4.1.2 -> 4.1.3)
  
     a- If you are upgrading from w-agora 4.1.3, you have nothing to do, your installation should work 
     the same 

     b- If you are upgrading from w-agora 4.1.2, run the script tools/upgrade_413.php3.
     eg: http://www.yoursite.com/w-agora/tools/upgrade_413.php (check the above NOTICE)

     c- If you are upgrading from w-agora 4.1.0 or 4.1.1, you will first have to run upgrade_412.php 
     and after that you can run the upgrade_413.php script to upgrade your database to the latest format.
     eg. (check the above NOTICE) :
       http://www.yoursite.com/w-agora/tools/upgrade_412.php 
       http://www.yoursite.com/w-agora/tools/upgrade_413.php

  

  * Migrating from 4.0.x versions :
  ---------------------------------

  If you are running old versions of w-agora4 (4.0b1 to 4.0.3), you should not 
  have any difficulty to run w-agora 4.1

  1. As usual, backup your existing installation (both the w-agora tree and the database)

  2. untar the package over the current installation (see the README)

  3. run the following migrations scripts in that order (see Notice(*) )
	tools/upgrade_401.php3 (versions older than 4.0.1)
	tools/upgrade_402.php3 (versions older than 4.0.2)
	tools/upgrade_403.php3 (versions older than 4.0.3)

	tools/upgrade_410.php3 (4.0.3 -> 4.1.0)
	tools/upgrade_412.php3 (4.1.1 -> 4.1.2)
	tools/upgrade_413.php3 (4.1.2 -> 4.1.3)

  For example: if you were previously running v4.0.2a, you have to run IN THAT ORDER:
        upgrade_403, upgrade_410, upgrade_412, upgrade_413


  (*) NOTICE : For security reason the tools/ directory is protected against 
  unauthorized access. Either edit or rename the .htaccess before running the 
  scripts from this directory.


  * Migrating from versions 3.0.x :
  ---------------------------------
  This release is almost a complete rewrite of w-agora 3.0 and is not full compatible
  with existing installations of w-agora 3.0.

  Certainly, the best way would be to reinstall w-agora 4 from scratch.

  Nethertheless you should be able to migrate your existing forums, assuming you already 
  have w-agora 3 running over a mysql/postgres database.

     o Migrating mysql / postgres forums :
     -------------------------------------

  Here is the steps that you should follow.

  - export your database using mysqldump (or similar)
  - remove all the w-agora tables
  - backup your existing w-agora installation
  - install the new package, then recreate empty forums with the same names and settings
  - import the saved tables in the appropriate new created tables

     o Migrating DBM forums :
     ----------------------

   Obviously, you should have mysql or postgres enabled and running at your website.

   Here is some suggestions

   1. Create a new postgreSQL/mysql site / forum using w-agora 3.x 
     (DO NOT use 'agora' as site name but whatever you want)
   2. Copy your DBM forum to you newly created (mysql/postgres) forum using the 
   export script located in extras/copy_forum.php3
   3. Dump/export your table using a postgres/mysql tool
   4. Install w-agora 4.0 (setup, create site, create forum)
   5. Import your old forum in the newly created table.
