XF 2.1 Prepared statement needs to be re-prepared

[Robert9]

My ISP has made an update (i guess on php to 7.2.32), now i have this error. It comes from different urls all 10-20 minutes).
Sometimes with an addon, sometimes without.

• XF\Db\Exception: MySQL query error [1615]: Prepared statement needs to be re-prepared
• src/XF/Db/AbstractStatement.php:228

 

[Paul B]

Try increasing the table_definition_cache value in my.cnf.

 

[Robert9]

select @@table_open_cache;

is set to 2000;


show global status like 'opened_tables'

shows

Opened_tables

1162320

I have changed /etc/mysql/mysql.conf with
table_open_cache=8192
mysql restarted; still have
select @@table_open_cache set to 2000;
So my conf seems to be somehwere else ... i am searching ...