February 05, 2012, 04:12:39 AM

15 Jan 2012 - Upgrading Your Database

 Written by Skhilled January 15, 2012, 10:44:00 AM 1643 Views Rating: 0 (0 Rates) You have rated this file.
Problem: If you see something similar (the error and SMF version will probably be different depending on the issue) to this:
Database Error Duplicate entry 'GTA' for key 2 File: /home/me/public_html/your_site/Sources/ManageGames.php Line: 1081
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.2, while your database is at version 2.0. The above error might possibly go away if you execute the latest version of upgrade.php.
This is an SMF issue that happens when you upgrade your forum via the admin link. However, the database is not upgraded along with it.

Solution: Download the SMF large upgrade package (not update) that is the same as your SMF forum version number that you are currently using.
For SMF 1.1.x versions: Extract the following files -

upgrade.php
upgrade_1-0.sql
upgrade_1-1.sql

Upload them to your root folder of your forum. Run http://yourforum.com/upgrade.php in your favorite browser.

If you run into a smiley error during the upgrade, follow the instructions in this SMF topic link and then run upgrade.php again.

How do I fix this "ALTER TABLE smf_smileys ORDER BY LENGTH" error I am getting?
For SMF 2.x versions: Extract the following files -

upgrade.php
upgrade_1-0.sql
upgrade_1-1.sql
upgrade_2-0_mysql.sql - only if you use mysql databases.
upgrade_2-0_postgresql.sql - only if you use postgresql databases.
upgrade_2-0_sqlite.sql - only if you use sqlite databases.
Upload them to your root folder of your forum. Run http://yourforum.com/upgrade.php in your favorite browser.

If you run into a smiley error during the upgrade, follow the instructions in this SMF topic link and then run upgrade.php again.

How do I fix this "ALTER TABLE smf_smileys ORDER BY LENGTH" error I am getting?


Enjoy!!!

Courtesy of:
Doc Skillz