[Logo] JForum - Powering Communities
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Top Downloads] Top Downloads   [Groups] Back to home page 
[Register] Register /  [Login] Login 


JForum 2.9.0 is out with various fixes and improvements. It now requires a Servlet 6 container running on Java 11. Read all about it here

Changes to the Database schema RSS feed
Forum Index » User Forum
Author Message
paulhr


Joined: Jul 30, 2016
Messages: 14
Offline
With the list of Database Schema changes what is implied, but not stated, is that JForum must be stopped. The "alter table" commands run, adjusted if needed for the database used, and the new .WAR installed. Would it be asking to much to get some type of high level list of actions to take and in what order?

Database Schema
• alter table jforum_posts alter column poster_ip type varchar(50);
• alter table jforum_privmsgs alter column privmsgs_ip type varchar(50);
• alter table jforum_banlist alter column banlist_ip type varchar(50);
• alter table jforum_sessions alter column session_ip type varchar(50);
• alter table jforum_vote_voters alter column vote_user_ip type varchar(50);
udittmer


Joined: Feb 21, 2013
Messages: 435
Offline
The basic steps are listed in https://sourceforge.net/p/jforum2/wiki2/UpgradingFrom241To250/. The basic outline is: !) stop the web app, 2) work through the steps on that page, 3) start the web app. If you have a specific question about a step, feel free to ask in more detail.

you can support my JForum work via Paypal
[Email] [WWW]
 
Forum Index » User Forum
Go to:   
Mobile view
Powered by JForum 2.8.3 © 2025 JForum Team • Maintained by Andowson Chang and Ulf Dittmer