MySQL query error: Prepared statement needs to be re-prepared

[Spinix-]

Hello,

My users and I often receive the following error: "Prepared statement needs to be re-prepared". Very annoying!


My webhoster (Vimexx.nl) says it a problem with the forum software but i doubt that. They have already increased the cache to 8192. They not really helpful so maybe someone here can help me.


Server information:

 

[ForumFlex]

That is likely a sever issue https://xenforo.com/community/threa...ent-needs-to-be-re-prepared-recurring.135846/

 

[Spinix-]

That is likely a sever issue https://xenforo.com/community/threa...ent-needs-to-be-re-prepared-recurring.135846/

My hoster already changed the table_definition_cache and they are running on Maria DB 10.3.x so what do they need to change to fix this? Is there anything i can change to fix this?

 

[bzcomputers]

My hoster already changed the table_definition_cache and they are running on Maria DB 10.3.x so what do they need to change to fix this? Is there anything i can change to fix this?

In your first post you mentioned they changed the table_open_cache, are you sure they also changed the table_definition_cache?

 

[Spinix-]

In your first post you mentioned they changed the table_open_cache, are you sure they also changed the table_definition_cache?

Yes:

 

[Spinix-]

Any idea what else it can be?

 

[Spinix-]

Problem seems to be solved. Another website of mine that didn't close the database connection properly seemed to be causing this issue...

 

[Spinix-]

Unfortunately this didn't fix the problem. anyone else have an idea what it could be?

 

[Spinix-]

Somebody? What else can i try ?

 

[Spinix-]

New webhoster solved the problem...