Upgrading from version 1.3 to 1.4

 
1. Please make a backup of your current installation folder and database.
2. Download TrackThrough version 1.4
Download the latest trackthrough_1_4.zip from http://bispark.com/trackthrough/download and extract (unzip) this to a temporary directory.
e.g.: extract trackthrough_1_4.zip to /temp/trackthrough_1_4.
Copy the contents of includes, resources and mini folder from above download to your current installation.
e.g.:
cp /temp/trackthrough_1_4/includes to /var/www/trackthrough/
cp /temp/trackthrough_1_4/resources
to /var/www/trackthrough/
cp /temp/trackthrough_1_4/mini to /var/www/trackthrough/
3. Alter database table
  1. Assuming 'ttdb' is your current database, run the following queries to create 'bookmarks' table:
    CREATE TABLE `bookmarks` ( `id` int(10) unsigned NOT NULL auto_increment, `user_id` int(10) unsigned NOT NULL, `category` tinyint(4) NOT NULL, `category_id` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), FOREIGN KEY (`user_id`) REFERENCES `userrecord` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
    Caution: if you had used database prefix in your old installation you may want to modify the above query as appropriate.

  2. Create table 'preferencerecord'
    CREATE TABLE `preferencerecord` ( `id` int(10) unsigned NOT NULL auto_increment, `user_id` int(10) unsigned NOT NULL, `settings` text, PRIMARY KEY (`id`), FOREIGN KEY (`user_id`) REFERENCES `userrecord` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
    Caution: if you had used database prefix in your old installation you may want to modify the above query as appropriate.

  3. Alter table 'taskrecord'
    ALTER TABLE `taskrecord` ADD `progress` TINYINT(4) NOT NULL AFTER `assignedat`
    Caution: if you had used database prefix in your old installation you may want to modify the above query as appropriate.
4. Edit config.ini file
Edit config.ini file in your installation folder as shown below:
[ETC]
project_attachment_folder=resources/uploads/project/
mail_template_folder=resources/mail_templates/
attachment_icons_folder = attachment_icons
hashed_password=false
version = 1.4
default_theme_color = blue

[FlexyView]
resources_dir = resources
style_sheets=images/style.css
java_scripts = js/trackthrough.util.js

[Attachment_icon]
css = css.png
csv = xls.png
default = attach.png
doc = doc.png
flv = flv.png
gif = image.png
jpg = jpg.png
mht = mht.png
module = php.png
pdf = pdf.png
png = image.png
php = php.png
odt = odt.png
rtf = doc.png
txt = txt.png
tar = tar.png
xls = xls.png
zip = zip.png
5. Edit mini config
Edit mini/config.ini file as shown below:
[FW]
module_dir = ../includes/modules
image_dir = ../resources/images
base_url= http://yoursite.com/trackthrough/mini