Warning: Wrong COM_STMT_PREPARE response size. Received 7 - Forum | JoomShaper
Staff replied SP Page Builder

Warning: Wrong COM_STMT_PREPARE response size. Received 7

Asked by timwebb 4 years ago Last activity 2 years ago

Hi

I am seeing this error whenever I am accessing SP Page Builder > Pages.

Warning: Wrong COM_STMT_PREPARE response size. Received 7 in .....\libraries\vendor\joomla\database\src\Mysqli\MysqliStatement.php on line 137.

This is happening now with Joomla 4.1.2 Stable (PHP 7.4.1, MySQL 8).
This error was not appearing before with previous Joomla version before update to Joomla 4.1.2.

3 replies

linda

Hi Ofi Khan,
I'm having the same error when i moved to a new server, however the link you shared with solution, "Just set this PDO attribute PDO::ATTR_EMULATE_PREPARES to true in your database config file (config/database.php) and it should work fine."
i didnt know which file to edit exactly, i cant find that file in Joomla files, kindly help!
Thank you in advance.

linda

Nevermind i found the solution after 2 days of searching.
Go to Global Configuration > Server > and change Database Type from MySQL to MySQL PDO
the error disappeared.

Ofi Khan Staff

Hello linda

Glad that you have found the solution.

Best regards

Log in to reply.