BattleKing
Spirit of darkness
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P Member
Collaborate
Registered
- Joined
- May 24, 2020
- Messages
- 3,519
- 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,519
- Points
- 523
Reputation:
- By BattleKing
I switched from SQL to Maria DB and it worked.
- Joined
- Jun 22, 2019
- Messages
- 1,068
- 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,519
- 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.