Screenshot of weird stuff I'm getting when clicking on threads

[Kilowallow]

I just moved servers and when I click on threads I get this.

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?

 

[thomsa]

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?

Kilowallow
Check version of MySQL

 

[Kilowallow]

Check version of MySQL

thomsaOk I will check it now.

 

[Kilowallow]

MySQL version8.0.27 (8.0.27-0ubuntu0.20.04.1)

 

[thomsa]

MySQL version8.0.27 (8.0.27-0ubuntu0.20.04.1)

KilowallowXF version ?

 

[Kilowallow]

XF version ?

thomsav2.2.2

 

[Kilowallow]

XF version ?

thomsai had to put the --replace flag on the generation of the mysqldump file, so the file would actually load to the new server.

 

[thomsa]

v2.2.2

KilowallowOk XF 2.2.2 not support MySQL 8.0 upgrade to XF 2.2.7 pl 1

 

[Kilowallow]

Ok XF 2.2.2 not support MySQL 8.0 upgrade to XF 2.2.7 pl 1

thomsaThank you very much. I'll tell you if it works after.

 

[Kilowallow]

Ok XF 2.2.2 not support MySQL 8.0 upgrade to XF 2.2.7 pl 1

thomsaI updated the new patch but still have the errors.

 

[Kilowallow]

Ok XF 2.2.2 not support MySQL 8.0 upgrade to XF 2.2.7 pl 1

thomsaIs there an install candidate of mysql 5.7 for ubuntu 20;04?

 

[Kilowallow]

Ok XF 2.2.2 not support MySQL 8.0 upgrade to XF 2.2.7 pl 1

thomsai tried to reinstall php, dind't work, tested 2 different servers same issue, tried different flags with mysql dump files, same problem, tried to install mariadb but that thing won't work, tried to go to another mysql version but ubuntu 20 has no install candidate, tried to update xenforos to 2.2.7, disable add ons, rebuild cache, clean cloudflare cache, i did everything i could imagine.

 

[Soft4Win]

By any chance you are using redis cache? If yes than that could be one of the reasons for it.

 

[Kilowallow]

By any chance you are using redis cache? If yes than that could be one of the reasons for it.

Soft4WinI ununstalled it but it's didn't fix the problem.

 

[Soft4Win]

I ununstalled it but it's didn't fix the problem.

KilowallowWell i faced that issue, and to resolve that i cleared the redis database and regenerated it, and optimized it's db, which fixed the issue.

 

[Kilowallow]

Well i faced that issue, and to resolve that i cleared the redis database and regenerated it, and optimized it's db, which fixed the issue.

Soft4WinThank you I will try that.

 

[Kilowallow]

Well i faced that issue, and to resolve that i cleared the redis database and regenerated it, and optimized it's db, which fixed the issue.

Soft4WinIt's still not working. Will reinstalling the OS, and using one of the backups work?

 

[Kilowallow]

Well i faced that issue, and to resolve that i cleared the redis database and regenerated it, and optimized it's db, which fixed the issue.

Soft4Wini tried to reinstall php, dind't work, tested 2 different servers same issue, tried different flags with mysql dump files, same problem, tried to install mariadb but that thing won't work, tried to go to another mysql version but ubuntu 20 has no install candidate, tried to update xenforos to 2.2.7, disable add ons, rebuild cache, clean cloudflare cache, i did everything i could imagine.

 

[BattleKing]

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?

KilowallowThey 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

 

[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

BattleKingI switched from SQL to Maria DB and it worked.

 

[Kilowallow]

did you checked as well before the mysql log ?

BattleKingI cleared the server logs unfortunately.

 

[Kilowallow]

old server use mysql or mariadb ?

some commands mysql remove and not use but mariadb not remove.

thomsaI was using Mysql when we had the errors then switched to mariadb and haven't had any.