Staff replied SP Page Builder

Error message: 1615 – Prepared statement needs to be re-prepared

Asked by Marco 3 months ago Last activity 3 months ago

Hello,
Yesterday I upgraded my Joomla website to version 6.1.1; SP Page Builder was already at version 6.6.2.

Additional information:
PHP version 8.4.17
Database version 8.0.28-19

It wasn’t until today that I saw the error message in the frontend—the backend is working fine.
Of course, the question is: why did I only see the error message today and not yesterday?
Logging is enabled in Joomla; administrator/logs/everythink.php shows a problem

/components/com_sppagebuilder/models/page.php

I commented out this line:
// $table->hit($pk);

It’s working again!

What’s going on here?

Regards - Marco

10 replies

Atick Eashrak Shuvo Staff

3 months ago

Hi there!

Thank you for bringing this to our attention, and I sincerely apologize for the inconvenience caused.

To assist you more effectively, may I kindly request temporary administrative access to your site? This will allow me to thoroughly investigate and resolve the issue for you.

Before sharing the credentials, I strongly recommend taking a complete backup of your site to ensure all data remains secure.

Looking forward to your response.

Best regards

Marco Asked this

3 months ago

Hello, of course—login credentials in hidden content

Atick Eashrak Shuvo Staff

3 months ago

Please check the hidden content area

Marco Asked this

3 months ago

sorry - not activated - now it works

Atick Eashrak Shuvo Staff

3 months ago

I apologize for the inconvenience caused. Could you please check now and let me know if the issue is resolved on your end?

Looking forward to your response.

Best regards

Marco Asked this

3 months ago

Hello,

The problem was resolved when I contacted Joomshaper—the error message no longer appeared.
“Resolved” isn't quite the right term; as I explained in the forum, I simply commented out a line of code—which, however, allowed me to get the page online.

May I ask what you were looking for in the backend?

Regards - Marco

Atick Eashrak Shuvo Staff

3 months ago

I have changed your below settings
In Global Configuration > Server > Database > Database Type : MySQL (PDO)

Marco Asked this

3 months ago

Hello,

Could you please tell me why you switched the database connection from MySQLi to MySQL (PDO)?

Regards - Marco

Marco Asked this

3 months ago

Could I please get more information about changing the database connection? Thanks!

Atick Eashrak Shuvo Staff

3 months ago

The issue is related to how the MySQL server handles prepared statements with the MySQLi database driver. In some server environments, this can trigger the "1615 – Prepared statement needs to be re-prepared" error.

Switching the database driver to MySQLi (PDO) uses a different database interface that avoids this server-side issue while maintaining the same functionality. This is a safe change and does not affect your website's data or features.