• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

Member DB migration problem

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hmm, that looks right.

Only way I can see a Null Pointer occurring in the processSelectAll code is if the following query returns a null set:



where the two parameters are 0 and the config setting for the users.per.page
[originally posted on jforum.net by monroe]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hmmmm...then I have no way to migrate my member DB using SQL??
[originally posted on jforum.net by honghoekim]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The devil is always in the details... you can create users via SQL that's what the initial data scripts do for the admin and anonymous users. (See the mysql_data_dump.sql for an example).

It could be some sort of db configuration problem or other issue. Have you tried doing the above query from the same id and password that jforum is configured with to access the db? Maybe there is an issue with table rights that is causing the data to not be found.

The devil is in the details... and it's hard to look at the details from afar. But it is possible, you may just have to dig a little deeper into your specific situation details.

You might also want to look thru the DAO (Data Access Object) code. This is how jForum access the database and manages persistent data. The methods that create new users or load users will show you exactly what SQL info is expected.

You might also check you application server logs to see if there is more information than you posted. Sometimes the message reported via the screen is the result of errors found there and not the one of the screen.
[originally posted on jforum.net by monroe]
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic