Intermittent error Prepared statement needs to be re-prepared

[oorzaak]

Hi,

We are developing a new site using Joomla 4. Unfortunately we have an intermittent error going on, which says:

Prepared statement needs to be re-prepared

See also attached screenshot.

Reloading the page does not solve it immediately. After a few minutes the site will be running fine again, without any actions from us.

We cannot find out any pattern behind this. I may happen when just visiting a page as a frontend user, or when working in the back end.

We've tried many things, like switching off extensions, but we didn't find a solution yet.

In the error reporting, we also see that this line is highlighted:

Code: Select all

 $template = $db->loadObject();

For your information: we cloned the Cassiopeia and made some template overrides on this clone (we like to keep our overrides outside the original core template, just in case any core updates might result in a conflict). Still, we cannot find any flaws in our clone or overrides that could explain this error. Also, the site may be running fine for an hour or more while we are working on it, and then suddenly display this error again. I would expect an error in our overrides to give a more consistent error pattern.

Hope that anyone recognizes this issue?

[edit: forgot to upload the screenshot]

Prepared_statement_needs_to_be_re-prepared__500_Whoops__looks_like_something_went_wrong__.jpg

[Webdongle]

Does it only happen with your copy?

[oorzaak]

For us, this issue seems to be hosting dependent. We developed the site on one hosting, then transfered it to another hosting environment for production. We do not have this issue at all on the production hosting.

However we dit not yet solve it on the develop hosting.

[pe7er]

For us, this issue seems to be hosting dependent.

Are you using the same SQL database & version on the working and non-working websites? so both MySQL or both Mariadb, and both the same version?
Could compare the MySQL configuration settings?