Vision Helpdesk V3.6.2 Stable Version Released

Today we have released Vision Helpdesk V3.6.2 Stable Version. This version includes bug fixes from V3.6.0 and several new exciting features.

The new setup is available for download at our client portal — http://secure.visionhelpdesk.com

I have installed V3.x.x How to Upgrade to V3.6.0?

Step1) Login to client portal — http://secure.visionhelpdesk.com

Step2) From Services >> My Services — You can download new setup for Vision Helpdesk V3.6.2

(We have different setups for PHP5.2 and PHP5.3 versions – please download proper setup)

Step3) Take backup of your existing V3.x.x files and database on your server.

example if you had installed on support folder you can rename support to support_bk and create new support folder.

Step4) Unzip V3.6.2 setup – it will have folder named “upload” — you have to upload all files and folders (except setup folder) under upload folder to your server under support folder.

Note : If using ftp to upload make sure you use binary mode to upload files

Step5) Copy below listed files and folders from your backup support_bk

config.php file from your old backup support_bk/config.php to support/config.php

support_bk/attachment/ to support/attachment/

support_bk/logs/ to support/logs/

support_bk/console/pipe.php to support/console/pipe.php

Step6) If you had any customization done in previous version you can copy those files to new files.

Note : We recommend to contact our support team for upgrade.

Step7) Now we have some changes in database — you can update it by running below listed file in browser

In browser open folder – http://yourdomain.com/support/upgrade/

This will show you list of upgrade files from version to version

Based on what version are you running — You can run the upgrade files.

example if you had previous version installed V3.6.0 then simply run

http://yourdomain.com/support/upgrade/upgrade_3_6_0_to_3_6_2.php

Note : After you run upgrade files – Remove upgrade folder from your installation.

That’s it you are done…

Note : If you are not sure how to upgrade please open support ticket we will help you.

Features added in V3.6.2

Unassigned option added in workflow action
Added Advance Search API
Added Product Billing Feature
Billing module >> summary >> graphical report added.
Staff can open new ticket as client .( Open new ticket form >> Option : As client checkbox added.)
Admin setting >> Edit domain >> company address field added.
Left panel counter loading made faster.
Advanced search >> Message : content >> “From recent entries” option added.

Bug Fixes from (V3.6.0 to V3.6.2)

If you set first criteria as owner or message content or note then other criteria does not works.
Staff group >>Edit >> Move tickets to any department : Yes >> updates not saved.
Workflow >> message contain criteria not working
Folders >> Trash >> Empty trash >>Trash folder count not working.
Spam >> move to trash >>both folders count working but ticket not listed in trash and spam too.
Email template variable for status, priority not working with default language set to domain
Staff setting >> setting>> preferences >> Html editor : Enable (uncheck) : not working.
SMTP with Authentication
Folders >> Spam >> Option name should be Not spam instead of Remove spam.
Folder name : Draft should be rename to Drafts.
Admin setting >> Module >> Selfhelp / Billing >> change title , At client portal >> module not display .
Leftpanel >> new ticket>> on reply New ticket tab and leftpanel count should refresh.
Leftpanel >> Overdue ticket >> on reply Overdue ticket tab and leftpanel count should refresh.
Quick view >> Overdue ticket >> on reply overdue ticket tab and Quick view count should refresh.
Folders >> Trash >> Option name should be “Empty trash” instead of Delete all.
Client module >> summary >> credit refresh not working.
Try to open new ticket for non existing client , for To field : client suggestion should not display. Here showing blank list.

Change Log

templates/manage
—————-
billing_module_setting.php
billing_quickview.php
client_summary.php
client_view.php
db_backup.php
domain_details.php
domain_new.php
integration.php
invoice_list.php
left_panel.php
post_edit.php
setting_menu.php
ticket.php
ticket_new_step_two.php
ticket_reply.php
ticket_view.php
workflow_details.php
workflow_new.php
tax_list.php
tax_add.php
tax_edit.php
billing_details.php
billing_setting.php
product_edit.php
product_add.php
order_list.php
product_list.php

templates/client

——————-

header.php
profile.php
register.php
selfhelp_list.php
submit_ticket.php
gateway.php
invoice_export.php
product_list.php
order_list.php

modules

—————–
module_billing.php
module_client.php
module_setting.php
module_staff.php
module_ticket.php

classes

—————–
class_billing.php
class_mail.php
class_phpmail.php
class_setting.php
class_staff.php
class_ticket.php

scripts

—————-
common.js

includes

—————
operation.php
constants.php

console

—————-
cron.php

MySQL Changes

——————-
1.alter table `avis_client` change `debit` `balance` int (15) DEFAULT ‘0’ NULL

2.create table `avis_product` ( `product_id` int (15) NOT NULL AUTO_INCREMENT , `domain_id` int(15) default NULL, `title` varchar (255) NULL , `description` text NULL , `display_order` int(15) default ‘0’, `is_enabled` tinyint (1) DEFAULT ‘1’ NULL , `balance_type` tinyint (1) DEFAULT ‘0’ NULL , `balance` int (4) DEFAULT ‘0’ NULL , `validity` int(4) default ‘0’, `amount` decimal (10,2) DEFAULT ‘0’ NULL , PRIMARY KEY ( `product_id` ) )

3.alter table `avis_invoice` add column `product_id` int (15) DEFAULT ‘0’ NULL after `ticket_id`

4.update `avis_filter` set `search_trash`=’1′, `search_spam`=’1′ where `filter_id`=’5′

5.CREATE TABLE `avis_order` (`order_id` int(15) NOT NULL auto_increment, `product_id` int(15) default NULL, `client_id` int(15) default NULL, `balance` int(4) default NULL, `expiry` int(15) default NULL, `entry_date` int(15) default NULL, PRIMARY KEY (`order_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

6.CREATE TABLE `avis_ticket_count` (`department_id` int(15) NOT NULL, `status_id` int(15) NOT NULL, `total_count` int(15) default NULL, PRIMARY KEY (`department_id`,`status_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

7.alter table `avis_client` change `debit` `balance` int (15) DEFAULT ‘0’ NULL

8.create table `avis_product` ( `product_id` int (15) NOT NULL AUTO_INCREMENT , `domain_id` int(15) default NULL, `title` varchar (255) NULL , `description` text NULL , `display_order` int(15) default ‘0’, `is_enabled` tinyint (1) DEFAULT ‘1’ NULL , `balance_type` tinyint (1) DEFAULT ‘0’ NULL , `balance` int (4) DEFAULT ‘0’ NULL , `validity` int(4) default ‘0’, `amount` decimal (10,2) DEFAULT ‘0’ NULL , PRIMARY KEY ( `product_id` ) )

9.alter table `avis_invoice` add column `product_id` int (15) DEFAULT ‘0’ NULL after `ticket_id`

10.update `avis_filter` set `search_trash`=’1′, `search_spam`=’1′ where `filter_id`=’5′

11.CREATE TABLE `avis_order` (
`order_id` int(15) NOT NULL auto_increment,
`order_hash` int(15) default NULL,
`product_id` int(15) default NULL,
`client_id` int(15) default NULL,
`balance` float(10,2) default ‘0.00’,
`balance_type` tinyint(1) default ‘0’,
`expiry` int(15) default NULL,
`entry_date` int(15) default ‘0’,
PRIMARY KEY (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

12.CREATE TABLE `avis_ticket_count` (`department_id` int(15) NOT NULL, `status_id` int(15) NOT NULL, `total_count` int(15) default NULL, PRIMARY KEY (`department_id`,`status_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8