errors after installing: register new user

Ranch Hand

Posts: 17424

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi all,

I just installed jforum on localhost and I get erros when I try to register new user.

Also, I use Russian language and for some reason some pages do no display them. Instead of them I see question marks.
How can these problems be corrected? I am attaching stack trace.

Thanks in advance!

<!-- BEGIN ERROR STACK TRACE
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.JForum.service(JForum.java:182)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:738)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: Illegal mix of collations (koi8r_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
	at net.jforum.dao.generic.GenericUserDAO.isUsernameRegistered(GenericUserDAO.java:521)
	at net.jforum.view.forum.UserAction.insertSave(UserAction.java:208)
	... 24 more

END ERROR STACK TRACE-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta http-equiv="Pragma" content="no-cache"/>
<meta http-equiv="Expires" content="-1"/>
<style type="text/css">@import url( /jforum/templates/default/styles/style.css?1155150997925 );</style>
<style type="text/css">@import url(/jforum/templates/default/styles/ru_RU.css?1155150997925);</style>
<title>My Forum - your_board_title</title>
</head>
<body class="ru_RU">

<!--
Original theme from phpBB (http://www.phpbb.com) subSilver
Created by subBlue design
http://www.subBlue.com

Modifications by JForum Team
-->

<table  border="0">
 	<tr>
 		<td>
 			<table    border="0">
 				<tr>
 					<td>
 						<a href="http://localhost:8080" rel="nofollow"><img    border="0"  /></a>
 					</td>
 					 
 					<td   >
 						<span class="maintitle">My Forum - your_board_title</span>
 						<table   border="0">
 							<tr>
 								<td   > 
 									<img  />
 									<span class="mainmenu"><a id="search" class="mainmenu"  rel="nofollow"><b>?????</b></a>  
 									
 									<img   />
 									<a id="latest" class="mainmenu"  rel="nofollow">Recent Topics</a>  
 									<img   /> 
 									<a id="latest2" class="mainmenu"  rel="nofollow">Member Listing</a>  
 									<span class="mainmenu"> <img   /> <a id="backtosite" class="mainmenu" href="http://localhost:8080" rel="nofollow">?? ??????? ????????</a> 
 
 	
 										<br/>
 										<a id="register" class="mainmenu"  rel="nofollow"><img  border="0"  /> ???????????</a> / </span>
 										<a id="login" class="mainmenu"  rel="nofollow"><img  border="0"  /> ????</a>  </span>
 								</td>
 							</tr>
 						</table>
 					</td>
 				</tr>
 			</table>
 		</td>
 	</tr>
 	<tr>
 		<td>
 <a  id="top" rel="nofollow"></a>
 <table    border="0" >
 	<tr>
 		<td class="bodyline">
 			
 			<table    border="0" >
 				<tr>
 					<td  class="nav"><a class="nav"  rel="nofollow">?????? ??????</a></td>
 				</tr>
 			</table>
   
 			<table class="forumline"    border="0">
 				<tr>
 					<th class="thhead" ><b>??????????</b></th>
 				</tr>
 				
 				<tr>
 					<td class="row1">
 						<table    border="0">
 							<tr>
 								<td> </td>
 							</tr>
 	  
 							<tr>
 								<td ><div class="gen"><p >An error has occurred.</p><p>For detailed error information, please see the HTML source code, and contact the forum Administrator.</p><pre class="pre-error"><i>Illegal mix of collations (koi8r_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='</i></pre></div></td>
 							</tr>
 				  
 							<tr>
 								<td> </td>
 							</tr>
 
 							<tr>
 								<td ><a class="nav"  rel="nofollow">?????? ??????</a> </td>
 							</tr>
 						</table>
 					</td>
 				</tr>
 			</table>
 		</td>
 	</tr>
 </table>
 </td>
 </tr>
 	<tr>
 		<td >
 			
 		</td>
 	</tr>
 
 	<tr>
 		<td >
 			<span class="copyright">Powered by <a class="copyright" href="http://www.jforum.net/" target="_blank" rel="nofollow">JForum 2.1.6</a> © <a class="copyright" href="http://www.jforum.net/team.jsp" target="_blank" rel="nofollow">JForum Team</a></span>
 		</td>
 	</tr>
 </table>
<iframe src="/jforum/templates/ping_session.jsp" height="0" width="0" frameborder="0" scrolling="no"></iframe>
</body>
</html>

[originally posted on jforum.net by ThisGuest]

Migrated From Jforum.net

Ranch Hand

Posts: 17424

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I am back with a different user name.

I solved the Java error.

thanks
[originally posted on jforum.net by AnotherGuest]

With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.