Wrong Com_stmt_prepare Response Size. Received 7 In ../libraries/vendor/joomla/database/src/mysqli/mysqlistatement.php

Need help with the Administration of your Joomla! 4.x site? This is the spot for you.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Post Reply
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Thu Oct 14, 2021 9:10 am

Wrong Com_stmt_prepare Response Size. Received 7 In ../libraries/vendor/joomla/database/src/mysqli/mysqlistatement.php

Post by Theotherone » Thu Oct 14, 2021 9:22 am

I have update my test-site from joomla 3 to 4.0.2. After this I recive above warning opening pagebuilder component.
Hoster has changed the system to mysql8, too.

Same site at another hoster (not mysql8) works well. Site with joomla 3 and mysql 8 works

Wether pagebuilder support nor my hoster can / want help me.

I have found this entry where a solution is described:
https://stackoverflow.com/questions/439 ... avel-error

Also faced the same problem. My web host provider was [url banned]. Just set this PDO attribute PDO::ATTR_EMULATE_PREPARES to true in your database config file (config/database.php) and it should work fine.

'mysql' => [
'driver' => 'mysql',
'host' => env('DB_HOST', 'localhost'),
'options' => [PDO::ATTR_EMULATE_PREPARES => true,]

But how and where can I set this in joomla?

Thanks in advance and hope in right here

Post Reply

Return to “Administration Joomla! 4.x”