How to upgrade Xaamp Php and osticket together from old version to new.

 

OS detail : Windows server 2012

Os ticket upgrade from  old version to new

Before embarking on an upgrade or a migration mission, it is extremely important that you backup your website’s database and files. We also recommend that you take the system offline momentarily during the process. While we try to ensure that the upgrade process is straightforward and painless, we can’t guarantee it will be the case for every user. For this reason it is crucial that users take precautions in case of any problems. 

Step 1

Before do the upgrade make sure that you have a local admin in your osticket and you should know the password. I had only active directory admin users in my os ticket. So I create a new local admin and give full permission to all tickets.

Login as admin in your Osticket and open Agent tab

• Then create new agent

Step2

After Crete admin user . Then make site offline

Step 3

To backup all data including db

I copied entire xamp folder to a new folder e:\xamp_backup

Step 4

Rename old xamp folder to xamp_old (e:\xamp_old)

Then Download and insall the xamp with osticket  recommended version of PHP 

I install Xamp version xampp-portable-win32-7.3.0-0-VC15-installer, that meet all osticket new release [osTicket Core, v1.14.3]  requierments [HTTP server running Microsoft® IIS or Apache, PHP version 7.0, MySQL database version 5.5]

So it will create a fresh xamp folder (e:\xamp)

Step 5

Upgrade Php5 to Php 7

Copy newly installed php (php7) folder form e:\xamp  to e:\xamp_old  [for safe side rename existing php folder  to php_old]

Edit Config > Apache (httpd-xampp.conf). [e:\Xampp\apache\conf\extra\httpd-xampp.conf]

#LoadFile "E:/Xampp/php/php5ts.dll"

#LoadFile "E:/Xampp/php/libpq.dll"

#LoadModule php5_module "E:/Xampp/php/php5apache2_4.dll"

LoadFile "E:/xampp/php/php7ts.dll"

LoadFile "E:/xampp/php/libpq.dll"

LoadModule php7_module "E:/xampp/php/php7apache2_4.dll"

 Done PHP upgrade done.

Step 6

Rename e:/xamp to e:/xamp_freshcopy

and rename e:xamp_old to e:/xamp

Then download latest version OS_ticket and extract.(https://osticket.com/download/ ). 

Important :

•  backup ost-config.php file from /include folder to some where safe.
•  Then and copy all content inside Upload folder in Downloaded osticket to htdocs / your ticket directory and replace. 
• Then Put it back backuped ost-config to include folder . Then restar xammp services, Then check MySQL admin panel 
• If you face the issue "phpMyAdmin Error: The mbstring extension is missing. Please check your PHP configuration" Do like below.

I've solved my problem by this way: Edit the php.ini file:

1. change extension_dir = "ext" into extension_dir = "D:\php\ext" （please write ur own path）
2. change ;extension=php_mbstring.dll into extension=php_mbstring.dll （delete the ";"）
3. Then just save your php.ini file and copy it to ur Windows directory。(“C:\Windows“)
4. restart the apache server。

Then go to osticket admin pannel dacshboard >>information and Press upgrade button. It will upgrade Osticket to later version :)

Step 7

After I upgrade only php by this method I got 2 errors,

Some error when I access  

1)phpmyadmin

[Warning in .\libraries\config\FormDisplay.class.php#654
 "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?

Backtrace

.\libraries\config\page_settings.class.php#14: require_once()
.\libraries\common.inc.php#1243: include_once(.\libraries\config\page_settings.class.php)
.\server_status.php#9: require_once(.\libraries\common.inc.php)]

This I solved by coping phpmyadmin folder from e:\xampp_freshcopy to  e:\xampp (safe side always rename old copy and past)

2)LADAP binding error

This I solved by coping apache folder from e:\xampp_freshcopy to  e:\xampp (safe side always rename old copy and past) 

but by doing this I will losse my  main apache config file , so I copied my apache\config forlder from my main backup  e:\xamp_backup\apache\config to e:\xampp\apache\config

and edit httpd-xampp.conf like above 

Edit Config > Apache (httpd-xampp.conf). [e:\Xampp\apache\conf\extra\httpd-xampp.conf]

#LoadFile "E:/Xampp/php/php5ts.dll"

#LoadFile "E:/Xampp/php/libpq.dll"

#LoadModule php5_module "E:/Xampp/php/php5apache2_4.dll"

LoadFile "E:/xampp/php/php7ts.dll"

LoadFile "E:/xampp/php/libpq.dll"

LoadModule php7_module "E:/xampp/php/php7apache2_4.dll"

and save.

Done . check all tickets and version and all settings and email sending . And make server Online.

One ,ore issue I face was the second  language was not working.