Is it a bug when no posts

[Migrated From Jforum.net]

i install the jforum when no posts then you goto "Admin Control Panel" will show error!
because the GenericForumDAO ->getBoardStatus() ->

rs = s.executeQuery(SystemGlobals.getSql("ForumModel.statsFirstPostTime"));
rs.next();
Date firstTime = new Date(rs.getTimestamp(1).getTime());


the error at rs.getTimestamp(1).getTime() because when jforum_posts no record the SQL :

SELECT MIN(post_time) FROM jforum_posts WHERE post_time > 0

MIN(NULL) is error!!




I LOVE JFORUM!!!
[originally posted on jforum.net by jyhcyd]

[Migrated From Jforum.net]

jyhcyd wrote:i install the jforum when no posts then you goto "Admin Control Panel" will show error!
because the GenericForumDAO ->getBoardStatus() ->

rs = s.executeQuery(SystemGlobals.getSql("ForumModel.statsFirstPostTime"));
rs.next();
Date firstTime = new Date(rs.getTimestamp(1).getTime());


the error at rs.getTimestamp(1).getTime() because when jforum_posts no record the SQL :

SELECT MIN(post_time) FROM jforum_posts WHERE post_time > 0

MIN(NULL) is error!!




I LOVE JFORUM!!!

http://www.jforum.net/jira/browse/JF-538
Fixed in CVS


[originally posted on jforum.net by Serge Maslyukov]

[Migrated From Jforum.net]

i get the new files from jforum but this bug is not repaired!

the error at rs.getTimestamp(1).getTime() because when jforum_posts no record the SQL :

SELECT MIN(post_time) FROM jforum_posts WHERE post_time > 0

MIN(NULL) is error!!

[originally posted on jforum.net by jyhcyd]

[Migrated From Jforum.net]

jyhcyd wrote:i get the new files from jforum but this bug is not repaired!

the error at rs.getTimestamp(1).getTime() because when jforum_posts no record the SQL :

SELECT MIN(post_time) FROM jforum_posts WHERE post_time > 0

MIN(NULL) is error!!

Do you get files from CVS?
[originally posted on jforum.net by Serge Maslyukov]

[Migrated From Jforum.net]

yes! i get files from CVS today(2006-08-22 day)

rs.getTimestamp(1).getTime() === null.getTime() is err !

i repaired here

GenericForumDAO -> getBoardStatus() -> Date firstTime = new Date(rs.getTimestamp(1).getTime());

to : Date firstTime = rs.getTimestamp(1) == null?null:new Dat(rs.getTimestamp(1).getTime());

that's all right.




thinks!

[originally posted on jforum.net by jyhcyd]

[Migrated From Jforum.net]

i hope this bug will repair!! thinks!!!
[originally posted on jforum.net by jyhcyd]

[Migrated From Jforum.net]

who can help me repair this bug in cvs ?
[originally posted on jforum.net by jyhcyd]

[Migrated From Jforum.net]

i just get the files from cvs ,this bug is repaired !!
think the body who repaired tis bug !!! thinks very much!!!

[originally posted on jforum.net by jyhcyd]

[Migrated From Jforum.net]

jyhcyd wrote:i just get the files from cvs ,this bug is repaired !!
think the body who repaired tis bug !!! thinks very much!!!

jForum team work for you
[originally posted on jforum.net by Serge Maslyukov]

[Migrated From Jforum.net]

thank Serge Maslyukov !!! i like Jforum very much! i hope Jforum is perfection !

thanks every body work for Jforum !!!
[originally posted on jforum.net by jyhcyd]