First make sure you have a full backup of the tracker (Files + Database).

1. backup 1.4.7 files + database
   
2. delete all files EXCEPT torrent's folder (and other folder if you have user's uploads)
   
3. upload Xbtit
   
4. run the upgrade.php script
   1. Attention: if you do not have a prefix for your current tables please make the “MySQL Table Prefix” field blank.
   2. Install to the same database as the previous version.
5. when done, go to your admincp and configure the tracker again
   
6. optionally if you want to use smf instead of internal forum, run the smf_import.php script
   
7. delete install.php, upgrade.php and smf_import.php from root
   

Guide By Lupin

Update Troubleshoot

Some users can only see the logo but nothing else?

The default highest “maxclassview” in Xbtit for viewing Blocks is 8, if you have users that have their “id_level” set to more than 8 they will not be able to view any blocks.
To fix this issue you have to set the “maxclassview” to the highest “id_level” your site has.
update blocks set maxclassview = x ;
where x is your highest number.

Whenever I try to access the site it redirects me to another location?

Make sure the base URL you have is pointing to the new site (if you have changed the location).

In your database open the “settings” table and look for the “url” field, change the value to your tracker base URL.
Also update “$btit_settings['url']” in include/config.php to the tracker base URL.

I can't login with non-Latin user-name?
Most likely that your old btit had a utf-8 encoding. to fix that you have to make the query to the database with utf-8 support.
open the following file include/functions.php
look for

if ($GLOBALS["persist"]) $conres=mysql_pconnect($dbhost, $dbuser, $dbpass); else $conres=mysql_connect($dbhost, $dbuser, $dbpass);

replace it with

if ($GLOBALS["persist"]) { $conres=mysql_pconnect($dbhost, $dbuser, $dbpass); do_sqlquery ( "SET NAMES utf8"); } else { $conres=mysql_connect($dbhost, $dbuser, $dbpass); do_sqlquery ( "SET NAMES utf8"); }

In the previous code we set the query to be a “utf8” encoding, but you could set it to any encoding you use to have.

After upgrading, the non-Latin characters display incorrectly in the shout box?

you need to setup the ajaxchat to send and receive with the encoding you have in the database.
Open ajaxchat\conn.php look for
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
after add
mysql_query("set names utf8", $conn);
this will fix the non-latin character