eapdb LiteCart Fan Da Taiwan Membro dal gen 2022 eapdb 16 apr 2022 12:16 I update litecart and got the message Undefined constant MYSQLI_OPT_INT_AND_FLOAT_NATIVE in ~/includes/library/lib_database.inc.php on line 23 What can i do?
tim Founder Da Sweden Membro dal mag 2013 tim 16 apr 2022 14:14 See this thread https://www.litecart.net/en/forums/15/errors-and-troubleshooting/16698/mysqli-constant-mysqli-opt-int-and-float-native-is-undefined
user10251 LiteCart Fan Da Australia Membro dal ago 2022 user10251 30 ago 2022 15:51 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 30 ago 2022 16:34 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.
user10251 LiteCart Fan Da Australia Membro dal ago 2022 user10251 30 ago 2022 16:40 all fixed, thank you Sir!
tim Founder Da Sweden Membro dal mag 2013 tim 30 ago 2022 17:07 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.
user10251 LiteCart Fan Da Australia Membro dal ago 2022 user10251 30 ago 2022 17:08 i am now version 7.4 after the update, will this be okay?
tim Founder Da Sweden Membro dal mag 2013 tim 30 ago 2022 22:59 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.