[Opensource] Exception replying to forum message

[Peter A. Pilgrim]

D Lloyd wrote:
> I was trying to reply to an eForum message on the jcorporate site and
> recieved an exception.
> 
> The message was
> http://www.jcorporate.com/eforum/Browse.do?state=promptReply&MessageId=6867
> 
> exception:
> 
> com.jcorporate.expresso.core.db.DBException: cannot find user: 470 at
> com.jcorporate.expresso.core.security.User.getUserFromId(User.java:1353)
> at com.jcorporate.eforum.dbobj.ForumMessage.add(ForumMessage.java:208) at
> com.jcorporate.eforum.controller.Browse.runReplyToState(Browse.java:1241)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324) at
> com.jcorporate.expresso.core.controller.Controller.newState(Controller.java:1371)
> at
> com.jcorporate.expresso.core.controller.Controller.execute(Controller.java:1843)
> at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
> at
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
> at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
> at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:165) at 
> 
> 
> 
> Is this a "normal" situation where a subscriber to the list would not be
> found?  Do we need a check here catching this exception?  I guess this is
> about the last thing that a user would want to see when posting unless
> noone would recieve the message.  Of course the person being ignored might
> not like it either unless the problem is the user has been deleted.  Which
> brings up the point - did my message get sent?
> 
> Well my reply had mentioned it being late.  Now it is very late.  Good
> night.
> 
> - David Lloyd
>   d a v i d @ l l o y d h o m e . c o m
> --------------
>  I love deadlines. I like the whooshing sound they make as they fly by.
>     (Douglas Adams)

I think this looks like a data integrity problem. Forum subscriber that does
not exist in the Expresso Users table.



mysql> SELECT F.ExpUid, U.LoginName, U.Email, U.CreateDate, U.AccountStatus
FROM FORUMSUBSCRIBE F RIGHT OUTER JOIN USERSTABLE U
ON U.ExpUid = F.ExpUID
WHERE  F.ExpUid IS NULL;

+--------+-----------+-------+---------------------+---------------+
| ExpUid | LoginName | Email | CreateDate          | AccountStatus |
+--------+-----------+-------+---------------------+---------------+
|   NULL | Anonymous | none  | 2002-08-28 02:21:11 | D             |
|   NULL | NONE      | none  | 2002-08-28 02:21:11 | D             |
+--------+-----------+-------+---------------------+---------------+
2 rows in set (0.00 sec)

There should at least be two users.

-- 
Peter Pilgrim
            __ _____ _____ _____
           / //__  // ___// ___/   +  Serverside Java
          / /___/ // /__ / /__     +  Struts
         / // ___// ___// ___/     +  Expresso Committer
      __/ // /__ / /__ / /__       +  Independent Contractor
     /___//____//____//____/       +  Intrinsic Motivation
On Line Resume
    ||
    \\===>  `` http://www.xenonsoft.demon.co.uk/no-it-striker.html ''