catsanova LiteCart Fan Fra Netherlands Medlem siden mai 2023 catsanova mai 23 2023 01:58 p.m. After install the next warning however mysqlnd is installed. Help is appreciated. Warning: Undefined constant MYSQLI_OPT_INT_AND_FLOAT_NATIVE. Make sure you enabled the PHP extension mysqlnd which is the recommended driver since PHP 5.4 instead of libmysql. in ~/includes/library/lib_database.inc.php (Line 23)
tim Founder Fra Sweden Medlem siden mai 2013 tim mai 23 2023 05:37 p.m. Can this help you maybe? https://www.litecart.net/en/forums/15/errors-and-troubleshooting/16698/mysqli-constant-mysqli-opt-int-and-float-native-is-undefined
catsanova LiteCart Fan Fra Netherlands Medlem siden mai 2023 catsanova mai 24 2023 08:32 a.m. No unfortunately, libmysql is not active. Running PHP 8.0
tim Founder Fra Sweden Medlem siden mai 2013 tim mai 24 2023 10:02 a.m. It is. Uncheck mysqli and check nd_mysqli.
catsanova LiteCart Fan Fra Netherlands Medlem siden mai 2023 catsanova mai 24 2023 11:14 a.m. Then it'll will not work for me, there's also a Wordpress installation on the same server, this needs mysqli. Will see to install Litecart elswhere. Thanks for your time.
tim Founder Fra Sweden Medlem siden mai 2013 tim mai 24 2023 02:28 p.m. nd_mysqli is mysqli compiled with the native driver. mysqli is the old mysqli that uses libxml that was deprecated soon 8 years ago. cPanel just had to name these confusingly. 😁
catsanova LiteCart Fan Fra Netherlands Medlem siden mai 2023 catsanova mai 24 2023 03:45 p.m. Well, what my experience is. If I de-activate mysqli, Wordpress isn't working anymore. Or should I change in WP the mysqli to nd-mysqli in setting? Will try, let's see...
tim Founder Fra Sweden Medlem siden mai 2013 tim mai 24 2023 05:15 p.m. I'm no wordpress specialist. But I find it odd if that they would still favour php extensions today that were replaced by better ones almost a decade ago.
catsanova LiteCart Fan Fra Netherlands Medlem siden mai 2023 catsanova mai 24 2023 06:38 p.m. I do agree, but how many site are still using deprecated PHP7? Safety often comes first, after trouble.
catsanova LiteCart Fan Fra Netherlands Medlem siden mai 2023 catsanova mai 24 2023 07:39 p.m. Well I was wrong, it works. Indeed, these are the correct settings. mysqli - off mysqlnd = on nd_mysqli = on