Upgrading from version 2.1.4 to 2.1.6
Upgrading from JForum version 2.1.4 to version 2.1.6 is very simple.
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.6 into some directory, made the changes there and then, when all is finished, copy it over the directory where the previous vesrion is located.
You'll like to take special care for SystemGlobals.properties and jforum-custom.conf, as these are the main configuration files.
Merging SystemGlobals.properties
Most changes were made to the database structure and main board configuration files.
SystemGlobals.properties has changed a lot - most of the changes were made to organize the file.
You can use a diff tool, like
WinMerge
to check the differences. Special care is necessary for the following keys:
| Key name |
|---|
| forum.link |
| homepage.link |
| forum.name |
| forum.page.title |
| user.hash.sequence |
| encoding |
| database.driver.name |
| database.connection.implementation |
| i18n.board.default |
| mail.sender |
| mail.smtp.auth |
| mail.smtp.host |
| mail.smtp.port |
| mail.smtp.username |
| mail.smtp.password |
Merging Database settings
Open the file _WEB-INF/config/<DBNAME>/<DBNAME>.properties_ and check the username, password and host to connect.
 | MySQL 4.1+
If you're going to use MySQL 4.1 or more recent, please set the value of the keys _mysql.encoding_ and _mysql.unicode_ to empty, as shown below:
mysql.unicode=
mysql.encoding=
|
Also for MySQL 4.1+ users: Open
WEB-INF/config/database/mysql/mysql.sql and
remove all data from the file - yes,
the file should be empty.
Checking jforum-custom.conf
Now, open
WEB-INF/config/jforum-custom.conf and make sure that the configuration options values are as expected. It may sound like an unnecessary step, since your forum is working already, but even that, just to be sure that none of the keys you changes in SystemGlobals.properties are being overwritten by this file.
Upgrading the database
Now, import the SQL file named "<DBNAME>_2.1.4_to_2.1.6.sql" (like
mysql_2.1.4_to_2.1.6.sql) into your database. This script will convert the tables and create the new ones.
Optional step: If you're going to keep your current <DBNAME>.properties, you'll have to change the value of the key dao.driver, according to the following table:
| Database | Old value | New value |
|---|
| MySQL | net.jforum.drivers.mysql.DataAccessDriver | net.jforum.dao.mysql.MysqlDataAccessDriver |
| HSQLDB | net.jforum.drivers.hsqldb.DataAccessDriver | net.jforum.dao.hsqldb.HsqldbDataAccessDriver |
| PostgreSQL | net.jforum.drivers.postgresql.DataAccessDriver | net.jforum.dao.postgresql.PostgresqlDataAccessDriver |
Also, please ensure that your jforum-custom.conf - if you are going to keep the old one - has the updated value as well.
About permissions
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.
Starting from version 2.1.6, it is only possible to set permissions for Groups. User Permissions were removed because they were confusing and hard to maintain.
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:
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.
As mentioned in the previous section, you may experience some issues with access rights. If the user you use in JForum 2.1.4 for the administrative tasks does not have access to the
Panel, please do this:
- Find the user id of your user by executing the query
SELECT user_id FROM jforum_users WHERE username = 'YOUR USERNAME HERE';
|
- Go to your database console (or any administration tool use may use) and run the following SQL query:
INSERT INTO jforum_roles (name, user_id, role_type) VALUES ('perm_administration', YOUR_USER_ID, 1);
|
