Error Message: 1615 – Prepared Statement Needs To Be Re-prepared
Marco
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
Atick Eashrak Shuvo
Accepted AnswerHi 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
Atick Eashrak Shuvo
Accepted AnswerI 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
Accepted AnswerHello,
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
Accepted AnswerI have changed your below settings
In Global Configuration > Server > Database > Database Type : MySQL (PDO)
Marco
Accepted AnswerHello,
Could you please tell me why you switched the database connection from MySQLi to MySQL (PDO)?
Regards - Marco
Marco
Accepted AnswerCould I please get more information about changing the database connection? Thanks!
Atick Eashrak Shuvo
Accepted AnswerThe 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.