Got an idea for a site feature, a suggestion for an article, or spotted an error we made, feel free to post it here.
Guests can post here!
			
		
		
			- 
				
								acidbeast							
 
									
		- Posts: 1
 		- Joined: Wed Jan 11, 2012 10:23 pm
 		
		
											
							- 
				Contact:
				
			
 
				
		
		
						
						
													
							
						
									
						Post
					
								by acidbeast » Wed Jan 11, 2012 10:31 pm
			
			
			
			
			I submit russian letters into search form at knowledge pages and get error:
SELECT id,parent FROM module_knowledge WHERE ((subject LIKE '%ывыв%' OR short_desc LIKE '%ывыв%' OR message_search LIKE '%ывыв%')) AND status=1 ORDER BY parent ASC
1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' (module_knowledge.php #120)
Backtrace:
index.php #118 -> module_knowledge.php #120
p.s: I don't try search something in russian here, just was wrong keyboard language.
			
									
									
						 
		 
				
		
		 
	 
	
				
		
		
			- 
				
								Khuri							
 
						- AOU Site Manager
 			
		- Posts: 734
 		- Joined: Thu Sep 29, 2005 7:57 pm
 		
		
																					- Location: Germany
 
							
							- 
				Contact:
				
			
 
				
		
		
						
						
													
							
						
									
						Post
					
								by Khuri » Wed Jan 11, 2012 11:16 pm
			
			
			
			
			The database doesn't like those symbols as search-words in the configuration.
But thanks for the info, i'll add a filter tomorrow so the search doesn't accept these chars at all anymore.
			
									
									
						 
		 
				
		
		 
	 
	
				
		
		
			- 
				
								Khuri							
 
						- AOU Site Manager
 			
		- Posts: 734
 		- Joined: Thu Sep 29, 2005 7:57 pm
 		
		
																					- Location: Germany
 
							
							- 
				Contact:
				
			
 
				
		
		
						
						
													
							
						
									
						Post
					
								by Khuri » Thu Jan 12, 2012 11:03 am
			
			
			
			
			That problem should be gone now 
