BattleKing
Spirit of darkness
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P Member
Collaborate
Registered
		- Joined
 - May 24, 2020
 
- Messages
 - 3,533
 
- Points
 - 523
 
Reputation:
I just moved servers and when I click on threads I get this.
View attachment 26385
Same problem someone else was having here.
https://xenforo.com/community/threads/xf-db-exception-mysql-fetch-error-2014-commands-out-of-sync-you-cant-run-this-command-now-in-src-xf-db-abstractstatement-php-at-line-228.189283/
Does anyone know how to fix?
If that the case you need to change the
sort_buffer_size
to a higher value, in mysqld configuration. Did you checked as well the mysql log file
- Joined
 - Jul 6, 2019
 
- Messages
 - 87
 
- Points
 - 28
 
Reputation:
- By Kilowallow
 
They got an error out of memory, did you get this as well ?
If that the case you need to change the
sort_buffer_size
to a higher value, in mysqld configuration. Did you checked as well the mysql log file
    ↑View previous replies…
    
        
	
	
	
	
		
		
			
				
					
						
	
		
		
			
		
			
			
				
				
					
						
	 
				
				
			
		
		
	 
					
				
				
					
					
						
							
								
	
		 
							
							
							
								
									
	
	
	
								
								
									
	
		
		
			
				
			
			
				
	
		
			
		
		
	
Kilowallowdid you checked as well before the mysql log ?
	
		
			
		
		
	
			
			 
			
				
			
		 
		
		
	
								
								
									
	
								
								
									
	
		
			
		
		
	
	
	
		
			
		
		
	
								
							
							
							
								
	
    
							
						
					
					
				
			
		
	 
	
	
        
    
        
	
	
	
	
		
		
			
				
					
						
	
		
		
		
			
			
				
				
					
						
	 
				
				
			
		
		
	 
					
				
				
					
					
						
							
								
	
		 
							
							
							
								
									
	
	
	
								
								
									
	
		
		
			
				
			
			
				
	
		
			
		
		
	
Kilowallowold server use mysql or mariadb ?
some commands mysql remove and not use but mariadb not remove.
	
		
			
		
		
	
			
			 
			
				
			
		 
		
		
	
								
								
									
	
								
								
									
	
		
			
		
		
	
	
	
		
			
		
		
	
								
							
							
							
								
	
    
							
						
					
					
				
			
		
	 
	
	
        
    
        
	
	
	
	
		
		
			
				
					
						
	
		
		
			
		
			
			
				
				
					
						
	 
				
				
			
		
		
	 
					
				
				
					
					
						
							
								
	
		 
							
							
							
								
									
	
	
	
								
								
									
	
		
		
			
				
			
			
				
	
		
			
		
		
	
thomsaBut the log would be great to see the exact error message 
	
		
			
		
		
	
			
			 
			
				
			
		 
		
		
	
								
								
									
	
								
								
									
	
		
			
		
		
	
	
	
		
			
		
		
	
								
							
							
							
								
	
    
							
						
					
					
				
			
		
	 
	
	
        
    
        
	
	
	
	
		
		
			
				
					
						
	
		
		
		
			
			
				
				
					
						
	 
				
				
			
		
		
	 
					
				
				
					
					
						
							
								
	
		 
							
							
							
								
									
	
	
	
								
								
									
	
		
		
			
				
			
			
				
	
		
			
		
		
	
BattleKingI cleared the server logs unfortunately.
	
		
			
		
		
	
			
			 
			
				
			
		 
		
		
	
								
								
									
	
								
								
									
	
		
			
		
		
	
	
	
		
			
		
		
	
								
							
							
							
								
	
    
							
						
					
					
				
			
		
	 
	
	
        
    
        
	
	
	
	
		
		
			
				
					
						
	
		
		
		
			
			
				
				
					
						
	 
				
				
			
		
		
	 
					
				
				
					
					
						
							
								
	
		 
							
							
							
								
									
	
	
	
								
								
									
	
		
		
			
				
			
			
				
	
		
			
		
		
	
thomsaI was using Mysql when we had the errors then switched to mariadb and haven't had any.
	
		
			
		
		
	
			
			 
			
				
			
		 
		
		
	
								
								
									
	
								
								
									
	
		
			
		
		
	
	
	
		
			
		
		
	
								
							
							
							
								
	
    
							
						
					
					
				
			
		
	 
	
	
        
    
							
						BattleKing
Spirit of darkness
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P Member
Collaborate
Registered
		- Joined
 - May 24, 2020
 
- Messages
 - 3,533
 
- Points
 - 523
 
Reputation:
- By BattleKing
 
I switched from SQL to Maria DB and it worked.
- Joined
 - Jun 22, 2019
 
- Messages
 - 1,176
 
- Points
 - 173
 
Reputation:
- By thomsa
 
I switched from SQL to Maria DB and it worked.
some commands mysql remove and not use but mariadb not remove.
BattleKing
Spirit of darkness
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P Member
Collaborate
Registered
		- Joined
 - May 24, 2020
 
- Messages
 - 3,533
 
- Points
 - 523
 
Reputation:
- By BattleKing
 
old server use mysql or mariadb ?
some commands mysql remove and not use but mariadb not remove.
- Joined
 - Jul 6, 2019
 
- Messages
 - 87
 
- Points
 - 28
 
Reputation:
- By Kilowallow
 
did you checked as well before the mysql log ?
- Joined
 - Jul 6, 2019
 
- Messages
 - 87
 
- Points
 - 28
 
Reputation:
- By Kilowallow
 
old server use mysql or mariadb ?
some commands mysql remove and not use but mariadb not remove.