Support       

General Hosting
Flash Tutorials
Design Tutorials
Hosting Tutorials
   Email
   FTP
   Htaccess
   Log Files
   Meta Tags
   PhpMyAdmin
   Web Scripts
   Web Statistics
Plesk Login
Plesk Manual
Quick FAQ
Server Status
Nexology Community > Support > General Hosting > Web Scripts > Forum > Smf > Upgrade

SMF (Simple Machines Forum) is a free, professional grade software package that allows you to set up your own online community within minutes. SMF is written in the popular language PHP and uses a MySQL database.

PREPARATION

Download the patch version for the latest version of SMF for your current version from the SMF web site. Extract the file locally to your computer.

Note: If you are currently using a version other than the next to newest or have made modifications, download the larger upgrade file.

UPLOAD

Upload the files/folders to the forum folder, overwriting the files on the server. This should upgrade the files to the latest version.

Additionally, run http://www.example.com/forum/upgrade.php to upgrade the database.

On the upgrade page, set the following:

Backup tables in your database with the prefix "backup_smf_".
Put the forum into maintenance mode during upgrade.

Check the other options if desired. Click Continue.

UPGRADE ISSUES

On the upgrading page you will see "Updating and creating indexes... Unsuccessful!". This is a MySQL issue and can be fixed by editing upgrade_1-1.sql and Sources/ManageSmileys.php:

upgrade_1-1.sql

Replace the follow (lines 180-181):

ALTER TABLE {$db_prefix}smileys
ORDER BY LENGTH(code) DESC;

With:

ALTER TABLE {$db_prefix}smileys
ORDER BY code DESC;

The second code replacement is related to editing smileys in the Smileys and Message Icons section of your admin panel.

Sources/ManageSmileys.php

Replace the follow (lines 654 and 990):

ORDER BY LENGTH(code) DESC", __FILE__, __LINE__);

With:

ORDER BY code DESC", __FILE__, __LINE__);

If you edited the copy of these files on your computer (not the copy on the server) upload these files, overwriting the copies on the server. Click Try again on the upgrade page and the upgrade should successfully complete.

Click the link in the text "Now you are ready to use your installation of SMF."

SECURITY/CLEANUP

After upgrading is complete, remove the following:

upgrade.php
upgrade_1-1.sql


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2006, Jelsoft Enterprises Ltd.
Copyright ©2001 - 2008, HostNexus.Com | vBulletin 3.5 Skin conversion by: HomeOnline
HostNexus |  NexusPortal |  Domain Resellers |  NexusDomains |  ColdFusion

 
Techskins.com - Your source for Elite Skins,
		and interface components!