Warning: Wrong COM_STMT_PREPARE Response Size. Received 7 - Question | JoomShaper
Back to the questions

Warning: Wrong COM_STMT_PREPARE Response Size. Received 7

T

timwebb

SP Page Builder 3 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.

0
4 Answers
Order by
Oldest Newest Votes
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 3 years ago #64669

Hello timwebb

Please follow this solution

Best regards

0
L
linda
Accepted Answer
1 year ago #161339

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.

0
L
linda
Accepted Answer
1 year ago #161343

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.

0
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 1 year ago #161347

Hello linda

Glad that you have found the solution.

Best regards

0