<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "SQL Exception"]]></title>
		<link>https://community.jforum.net/posts/list/2.page</link>
		<description><![CDATA[Latest messages posted in the topic "SQL Exception"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>SQL Exception</title>
				<description><![CDATA[ Hi,
<br>
<br>
I just installed version 2.3.3 running with Tomcat 7.0.26 and MySQL 5.5.22. Installation went fine, but when I'm trying to create new Category (after installation) I'm getting:
<br>
java.sql.SQLException: SQL String can not be NULL.
<br>
<br>
Also creating new post to this 'Test Forum' gives the same error. Editing of 'Test Forum' (for example changing the name) works ok.
<br>
<br>
Any ideas? Too new MySQL version?
<br>
<br>
Cheers,
<br>
<br>
Jux]]></description>
				<guid isPermaLink="true">https://community.jforum.net/posts/preList/34/102.page</guid>
				<link>https://community.jforum.net/posts/preList/34/102.page</link>
				<pubDate><![CDATA[Fri, 13 Apr 2012 00:40:36]]> GMT</pubDate>
				<author><![CDATA[ Jux]]></author>
			</item>
			<item>
				<title>Re:SQL Exception</title>
				<description><![CDATA[ Hi,
<br>
<br>
Seems that something went wrong in the installation, after couple of more tries now it seems to work.
<br>
<br>
(update: actually now creating the topics etc works, but when I try to register new user I'm getting java.lang.StringIndexOutOfBoundsException: String index out of range: 20).
<br>
<br>]]></description>
				<guid isPermaLink="true">https://community.jforum.net/posts/preList/34/103.page</guid>
				<link>https://community.jforum.net/posts/preList/34/103.page</link>
				<pubDate><![CDATA[Sat, 14 Apr 2012 17:23:51]]> GMT</pubDate>
				<author><![CDATA[ Jux]]></author>
			</item>
			<item>
				<title>Re:SQL Exception</title>
				<description><![CDATA[ Hi,
<br>
<br>
I'm stuck with this problem now. When I try to create new registration - fill in all the details (name, email, pw, ...) and click 'Submit':
<br>
An error has occurred.
<br>
For detailed error information, please see the HTML source code, and contact the forum Administrator.
<br>
java.lang.StringIndexOutOfBoundsException: String index out of range: 20
<br>
<br>
and in the jforum.log shows:
<br>
<br>
2012-04-14 14:55:19,986 ERROR [ExceptionWriter] - net.jforum.exceptions.ForumException: 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:597)
<br>
at net.jforum.Command.process(Command.java:114)
<br>
at net.jforum.JForum.processCommand(JForum.java:246)
<br>
at net.jforum.JForum.service(JForum.java:228)
<br>
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
<br>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
<br>
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
<br>
at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
<br>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
<br>
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
<br>
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
<br>
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
<br>
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
<br>
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
<br>
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
<br>
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
<br>
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
<br>
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
<br>
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
<br>
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
<br>
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307)
<br>
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
<br>
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
<br>
at java.lang.Thread.run(Thread.java:680)
<br>
Caused by: java.lang.reflect.InvocationTargetException
<br>
... 27 more
<br>
Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: 20
<br>
at java.lang.String.charAt(String.java:686)
<br>
at sun.net.www.ParseUtil.isEscaped(ParseUtil.java:458)
<br>
at sun.net.www.ParseUtil.quote(ParseUtil.java:424)
<br>
at sun.net.www.ParseUtil.appendSchemeSpecificPart(ParseUtil.java:354)
<br>
at sun.net.www.ParseUtil.toString(ParseUtil.java:311)
<br>
at sun.net.www.ParseUtil.createURI(ParseUtil.java:289)
<br>
at sun.net.www.ParseUtil.toURI(ParseUtil.java:266)
<br>
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:905)
<br>
at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:836)
<br>
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1172)
<br>
at com.sun.org.apache.xerces.internal.impl.XMLEntityManager.setupCurrentEntity(XMLEntityManager.java:677)
<br>
at com.sun.org.apache.xerces.internal.impl.XMLVersionDetector.determineDocVersion(XMLVersionDetector.java:186)
<br>
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:772)
<br>
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)
<br>
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:119)
<br>
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)
<br>
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)
<br>
at org.jdom.input.SAXBuilder.build(SAXBuilder.java:518)
<br>
at org.jdom.input.SAXBuilder.build(SAXBuilder.java:986)
<br>
at net.jforum.security.StopForumSpam.getXmlRootElement(StopForumSpam.java:82)
<br>
at net.jforum.security.StopForumSpam.getResult(StopForumSpam.java:74)
<br>
at net.jforum.security.StopForumSpam.checkIp(StopForumSpam.java:65)
<br>
at net.jforum.view.forum.UserAction.insertSave(UserAction.java:301)
<br>
... 27 more
<br>
<br>
Any advice?
<br>]]></description>
				<guid isPermaLink="true">https://community.jforum.net/posts/preList/34/104.page</guid>
				<link>https://community.jforum.net/posts/preList/34/104.page</link>
				<pubDate><![CDATA[Sat, 14 Apr 2012 19:59:47]]> GMT</pubDate>
				<author><![CDATA[ Jux]]></author>
			</item>
			<item>
				<title>回覆:SQL Exception</title>
				<description><![CDATA[ It seems to be the problem of using StopForumSpam-check API introduced since JForum 2.3.2.
<br>
Does your forum server have Internet connection?]]></description>
				<guid isPermaLink="true">https://community.jforum.net/posts/preList/34/105.page</guid>
				<link>https://community.jforum.net/posts/preList/34/105.page</link>
				<pubDate><![CDATA[Sat, 14 Apr 2012 21:36:59]]> GMT</pubDate>
				<author><![CDATA[ andowson]]></author>
			</item>
			<item>
				<title>Re:SQL Exception</title>
				<description><![CDATA[ Hi,
<br>
<br>
Yep, it has the internet connection - at least it's suggesting that there is new version available if I use 2.3.2 version... And with 2.3.1 this problem disappeared.
<br>
<br>
So I think you are heading to the right direction...]]></description>
				<guid isPermaLink="true">https://community.jforum.net/posts/preList/34/106.page</guid>
				<link>https://community.jforum.net/posts/preList/34/106.page</link>
				<pubDate><![CDATA[Sat, 14 Apr 2012 21:47:19]]> GMT</pubDate>
				<author><![CDATA[ Jux]]></author>
			</item>
	</channel>
</rss>