June 19, 2018, 05:33:45 PM
collapse

* Site Menu

Upgrading Your Database


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 instead of uploading the SMF upgrade package. When you upgrade via the admin link, the database is not upgraded along with the files. Upgrading your database may or may not solve the first part of the error (depends on the mod you are installing) but will definitely help your mods get around the "upgrade database" issue.

Solution: Download the SMF large upgrade package (not update package) 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?

^ Go Up ^

Updated: Feb. 21, 2012

Enjoy!!!

Courtesy of:
Doc Skillz


Page created in 0.023 seconds with 17 queries.