Hi everyone,
I migrated my cpanel from an old host i had to a new VPS that i have been using for my other carts.
Anyway i used the cPanel migration and everything has come across fine including databases, files and email accounts.
But when i go to my sites URL i get the following
Fatal error[color=#000000][font=Times][size=1]: Class 'mysqli' not found in [/size][/font][/color]/home/banot/public_html/core/db/mysqli.php[color=#000000][font=Times][size=1] on line [/size][/font][/color]25
[size=4]Looks like you do not have mysqli extension for PHP installed or configured on your new server. You can test this
by creating a test.php file with the following and then calling it in your browser.
if(![/size][size=4]function_exists[/size]size=4[/size][size=4]&&[/size][size=4]![/size][size=4]extension_loaded[/size]size=4)[/size][size=4]{[/size]
[size=4] echo 'No mysqli Installed';[/size]
[size=4]}else{[/size]
[size=4] echo 'Installed';[/size]
[size=4]}[/size]
[font=Consolas, Menlo, Monaco,][size=4]You can get the site online by editing config.local.php and changing the [/size][/font]
[font=Consolas, Menlo, Monaco,][size=4]$config['db_type'] = 'mysqli'; [/size][/font]
[font=Consolas, Menlo, Monaco,][size=4]to [/size][/font]
[font=Consolas, Menlo, Monaco,][size=4]$config['db_type'] = 'mysql'; [/size][/font]
[font=Consolas, Menlo, Monaco,][size=4]and then saving but this is not secure.[/size][/font]
If using CS-Cart 4, it's
$config['database_backend'] = 'mysqli';
to
$config['database_backend'] = 'mysql';
I went onto the WHM and installed the mysqli which then told me that php 5.4 was too new so i changed back to php 5.3x and now get the following. Any Ideas?
Warning[color=#000000][font=Times][size=1]: mysqli::mysqli() [[/size][/font][/color]mysqli.mysqli[color=#000000][font=Times][size=1]]: (28000/1045): Access denied for user 'vvz2p73o_admin'@'localhost' (using password: YES) in [/size][/font][/color]/home/banot/public_html/core/db/mysqli.php[color=#000000][font=Times][size=1] on line[/size][/font][/color]53
Warning[color=#000000][font=Times][size=1]: mysqli_query() [[/size][/font][/color]function.mysqli-query[color=#000000][font=Times][size=1]]: Couldn't fetch cmysqli in [/size][/font][/color]/home/banot/public_html/core/db/mysqli.php[color=#000000][font=Times][size=1] on line [/size][/font][/color]85
Warning[color=#000000][font=Times][size=1]: mysqli_errno() [[/size][/font][/color]function.mysqli-errno[color=#000000][font=Times][size=1]]: Couldn't fetch cmysqli in [/size][/font][/color]/home/banot/public_html/core/db/mysqli.php[color=#000000][font=Times][size=1] on line [/size][/font][/color]155
Warning[color=#000000][font=Times][size=1]: mysqli_errno() [[/size][/font][/color]function.mysqli-errno[color=#000000][font=Times][size=1]]: Couldn't fetch cmysqli in [/size][/font][/color]/home/banot/public_html/core/db/mysqli.php[color=#000000][font=Times][size=1] on line [/size][/font][/color]155
Warning[color=#000000][font=Times][size=1]: mysqli_error() [[/size][/font][/color]function.mysqli-error[color=#000000][font=Times][size=1]]: Couldn't fetch cmysqli in [/size][/font][/color]/home/banot/public_html/core/db/mysqli.php[color=#000000][font=Times][size=1] on line [/size][/font][/color]164
Warning[color=#000000][font=Times][size=1]: mysqli_insert_id() [[/size][/font][/color]function.mysqli-insert-id[color=#000000][font=Times][size=1]]: Couldn't fetch cmysqli in [/size][/font][/color]/home/banot/public_html/core/db/mysqli.php[color=#000000][font=Times][size=1] on line [/size][/font][/color]134
Warning[color=#000000][font=Times][size=1]: mysqli_errno() [[/size][/font][/color]function.mysqli-errno[color=#000000][font=Times][size=1]]: Couldn't fetch cmysqli in [/size][/font][/color]/home/banot/public_html/core/db/mysqli.php[color=#000000][font=Times][size=1] on line [/size][/font][/color]155[color=#000000][font=Times][size=1]
[font=Courier][size=3]Error_occurred[/size][/font][/size][/font][/color]
You only need PHP 5.3 or higher to run CS-Cart 4 at this point.
You are required to use either MYSQLi or PDO_MySQL with version 4 so you will need to contact your server administrator and ask them to recompile PHP 5.3 with MySQLi handler.
http://www.cs-cart.c…quirements.html