Deprecated: PDO::quote(): Passing null to parameter #1

  • Posts: 4
  • Thank you received: 0
1 month 1 week ago #363382

-- url of the page with the problem -- : www.nacgym.fr/
-- HikaShop version -- : 5.1.1
-- Joomla version -- : 4.4.8
-- PHP version -- : 8.2
-- Browser(s) name and version -- : Chrome 128.0.6613.138
-- Error-message(debug-mod must be tuned on) -- : Deprecated: PDO::quote(): Passing null to parameter #1 ($string) of type string is deprecated in /home/nacgym/www/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php on line 736

Hello,
since few days, and even with the last update done, I have the following message when I finalyse my orders :

Deprecated: PDO::quote(): Passing null to parameter #1 ($string) of type string is deprecated in /home/nacgym/www/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php on line 736

Deprecated: PDO::quote(): Passing null to parameter #1 ($string) of type string is deprecated in /home/nacgym/www/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php on line 736

Deprecated: PDO::quote(): Passing null to parameter #1 ($string) of type string is deprecated in /home/nacgym/www/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php on line 736
Votre commande est maintenant achevée.

Any idea ?

Please Log in or Create an account to join the conversation.

  • Posts: 82683
  • Thank you received: 13337
  • MODERATOR
1 month 1 week ago #363386

Hi,

That's hard to say.
The error message only points to the file of Joomla processing the MySQL query, not to the location where the MySQL query is.

There are 2 things you can do:
- You could turn off the "error reporting" setting of the joomla configuration, in order to hide the messages. This should be done on live websites anyway for security reasons.
- You could modify the code in /libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php to output more information using the debug_print_backtrace PHP function:
www.php.net/manual/en/function.debug-print-backtrace.php
That way, we can get more information on where the problematic MySQL query is located and we'll be able to tell you what to do to fix the problem.

Please Log in or Create an account to join the conversation.

  • Posts: 4
  • Thank you received: 0
1 month 1 week ago #363400

Thank you Nicolas,

As I not an expert, I am not able to modify the php code.
turning off the debug mode will be enought for now.

Please Log in or Create an account to join the conversation.

Time to create page: 0.040 seconds
Powered by Kunena Forum