Version 2.1.5 is done - Testers needed

[Migrated From Jforum.net]

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]

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]

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]

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

delete from jforum_users where username='';

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]

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]

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:

INSERT INTO jforum_users (user_website_tmp) SELECT user_website FROM jforum_users;

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

update jforum_users set user_website_tmp = user_website;

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]

Ok, I'll fix the script. Thanks a lot

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

With support for MySQL 3.xxxx?

Tony
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Yep.

Rafael

[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

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]

Oracle is fully supported in version 2.1.5

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

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]

Go ahead and be happy

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

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:

An error has occurred.

For detailed error information, please see the HTML source code, and contact the forum Administrator.

ERROR: relation "jforum_forums_watch" does not exist

Would anyone know how can we fix this?

[originally posted on jforum.net by jau]

[Migrated From Jforum.net]

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]

Thanks Rafael, it worked. :-)

Now when we try to post a new topic we get

Caused by: org.postgresql.util.PSQLException: Returning autogenerated keys is not supported.
	at org.postgresql.jdbc3.AbstractJdbc3Connection.prepareStatement(AbstractJdbc3Connection.java:352)
	at net.jforum.dao.generic.AutoKeys.getStatementForAutoKeys(AutoKeys.java:95)
	at net.jforum.dao.generic.AutoKeys.getStatementForAutoKeys(AutoKeys.java:107)
	at net.jforum.dao.generic.GenericTopicDAO.addNew(GenericTopicDAO.java:224)
	at net.jforum.view.forum.PostAction.insertSave(PostAction.java:1035)
	... 25 more

Any idea?

[originally posted on jforum.net by jau]

[Migrated From Jforum.net]

Ok, I'll take a look

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

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]

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]

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]