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

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

1. Assuming 'ttdb' is your current database, run the following queries to create 'userpermission' table:
   
   CREATE TABLE `userpermission` ( `id` int(10) unsigned NOT NULL auto_increment, `user_id` int(10) unsigned NOT NULL, `permission` tinyint(4) NOT NULL, `record_type` tinyint(4) NOT NULL, `record_id` int(10) unsigned default 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. Alter table 'projectrecord'
   
   ALTER TABLE `projectrecord` ADD `updated_at` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `created_at`
   
   ALTER TABLE `projectrecord` ADD `icon_name` VARCHAR( 256 ) NULL DEFAULT NULL AFTER `description`
   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 `updated_at` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `created_at`
   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.1
default_theme_color = blue

[index]
title = "TrackThrough - Index"
[password]
title = "TrackThrough - Retrieve Password"
[project]
title = "TrackThrough - Projects"
[project view]
title = "TrackThrough - Project View"
[project create]
title = "TrackThrough - Add Project"
[task view]
title = "TrackThrough - Task View"
[task create]
title = "TrackThrough - Add Task"
[task copy]
title = "TrackThrough - Copy Task"
[bookmark]
title = "TrackThrough - Bookmarks"
[teams]
title = "TrackThrough - Teams"
[leads]
title = "TrackThrough - Leads"
[register]
title = "TrackThrough - Register User"
[settings]
title = "TrackThrough - Settings"
[profile]
title = "TrackThrough - Profile"
[admin settings]
title = "TrackThrough - Configuration Settings"
[messages]
title = "TrackThrough - Messages"
[search]
title = "TrackThrough - Search Results"
[error]
title= "TrackThrough - Error Page"

[Attachment_icon]
css = css.png
csv = xls.png
default = attach.png
doc = doc.png
flv = flv.png
gif = image.png
jpg = image.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