== Upgrade Instructions from 6.0.0002 / 6.0.0003_beta to 6.0.0003 == '''Step 0''': Backup your Database and Files. '''Step 1''': Download Dolphin 6 Patch 0003 [http://get.boonex.com/Dolphin-Patch-v.6.0.0003-Free Free Version] or [http://get.boonex.com/Dolphin-Patch-v.6.0.0003-AdFree Ad Free version]. '''Download [http://get.boonex.com/Dolphin-v.6.0.0002-6.0.0003-Diff Download Dolphin 6.0.0002 to 6.0.0003 Diff] to see file changes.''' '''Step 2''': Upload all files accordingly to their location in the script and the patch file by file overwriting them. ''Example'': Open '''/inc/''' directory of your site, also open '''/inc/''' directory of the patch that you have downloaded to your PC. Upload all files contained in the '''/inc/''' directory of the patch on PC to your site's '''/inc/''' directory overwriting those already there. ''NOTE'': Do not upload the folders from the patch overwriting the ones existing on your site. '''Step 3''': Upgrading your database. Upload the two files from the upgrade patch called upgrade.php and upgrade.6.0003.sql in your Dolphin's home directory. Run the following script in you favorite browser to upgrade your database http://www.mysite.com/path_to_dolphin/upgrade.php. ''NOTE'': You should run your upgrade.php only once. If you run the script for a second time, it will result in Database access error. '''Step 4''': You have to edit the build number of your script in '''inc/header.inc.php''', replacing {{{$site['build'] = '0002';}}} with {{{$site['build'] = '0003';}}} ''NOTE'': Please log into your '''Admin Panel -> Settings -> Profile Fields''' and make sure that the '''!DescriptionMe''' field is located under the '''Description''' divider. If it's not there, please drag it there using the green arrow icons. '''Step 5:''' If you have already installed 0003 beta build before upgrade, do the following instructions: Go to your inc/header.inc.php file, find the line: {{{if( $_SERVER['HTTP_HOST'] != $aUrl['host'] )}}} and replace it with: {{{if( isset($_SERVER['HTTP_HOST']) and $_SERVER['HTTP_HOST'] != $aUrl['host'] )}}} ''NOTE:'' If you have installed 6.0.0002, do not do this step and follow the next. '''Step 6:''' Go to your inc/header.inc.php and find following line: {{{define('DATABASE_NAME', $db['db']);}}} And add after it the next code: {{{ $aUrl = parse_url( $site['url'] ); if( isset($_SERVER['HTTP_HOST']) and $_SERVER['HTTP_HOST'] != $aUrl['host'] ) { header( "Location:http://{$aUrl['host']}{$_SERVER['REQUEST_URI']}" ); exit; } }}} '''Step 7:''' You have to edit the path to your script's inc/header.inc.php inside ray/modules/global/inc/header.inc.php, replacing [path_to]inc/header.inc.php with the absolute path to it. '''Your Dolphin installation has been successfully upgraded.''' ''NOTE'': For those of you whose database is not converted into utf8 format, here are the instructions how to do it using '''phpMyAdmin''': '''1)''' Log into your phpMyAdmin '''2)''' Choose your database name from the left drop-down menu frame '''3)''' Click '''Export''' at the top '''4)''' Make sure that all the tables are selected in the right-left corner and the export method is '''SQL''' '''5)''' Uncheck '''Add AUTO_INCREMENT value''' and '''Use hexadecimal for BLOB''' (or '''Use hexadecimal for binary fields''') '''6)''' Choose '''MYSQL40''' in the '''SQL compatibility mode''' drop-down menu '''7)''' Click '''Save as file''' and choose the compression method which is supported by your phpMyAdmin. Save the file in some folder on your computer '''8)''' Click the database name, check all the tables and '''Drop''' them '''9)''' Click '''Operations''' in the top menu '''10)''' Choose '''utf8_unicode_ci''' for '''Collation''', then click '''Go''' '''11)''' Click '''Import''' in the top menu, browse and choose the file you have saved in the '''File to import''' field, set '''utf8''' for the '''Character set of the file''' '''12)''' Click '''Go''' '''13)''' Wait until the SQL query stops running and check its result For any troubleshooting feel free to contact us at support@boonex.com