NewFeatures270

New and changed features in JForum 2.7.0

Information about upgrading from JForum versions 2.5.0 and 2.6.x to 2.7.0 can be found at Upgrading to JForum 2.7.0

New Features and fixes

• New feature: Trash Can lets you designate one forum as trash can - meaning topics that get deleted are moved to it, rather than actually getting deleted from the database. If the forum is set up to be accessible by admins only, that way you keep deleted topics for future reference (which comes in handy on moderated forums frequently)
• JForum now requires a servlet container that supports Servlet API 3.1 instead of 2.5, for example Tomcat 8.
• [Banners] can be shown on assorted pages, up to 3 at the top and up to 3 at the bottom.
• The user profile no longer supports YIM, AIM and MSNM, but Skype instead.
• The Recent Topics page is now paginated.
• A bug has been fixed that would cause Hot Topics to display non-hot topics (and also order them incorrectly on Postgres).
• [#64] Configuration settings are stored in the DB, so they don't get lost when removing or replacing the web app.
• Hot Topics can be configured to show either the topics with the most views (as it is now) or the topics with the most replies
• More consistent display of wiki topics
• fix for Jetty issue (fixed in JForum 2.6.1)
• fix bug where moderation log entries where messed up when deleting posts (fixed in JForum 2.6.1)
• fix for HSQLDB issue (fixed in JForum 2.6.2)
• fixed a bug that prevented the window showing all smilies to pop up when writing a post (fixed in JForum 2.6.2)
• replace social sharing with the more up-to-date (and more data protection friendly) Shariff library
• [#96] SQL bug in private messages for SQLServer
• improved localizations, especially Russian, Italian, French, Spanish, Dutch, Portuguese and [#97] German
• Replaced syntax highlighter with Prism - it supports lots of different languages and doesn't use Flash for copying to the clipboard
• Fixed a bug that led to inconsistent behavior if a user had multiple simultaneous sessions
• Fixed a bug that broke searching using Lucene syntax
• Fixed a bug that mangled email subjects when the forum name contains a single quote
• The Member Listing and the Moderation Log can be hidden from anyone who is not an administrator or moderator
• Mobile view: added Top Downloads, Member Listing and Moderation Log pages and a dropdown navigation menu for a less cluttered interfac
• Eight new smilies, some of them animated, like ROFL
• Fixed bug with display of private messages in HSQLDB
• Write a message to the moderation log if a message gets rejected, and if a user is locked or unlocked, and also add a comment field for giving the reason
• Added a button to insert horizontal lines (HR elements in HTML lingo) into posts

---

Libraries

• updated Apache Commons IO from 2.6 to 2.7
• updated Apache Commons Lang3 from 3.9 to 3.10
• updated Apache Commons Text from 1.6 to 1.8
• updated Apache Lucene from 8.1.1 to 8.5.2
• updated Apache Tika from 1.21 to 1.24.1
• updated C3P0 from 0.9.5.4 to 0.9.5.5
• updated EventBus from 3.1.1 to 3.2.0
• updated FreeMarker from 2.3.28 to 2.3.30
• updated HSQLDB from 2.4.1 to 2.5.0
• updated jQuery from 2.2.4 to 3.5.1
• use JSoup 1.13.1 instead of the defunct HTMLParser library
• updated JUnit from 4.12 to 4.13
• updated Oracle JDBC driver from 12.1.0.2 to 19.6.0.0
• updated MySQL JDBC driver from 5.1.47 to 5.1.49
• updated PostgreSQL JDBC driver from 42.2.5 to 4.2.14
• updated prettytime from 4.0.1.Final to 4.0.5.Final
• updated Quartz from 2.3.1 to 2.3.2
• updated Servlet API from 2.5 to 3.1
• updated SLF4J from 1.7.26 to 1.7.30
• updated SQLServer JDBC driver from 7.2.2.jre8 to 8.2.2.jre8

---

New Configurations

Entry name	Default value	Description
topic.hottest.percent.views	100	number between 0 and 100: hot topics emphasize many views (100, as it is up to 2.6.0) or many replies (0), Try 50 for something in between.
banner.pages.list	-	comma-separated list of pages that show banners. Possible are : index, forum, topic
social.sites.list	facebook, twitter, reddit, tumblr, linkedin, xing, mail, print, pocket	List of sites to use for social sharing. Though this setting isn't new, additional options are now available (see SystemGlobals.properties), and some are named differently - notably, "email" is now "mail". So you should adjust the list to suit your situation.
forum.trashcan.id	0	Forum ID of the trash can forum. The default value of 0 means that topics are deleted, rather than moved to the trash can (as it was in earlier JForum versions).
user.list.public	true	Whether to show the list of all members to everyone (or just to admins and moderators)
moderation.log.public	true	Whether to show the moderation log to everyone (or just to admins and moderators)

All of these can be set on the Admin Control Panel -> Configurations page.

---

Database Schema

(for PostgreSQL, the SQL for other database servers can be found in the "Upgrade" directory)

• ALTER TABLE jforum_users ADD COLUMN user_skype VARCHAR(50) DEFAULT NULL;
• ALTER TABLE jforum_users DROP user_viewonline;
• ALTER TABLE jforum_users DROP user_allow_viewonline;
• ALTER TABLE jforum_users DROP user_aim;
• ALTER TABLE jforum_users DROP user_yim;
• ALTER TABLE jforum_users DROP user_msnm;
• ALTER TABLE jforum_config ALTER COLUMN config_value TYPE VARCHAR(1024);
  • MySQL: ALTER TABLE jforum_config MODIFY config_value VARCHAR(1024)