Conftool 2014 -for transplantation day

Development server
For  transplantation day
dump conference_tx_2013 to C:\web_root\canhealth\conftool_tx\conference_tx_2014 20140120 1602.sql
copy conference_tx_2014 20140120 1602.sql to conference_tx_2014_default.sql
conference_chung_2014_default.sql , line 21 change
CREATE DATABASE IF NOT EXISTS conference_tx_2013;
USE conference_tx_2013;
to
CREATE DATABASE IF NOT EXISTS conference_tx_2014;
USE conference_tx_2014;
line 409-501, empty table emails2papers
remove
INSERT INTO `emails2papers` (`paperID`,`email`) VALUES
.....

line 490 -   empty  table export_temp1
remove
INSERT INTO `export_temp1` (`paperID`,`topics`) VALUES
......

line 574 - empty table papers

line 733 empty table persons, only admin, alice and myself account left

line 870 empty  table reviews

line 979, empty table topics2papers

restore conference_chung_2014_default.sql


C:\web_root\cesei\conftool
copy uploads to uploads.2013, empty uploads
MYSQL query browser
GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, DROP, REFERENCES
      ON conference_tx_2014.*
      TO 'confuser'@'localhost'
      IDENTIFIED BY 'password';

(change passsword to real password.)

under /etc/conftool.conf.php, line 66
change
$ctconf['db/database'] = 'conference_tx_2013';
to
$ctconf['db/database'] = 'conference_tx_2014';
login admin, edit conference detail

copy to UBC server 1, also need to reset mail configuration in /etc/conftool.conf.php
C:\LMS\canhealth\conftool_chung
add file index.php
 <?php
 header( 'Location: ./htdocs/' ) ;
?>

MYSQL query browser
GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, DROP, REFERENCES
      ON conference_tx_2014.*
      TO 'confuser'@'localhost'
      IDENTIFIED BY 'password';
under /etc/conftool.conf.php, line 17 change
$ctconf['paths/prefix'] = 'C:/web_root/canhealth/conftool_tx/';
to
$ctconf['paths/prefix'] = 'C:/LMS/canhealth/conftool_tx/';
C:\Program Files\Apache Software Foundation\Apache2.4\conf\httpd.conf , line 277 add
    php_value include_path ".;C:/LMS/cesei/conftool_tx/etc/;"
Fatal error: Call to undefined function session_unregister() in C:\LMS\cesei\conftool_tx\classes\CTSession.ctcls.php on line 323
C:\LMS\cesei\conftool_tx\classes\CTSession.ctcls.php
line 323 change
session_unregister($key);    // needed for another bug in php 4.2!
to
            unset($key); 
http://dev.cesei.org:8080/conftool_tx/htdocs/index.php
http://139.173.32.21:8081/conftool_tx/htdocs/index.php