conftool 2014 -For Chung research

Development server
For Chung research
dump conference_2013 to C:\web_root\cesei\conftool\conference_chung_2014_bk 20140120 1000.sql
copy conference_chung_2014_bk 20140120 1000.sql to conference_chung_2014_default.sql
conference_chung_2014_default.sql , line 21 change
CREATE DATABASE IF NOT EXISTS conference_2013;
USE conference_2013;
to
CREATE DATABASE IF NOT EXISTS conference_2014;
USE conference_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_2014.*
      TO 'confuser'@'localhost'
      IDENTIFIED BY 'password';

(change passsword to real password.)

under /etc/conftool.conf.php, line 66
change
$ctconf['db/database'] = 'conference_2013';
to
$ctconf['db/database'] = 'conference_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/' ) ;
?>
under /etc/conftool.conf.php, line 17 change
$ctconf['paths/prefix'] = 'C:/web_root/cesei/conftool/';
to
$ctconf['paths/prefix'] = 'C:/LMS/canhealth/conftool_chung/';
C:\Program Files\Apache Software Foundation\Apache2.4\conf\httpd.conf , line 262 add
php_value include_path ".;C:/LMS/canhealth/conftool_chung/etc/"
Fatal error: Call to undefined function session_unregister() in C:\LMS\canhealth\conftool_chung\classes\CTSession.ctcls.php on line 323
C:\LMS\canhealth\conftool_chung\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/conftool_chung/htdocs/index.php
 http://139.173.32.21/conftool/htdocs/index.php