安道生練功房 - Latest posts for "acer123"

[JForum中文社群 JForum Chinese Users Community] Re:JForum 2.2.0 Released

acer123 — GMT

Thanks dude. If you check my previous posts i fixed some of the bugs which i encountered in 2.1.8. We still have not gone live but was just wondering if all of those were fixed in the 2.1 release which you created.

I already download it and testing but have not tested it heavily. Thinking of doing a thorough testing next week for 2.1 and will let you know..

[JForum中文社群 JForum Chinese Users Community] Re:JForum 2.2.0 Released

acer123 — GMT

Thanks man. Trying it now. I saw the new libraries included in this new version but does all the other pagination, SSO bug were also fixed in this one ?

[JForum中文社群 JForum Chinese Users Community] Re:关于搜索，有问题求教~

acer123 — GMT

BTW just curious what is LuceneIndex functionality ? I search it on wiki and it states something like a backup. When i try to execute under Admin control panel i see some files created but when opened are all in ASCII characters. Whats the use of it ?

[JForum中文社群 JForum Chinese Users Community] Re:Postgre CURRVAL issue

acer123 — GMT

Never mind i got it :--)

[JForum中文社群 JForum Chinese Users Community] Re:Pagination issue

acer123 — GMT

Could you please show me the code for the one which you are having issues with pagination ?. All you need to do is in xyzAction.java add :-

this.context.put("action",action);

and in the JSP page at the bottom where they have the pagination you need to put action in there thats all

[JForum中文社群 JForum Chinese Users Community] Postgre CURRVAL issue

acer123 — GMT

I install JForums on postgres. I am assuming that the only SQL file JForum uses for all it's queries is generic_queries.sql because the DB which i have consist of schemaname.tablename and because of that i had to change all of my SQL file.

Since this was an issue so inserted everything manually and implemented SSO which is working just fine. There were several bug which i faced on PSQL JForums which i will post in your JIRA site.

I have a question. Everytime i post a message on JForums or create a topic or send a PVT message to a user i get a PSQLException :-

Error: currval of sequence "jforum_privmsgs_seq" is not yet defined in the session.

I saw in postgresql.sql file it has :-

select CURRVAL('jforum_privmsgs_seq')
select CURRVAL('jforum_topics_seq')

[JForum中文社群 JForum Chinese Users Community] 回覆:Possible bug in the forums

acer123 — GMT

Thanks man. I will sure do that. The more I play around with it the more I get issues and the more I fix it with your help also . Hope to continue support and report bugs and their fixes also.

[JForum中文社群 JForum Chinese Users Community] 回覆:Possible bug in the forums

acer123 — GMT

Ok i found the solution. Hope this is helpful for everyone. in UserAction.java under commonData() add :-

this.context.put("action","list");

And then change the bottom line in user_list.htm :-

<#if thisPage?exists><@pagination.doPagination action/>

That's it. As commonData() is always called for any kind of action in UserAction.java whether you edit a user or edit a group. So now we know that action will always be list whenever it goes in commonData(). I don't know why a user when edited through the Admin page and click submit it always have the last action of editSave(). so when you click on the second page hence you get the exception. When the page refreshes everything works fine.

Hope this helps other people.

[JForum中文社群 JForum Chinese Users Community] Possible bug in the forums

acer123 — GMT

I cannot find any jira site for the forums where i can post the possible bugs which i have found and been trying to fix recently. andwoson site looks pretty good and active also which is still suporting for JForums. I will also post my bugs and the fix i did so other people might find useful. One of them which i encountered lately is with the pagination:-

1) Go to Admin Control Panel
2) In page1 click on any user Edit link. Just click on submit when you are in edit page or try to edit any kind of information like firstname, lastname, etc for the user. Once clicked submit it will redirect you to the user listing page under admin control panel
3) Now click on page 2 and you will see the exception .

The problem is when you get returned from editing the user information jforums shows the next page link as :-

http://localhost:8080/jforums/adminUsers/editSave/30.page (This link throws an exception as there is nothing defined in urlpattern for editSave)

where originally it is suppose to show :-

http://localhost:8080/jforums/adminUsers/list/30.page

Any clue if this has to do something with the pagination.ftl ? or if you have encountered this issue ?

[JForum中文社群 JForum Chinese Users Community] 回覆:Pagination issue

acer123 — GMT

Ok i was able to fix the issue by adding :-

adminGroups.list.0 =

It worked perfectly. Hopefully people who are trying to do pagination can find this post helpful.

[JForum中文社群 JForum Chinese Users Community] 回覆:Pagination issue

acer123 — GMT

And in the group-list.htm where it uses the group-macros.ftl i replaced the looping with th <#list>. I am sure that should not be an issue

[JForum中文社群 JForum Chinese Users Community] 回覆:Pagination issue

acer123 — GMT

Hi adwoson. Thanks for your reply. I output the URL and it states :-

http://localhost:8080/jforum/adminGroups/list-30?null

The parameter i get for the second page is null hence the exception. I tried several senarious but just could not find a way to fix it. Any hints.

[JForum中文社群 JForum Chinese Users Community] 回覆:Pagination issue

acer123 — GMT

Ah appologies for the double post. Actually i was trying to edit and instead i later on realized that i quoted :--(. I was able to make it work. What i did is made some changes in group_list.htm file in admin. I can see the pagination and the first page displays 30 records. But when i click on second page i get a nasty exception.



<#list grouping as group>

    
        ${group.name}
        ${I18n.getMessage("Groups.List.Edit")}
        
        ${I18n.getMessage("Permissions")}
    

    
.
.
.





<#if thisPage?exists><@pagination.doPagination grouping/>

When i click on the second page this is what i get :-

[JForum中文社群 JForum Chinese Users Community] 回覆:Pagination issue

acer123 — GMT

And i created a variable in ConfigKeys.java also for GROUPS_PER_PAGE

[JForum中文社群 JForum Chinese Users Community] Pagination issue

acer123 — GMT

Hello. I am trying to do some pagination under Admin Panel for Groups. I made the appropriate changes to the code and i can see the pagination at the end of the page (When admin clicks on groups link under Admin Control Panel). The problem is that the groups page still shows all the groups in one page and shows the pagination at the bottom also which i am sure is not correct because i get a macro exception.

Can someone point me out what am i doing wrong. Thanks.

GroupAction


    public void list()
    {
        System.out.println("Inside list()");
        int start = this.preparePagination(DataAccessDriver.getInstance().newGroupDAO().getTotalGroups());
        System.out.println("Start is [ " + start + " ] ");
        int groupsPerPage = SystemGlobals.getIntValue(ConfigKeys.GROUPS_PER_PAGE);
        System.out.println("Groups per page [ " + groupsPerPage + " ] ");
        this.context.put("groups", new TreeGroup().getNodes());
        this.context.put("grouping", DataAccessDriver.getInstance().newGroupDAO().selectAll(start ,groupsPerPage));
        //this.commonData();
        
        this.setTemplateName(TemplateKeys.GROUP_LIST);
    }
    
    private int preparePagination(int totalGroups)
    {
        int start = ViewCommon.getStartPage();
        LOG.info("Start is [ " + start + " ]");
        int groupsPerPage = SystemGlobals.getIntValue(ConfigKeys.GROUPS_PER_PAGE);
        LOG.info("Groups Per Page is [ " + groupsPerPage + " ] ");
        ViewCommon.contextToPagination(start, totalGroups, groupsPerPage);
        
        return start;
    }

GroupDAO


    public int getTotalGroups() ;
    
    public List selectAll(int startFrom, int count) ;

GenericGroupAction


    /**
     * @see net.jforum.dao.GroupDAO#getTotalGroups()
     */
    
    public int getTotalGroups()
    {
        PreparedStatement preparedStatement = null;
        try {
            preparedStatement = JForumExecutionContext.getConnection().prepareStatement(
                    SystemGlobals.getSql("GroupModel.totalGroups"));
            return this.getTotalGroupsCommon(preparedStatement);
        }
        catch (SQLException e) {
            throw new DatabaseException(e);
        }
        finally {
            DbUtils.close(preparedStatement);
        }
    }
    
    protected int getTotalGroupsCommon(PreparedStatement p) throws SQLException
    {
        System.out.println("Insid egetTotalGroupsCommon");
        ResultSet rs = p.executeQuery();
        rs.next();

        int total = rs.getInt(1);

        rs.close();
        p.close();

        return total;
    }
    
    protected List processSelectAll(ResultSet rs) throws SQLException
    {
        System.out.println("Inside processSelectAll()");
        List list = new ArrayList();

        while (rs.next()) {
            Group g = new Group();
            g.setId(rs.getInt("group_id"));
            g.setName(rs.getString("group_name"));
            g.setParentId(rs.getInt("parent_id"));
            g.setDescription(rs.getString("group_description"));
            list.add(g);
        }

        return list;
    }
    
    public List selectAll(int startFrom, int count)
    {
        System.out.println("Inside selectAll()");
        PreparedStatement p = null;
        ResultSet rs = null;

        try {
            if (count > 0) {
                p = JForumExecutionContext.getConnection().prepareStatement(
                        SystemGlobals.getSql("GroupModel.selectAllByLimit"));
                p.setInt(1, startFrom);
                p.setInt(2, count);
            }
            else {
                p = JForumExecutionContext.getConnection()
                        .prepareStatement(SystemGlobals.getSql("GroupModel.selectAll"));
            }

            rs = p.executeQuery();

            return this.processSelectAll(rs);
        }
        catch (SQLException e) {
            throw new DatabaseException(e);
        }
        finally {
            DbUtils.close(rs, p);
        }
    }

SystemGlobals.properties

groupsPerPage = 30

genericqueries.sql


GroupModel.totalGroups = SELECT COUNT(1) as total_groups FROM jforum_groups
GroupModel.selectAllByLimit = SELECT group_id, group_name, parent_id, group_description \
    FROM jforum_groups ORDER BY group_name LIMIT ?, ?

group_list.htm






            <#if thisPage?exists><@pagination.doPagination groups/>