Hi~ I'm really regular customer
What I want to ask is user db migration.
I have succeded with migrating my old and I want to do this with member table.
I did following steps
(1) insert member information using SQL in jforum_users
I have inserted all the column except NULL column.
insert into jforum_users(user_id,username,user_password,user_session_time
,user_session_page, user_regdate
,user_posts,user_timezone, user_lang,user_dateformat,user_new_privmsg
,user_unread_privmsg, user_viewemail
,user_attachsig,user_allowhtml,user_allowbbcode,user_allowsmilies
,user_allowavatar,user_allow_pm,user_allow_viewonline,user_notify,user_notify_always
,user_notify_text,user_notify_pm,user_popup_pm,rank_id,user_avatar_type,user_email
,user_viewonline,user_karma) values
('6','test1','202cb962ac59075b964b07152d234b70','0','0',now(),'0','','','%d/%M/%Y %H:%i','0','0','0','1','0','1','1','1','1','1','1','0','0','1','1','1','0','test@test.com','1','0');
(2) insert member information using SQL in jforum_users_groups
insert into jforum_user_groups values ('1','6');
(3) restart
Tomcat
But, When I see my admin page and look user menu.
Error occured like this.
For detailed error information, please see the HTML source code, and contact the forum Administrator.
java.lang.reflect.InvocationTargetException
_____________________________________________________
<!-- BEGIN ERROR STACK TRACE
<br /> net.jforum.exceptions.ForumException: java.lang.reflect.InvocationTargetException
<br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
<br /> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
<br /> at java.lang.reflect.Method.invoke(Unknown Source)
<br /> at net.jforum.Command.process(Command.java:117)
<br /> at net.jforum.view.admin.AdminCommand.process(AdminCommand.java:64)
<br /> at net.jforum.JForum.processCommand(JForum.java:220)
<br /> at net.jforum.JForum.service(JForum.java:203)
<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
<br /> at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
<br /> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
<br /> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
<br /> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
<br /> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
<br /> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
<br /> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
<br /> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
<br /> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
<br /> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
<br /> at java.lang.Thread.run(Unknown Source)
<br /> Caused by: java.lang.reflect.InvocationTargetException
<br /> ... 24 more
<br /> Caused by: java.lang.NullPointerException
<br /> at net.jforum.dao.generic.GenericUserDAO.processSelectAll(GenericUserDAO.java:521)
<br /> at net.jforum.dao.generic.GenericUserDAO.selectAll(GenericUserDAO.java:485)
<br /> at net.jforum.view.admin.UserAction.list(UserAction.java:76)
<br /> ... 24 more
<br />
<br /> END ERROR STACK TRACE-->
____________________________________________________
What I must do more???
[originally posted on jforum.net by honghoekim]