Undefined constant MYSQLI_OPT_INT_AND_FLOAT_NATIVE

LiteCart Fan
Da Australia
Membro dal ago 2022

hi, sorry im newbie, my hosting company is running PHP v 7.3.33 and i am also getting error message Warning: 

Undefined constant MYSQLI_OPT_INT_AND_FLOAT_NATIVE in ~/includes/library/lib_database.inc.php (Line 23)

Is there any way i can fix in my Cpanel?  any help would be appreciated thanks

Should i go into this file lib_database.inc.php  and delete the line highlighted in my photo attached?

tim
Founder
Da Sweden
Membro dal mag 2013
tim

Hello newbie, this is due to the use of an old incompatible mysql driver in PHP.

Go to cPanel -> Select PHP version

Uncheck the old mysqli.
Check the new nd_mysqli along with mysqlnd.

LiteCart Fan
Da Australia
Membro dal ago 2022

all fixed, thank you Sir!

tim
Founder
Da Sweden
Membro dal mag 2013
tim

Do note PHP 7.3 will reach end of life this Q4. You can go with PHP 8.1 if you like. Or pick 8.0 if you are unsure about addons not being fully compatible.

LiteCart Fan
Da Australia
Membro dal ago 2022

i am now version 7.4 after the update, will this be okay?

tim
Founder
Da Sweden
Membro dal mag 2013
tim

Oh my bad, 7.3 is end of life already.
7.4 reaches end of life in 2022 Q3.
https://www.php.net/supported-versions.php
But yeah 7.4 will do until then. End of life means no more security updates.

Questo thread è stato chiuso per lunga inattività. Non è possibile postare su di esso.
This website uses no cookies and no third party tracking technology. We think we can do better than others and really think about your privacy.