aspose file tools*
The moose likes JForum and the fly likes Version 2.1.5 is done - Testers needed Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JForum
Bookmark "Version 2.1.5 is done - Testers needed" Watch "Version 2.1.5 is done - Testers needed" New topic
Author

Version 2.1.5 is done - Testers needed

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
After a long development and improvement time, version 2.1.5 of JForum is done.

Before releasing it to the main public, we need help to test it, specially the Web Installer and migration from previous versions of JForum.

Version 2.1.5 is available at http://www.jforum.net/upload/JForum-2.1.5.zip.

We strongly appreciate any feedback and comments.

Thanks a lot.
Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hi Rafael,

Great to see the 2.1.5 find the light of day!

You did not indicate database issues. Does a 2.1.4 --> 2.1.5 upgrade require any database modification?

Thanks,
tim.
[originally posted on jforum.net by time]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
In the official release notes I'll state that. For now, there is a "Upgrading.html" in the "upgrade" directory.

But OK, I shall move it to the root directory.

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Using Postgres 8.1 has anyone else gotten "blank" users? I'll try it all again but I got as many blank users as I had real users. I deleted them with just

and everything was fine. I'll try it again to make sure I didn't mess anything up.

Thanks Rafael - very clean upgrade.
[originally posted on jforum.net by Anonymous]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
hhm... You had a previou version of JForum, then you got this 2.15 version, ran the upgrade script, and blank users appeared?

Rafael


[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I forgot to login before - I was the one with the issue before. Yes, I'm testing a database dump of a 2.1.4 forum in a test database. I feel that I have a very easy fix though.

In pgsql_2.1.4_to_2.1.5.sql the line:



doubles the number of users in at least Postgres 8.1.0 and 7.4.8. If I change it to



then the entire script works just fine. I know you're trying to create a script for any version of PostgreSQL so you can't use the alter table that takes a type like the other upgrade scripts as PostgreSQL 7.x does not support that.

I verified the above with both PostgreSQL 7.4.8 and 8.1.0.
[originally posted on jforum.net by stdunbar]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Ok, I'll fix the script. Thanks a lot

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
OK

I did run the script but I may have missed the merge.

Tony
[originally posted on jforum.net by Anonymous]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Rafael Steil wrote:This class not found is very old.. If you did a merge, you did it wrong ;)

Do a clean install, and connect to the same database - just don't forget to run the alter table scripts.


Connected to the same database but no data is visible... MySQL 3.xx

Original installation is broken too... now

Tony

[originally posted on jforum.net by kiwi]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
net.jforum.exceptions.ForumStartupException: Error while starting JForum - java.lang.ClassNotFoundException: net.jforum.drivers.mysql.DataAccessDriver

The upgrade process gave me a headache - I tried doing it at a time when the least users would be disturbed and amybe worked too quickly.

I think I will do a clean install and connect to the existing database, is that possible?

Tony
[originally posted on jforum.net by kiwi]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
This class not found is very old.. If you did a merge, you did it wrong ;)

Do a clean install, and connect to the same database - just don't forget to run the alter table scripts.

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Go to Admin Panel -> Groups -> Permissions and re-savel all.

See http://www.jforum.net/confluence/display/upgrade/Upgrading+from+2.1.4+to+2.1.5

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Checking in phpmyadmin there is no data left in the database...

I am learning how to restore from my dump

Tony
[originally posted on jforum.net by kiwi]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Can I run Jforum 2.1.4 from the modified database structure?

I have some users who have had their registration date set to zero and that is breaking a few things...

2.1.5 forum list is broken

Tony
[originally posted on jforum.net by kiwi]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
kiwi wrote:Checking in phpmyadmin there is no data left in the database...

I am learning how to restore from my dump

Tony


Well, the migration dump does not delete any records, as you can open the .sql file (located in the "upgrading" directory) and see it by yourself.

Now, if you ran mysql_db_structr.sql, then we have a problem ;)

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Rafael Steil wrote:
kiwi wrote:Checking in phpmyadmin there is no data left in the database...

I am learning how to restore from my dump

Tony


Now, if you ran mysql_db_structr.sql, then we have a problem ;)



I am a Postgresql person who has to use MySQL in this case. I probably did a false move...

I now have a working 2.1.4 after resetting all user_regdate that were set to 0000-00-00 to todays date.

I can log into 2.1.5 but can't see forum list or posts. I can log in as admin and my own user and see/send PM etc etc. Just forums topics and posts are invisible. I have reset permissions for Groups (thanks for that!!! makes life a lot easier)

Tony
[originally posted on jforum.net by kiwi]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
So, to solve this "insivible thing", go to Admin Panel -> Groups -> Permissions, and re-save all permissions from all groups. It should work.

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Rafael Steil wrote:So, to solve this "insivible thing", go to Admin Panel -> Groups -> Permissions, and re-save all permissions from all groups. It should work.


Should...

Doesn't...

Expression repository.getCategory(category.id) is undefined on line 22, column 43 in default/admin/forum_list.htm. The problematic instruction: ---------- ==> assignment: forums=repository.getCategory(category.id).getForums() [on line 22, column 25 in default/admin/forum_list.htm] ---------- Java backtrace for programmers: ---------- freemarker.core.InvalidReferenceException: Expression repository.getCategory(category.id) is undefined on line 22, column 43 in default/admin/forum_list.htm. at freemarker.core.TemplateObject.assertNonNull(TemplateObject.java:124) at freemarker.core.TemplateObject.invalidTypeException(TemplateObject.java:134) at freemarker.core.Dot._getAsTemplateModel(Dot.java:78) at freemarker.core.Expression.getAsTemplateModel(Expression.java:89) at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:86) at freemarker.core.Expression.getAsTemplateModel(Expression.java:89) at freemarker.core.Assignment.accept(Assignment.java:90) at freemarker.core.Environment.visit(Environment.java:196) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:196) at freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:79) at freemarker.core.Environment.visit(Environment.java:196) at....

Tony
[originally posted on jforum.net by kiwi]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Sorry, I didn't read the last part of your previous message.

Ok, which database version are you using? are you able to see the data by doing some manual SELECTs to the tables?

If so, what's the contents of your jforum_roles / jforum_role_values?

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
MySQL 3.23.58

Yes - can see everything in phpmyadmin is that the same as a SELECT?

OK I see the problem the roles are in the user column and not the group column

Tony
[originally posted on jforum.net by kiwi]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Ok, it may be a problem with this version in particual (the worst mysql version ever, in my opinion).

I'll analyse that. Thanks for reporting it.

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I installed 2.1.5 clean. From the admin console, if I go to add a new thread, everything works so long as I don't deny any groups anything. If I deny groups, the forum does not get added. There is no error in the error log, it just doesn't get added. Any ideas?
[originally posted on jforum.net by rzavi4jc]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
It is added. If want to see it, you should have access rights. After adding a forum, you can change permissions at Admin Panel -> Groups -> Permissions

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Doh! Dummy me. I was an administrator and thought that granted me rights to all the forums. Sorry for the trouble.
[originally posted on jforum.net by rzavi4jc]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
hehe, no problem.

Well, I'm going to release 2.1.5 oficially.

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
With support for MySQL 3.xxxx?

Tony
[originally posted on jforum.net by Anonymous]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Yep.

Rafael

[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Any oracle 8i ,9i, &10g? Just kidding, don't want to get too demanding. Seriously though, are there any plans to support oracle any time in the near future?
[originally posted on jforum.net by rzavi4jc]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Oracle is fully supported in version 2.1.5

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Rafael Steil wrote:Ok, it may be a problem with this version in particual (the worst mysql version ever, in my opinion).

I'll analyse that. Thanks for reporting it.


Raphael

What did your analysis give? I am thinking about migrating everything to PostgreSQL - a database that I understand.

Tony
[originally posted on jforum.net by kiwi]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Go ahead and be happy

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hi!

I've just updated from 2.1.4 to 2.1.5. I followed the steps described at Upgrading from 2.1.4 to 2.1.5 and also ran the SQL script to update our Postgresql database. Now, we're getting the following when trying to access one of our forums:



Would anyone know how can we fix this?

[originally posted on jforum.net by jau]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Ops, sorry about that.

I'll update the packate to include the correct sql script.

Anyway, open the file WEB-INF/config/database/postgresql/postgresql_db_struct.sql aand get the schema from there.

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Thanks Rafael, it worked. :-)

Now when we try to post a new topic we get




Any idea?

[originally posted on jforum.net by jau]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Ok, I'll take a look

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Ok, try restarting your Tomcat again.

I checked here and would able to reproduce the bug, but only when I changed database settings in runtime.

After I restarted tomcat, all worked fine.

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Thanks again, it worked pretty well. ;-)

I'm sorry for being so dumb ops:, I should have tried the ms windows swiss army knife (turn off - turn on) on Tomcat. :-)


[originally posted on jforum.net by jau]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
correction on mysql_db_struct_sql.

in my download there were missing comas, below is the corrected version.

--
-- Table structure for table 'jforum_topics_watch'
--

DROP TABLE IF EXISTS jforum_topics_watch;
CREATE TABLE jforum_topics_watch (
topic_id INT NOT NULL,
user_id INT NOT NULL,
is_read TINYINT(1) DEFAULT '1',
INDEX idx_topic (topic_id),
INDEX idx_user (user_id)
) TYPE=InnoDB;

...using MySQL 5.0...
[originally posted on jforum.net by Anonymous]
 
Don't get me started about those stupid light bulbs.
 
subject: Version 2.1.5 is done - Testers needed