Download the latest trackthrough_1_4.zip from https://www.bispark.com/trackthrough/download and extract (unzip) this to a temporary directory.

Copy the contents of includes, resources and mini folder from above download to your current installation.

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.

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