Upgrading from version 2.1.6 to 2.17

Upgrading from JForum version 2.1.6 to version 2.1.7 is very simple. All you have to do is to carefuly follow the steps here described.

IMPORTANT: Changes made to Permissions / Roles

JForum 2.1.7 highly improves the efficiency of user and groups management, with a faster engine and a set of tweaks to the way multiple groups are handled by each user.

Changes The database upgrade script, explained later in this page, will make some changes to the database schema, affecting the tables jforum_roles and jforum_role_values. Please dont' forget to read the Setting up Permissions again section.

Backup your data

First, make a backup of the database and the current directory where JForum is installed. Backup everything (templates, images etc). The suggested approach to use is to unpack JForum 2.1.7 into some work directory, made the changes there and then, when all is finished, copy it over the directory where the previous vesrion is located.

You'd like to take special care for SystemGlobals.properties and jforum-custom.conf, as these are the main configuration files. Backup them and then compare and merge your current version with the new version that comes with JForum 2.1.7.

Upgrading the database schema

There are some changes to the database schema - a new colum here, a removed colum there... In order to get the database right, go to the directory upgrade/2.1.7, where you'll find the upgrade script for all supported dataabses - Oracle, MySQL, PostgreSQL and HSLQDB.

Using your database management console / tool, import the appropriate script. For example, if you are using MySQL, the following command should run the queries:

mysql -u USERNAME -p DBNAME < mysql_2.1.6_to_2.1.7.sql

There should not be any errors.

Setting up permissions again

When logging in for the first time, you'll note that all Categories and Forums are not visible anymore. That's because the changes made to the database.

The Admin account is the only one with a role set, which is sufficient to use the Admin Panel to fix the roles for all other groups.

You'll have to re-save the permissions from all groups again. The step is simple: just to Admin Panel -> Groups -> Permissions, check the options and then click Save. Do these steps for all groups.

Be careful Please note that you have to set all roles again. Be careful when doing this, in order to not give incorrect roles to some group.

Removing installation files

Now, do this:

• Rename the file index.redirect to index.htm (you can remove the existing index.htm)
• Open SystemGlobals.properties and add the following line:

installed = true

Open WEB-INF/config/modulesMapping.properties and remove from it the following line:

install = net.jforum.view.install.InstallAction

Testing

Now, if possible, test JForum 2.1.6 before copying it over 2.1.4. The easier way is to put it under some another Context. If the system starts without problems, then you can proceed to the final step.