Win a copy of 97 Things Every Java Programmer Should Know this week in the Java in General forum!
  • 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • salvin francis
  • fred rosenberger

Anonymous Posts

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi! I have instaled the 2.1.6 version. It's all ok!
But...
It's possible to configure post/replay of registered users only? If yes, how?
Tks!
[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
lol sorry ^_^
my post! :P
so, can help?
[originally posted on jforum.net by cassitos]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes. Set the permissions at Admin Panel -> Group -> Permissions

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Tks man! I found the option. Well, when try to save the changes. this error return:

Informa���

An error has occurred.

For detailed error information, please see the HTML source code, and contact the forum Administrator.

SQL String can not be NULL


�dice dos f�?��s



In source code have:

<!-- BEGIN ERROR STACK TRACE <br /> java.lang.reflect.InvocationTargetException <br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) <br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) <br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) <br /> at java.lang.reflect.Method.invoke(Method.java:324) <br /> at net.jforum.Command.process(Command.java:116) <br /> at net.jforum.view.admin.AdminCommand.process(AdminCommand.java:63) <br /> at net.jforum.JForum.service(JForum.java:182) <br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) <br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) <br /> at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98) <br /> at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176) <br /> at java.security.AccessController.doPrivileged(Native Method) <br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172) <br /> at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59) <br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) <br /> at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98) <br /> at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176) <br /> at java.security.AccessController.doPrivileged(Native Method) <br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172) <br /> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) <br /> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) <br /> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) <br /> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) <br /> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) <br /> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) <br /> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) <br /> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) <br /> at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422) <br /> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) <br /> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) <br /> at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) <br /> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) <br /> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163) <br /> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) <br /> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) <br /> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) <br /> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) <br /> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) <br /> at LocaWebValve.invoke(LocaWebValve.java:101) <br /> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) <br /> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) <br /> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) <br /> at org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:457) <br /> at org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:576) <br /> at java.lang.Thread.run(Thread.java:534) <br /> Caused by: java.sql.SQLException: SQL String can not be NULL <br /> at com.mysql.jdbc.PreparedStatement.init(PreparedStatement.java:435) <br /> at com.mysql.jdbc.Connection.clientPrepareStatement(Connection.java:2076) <br /> at com.mysql.jdbc.Connection.clientPrepareStatement(Connection.java:2007) <br /> at com.mysql.jdbc.Connection.prepareStatement(Connection.java:4309) <br /> at com.mysql.jdbc.Connection.prepareStatement(Connection.java:4226) <br /> at net.jforum.dao.mysql.security.MySQL323GroupSecurityDAO.deleteAllRoles(MySQL323GroupSecurityDAO.java:65) <br /> at net.jforum.security.PermissionControl.deleteAllRoles(PermissionControl.java:91) <br /> at net.jforum.view.admin.PermissionProcessHelper.init(PermissionProcessHelper.java:173) <br /> at net.jforum.view.admin.PermissionProcessHelper.init(PermissionProcessHelper.java:71) <br /> at net.jforum.view.admin.GroupAction.permissionsSave(GroupAction.java:198) <br /> ... 45 more <br /> <br /> END ERROR STACK TRACE-->




[originally posted on jforum.net by cassitos]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Open the file WEB-INF/config/database/mysql/mysql.properties, and see if there is a property named "PermissionControl.getRoleIdsByGroup".

If not, open the file 'mysql_323.sql', found in the same directory, and copy all of its contents to mysql.sql.

It should fix the problem.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
lol Tks for reply man, but now the message is:


Informa���

An error has occurred.

For detailed error information, please see the HTML source code, and contact the forum Administrator.

java.lang.reflect.InvocationTargetException


�dice dos f�?��s





java.lang.reflect.InvocationTargetException
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 net.jforum.Command.process(Command.java:116)
at net.jforum.view.admin.AdminCommand.process(AdminCommand.java:63)
at net.jforum.JForum.service(JForum.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at LocaWebValve.invoke(LocaWebValve.java:101)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:457)
at org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:576)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.lang.NullPointerException
at net.jforum.dao.mysql.security.MySQL323GroupSecurityDAO.getStatementForCsv(MySQL323GroupSecurityDAO.java:95)
at net.jforum.dao.mysql.security.MySQL323GroupSecurityDAO.deleteAllRoles(MySQL323GroupSecurityDAO.java:77)
at net.jforum.security.PermissionControl.deleteAllRoles(PermissionControl.java:91)
at net.jforum.view.admin.PermissionProcessHelper.init(PermissionProcessHelper.java:173)
at net.jforum.view.admin.PermissionProcessHelper.init(PermissionProcessHelper.java:71)
at net.jforum.view.admin.GroupAction.permissionsSave(GroupAction.java:198)
... 45 more


[originally posted on jforum.net by cassitos]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I managed to fix this in my forum thanks to your explanations Rapha��l

Tony
[originally posted on jforum.net by kiwi]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
in my computer with mysql 4.0 and tomcat 5 this function works very well.
But in web server with mysql 3.23.58 with tomcat 4.1 not work...
How can I fix this... can't update mysql and tomcat there...
ehehehe
tks for help
[originally posted on jforum.net by cassitos]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am running Tomcat 5.1.x with MySQL 3.23.xx

Tony
[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hummm... so... i don't know more... ehehehe...
ok. tks
[originally posted on jforum.net by cassitos]
 
Shiny ad:
Devious Experiments for a Truly Passive Greenhouse!
https://www.kickstarter.com/projects/paulwheaton/greenhouse-1
    Bookmark Topic Watch Topic
  • New Topic