Hi everyone,
I am getting the following error every time I try to install CS Cart. I definitely created a MySQL database on the server using iPage’s MySQL Database Creator.
----
Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2002): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) in /hermes/bosweb/web126/b1262/ipg.sdservicescentralcom/cscart/core/db/mysqli.php on line 44
Warning: mysqli_query() [function.mysqli-query]: Couldn’t fetch cmysqli in /hermes/bosweb/web126/b1262/ipg.sdservicescentralcom/cscart/core/db/mysqli.php on line 71
Warning: mysqli_errno() [function.mysqli-errno]: Couldn’t fetch cmysqli in /hermes/bosweb/web126/b1262/ipg.sdservicescentralcom/cscart/core/db/mysqli.php on line 140
Warning: mysqli_errno() [function.mysqli-errno]: Couldn’t fetch cmysqli in /hermes/bosweb/web126/b1262/ipg.sdservicescentralcom/cscart/core/db/mysqli.php on line 140
Warning: mysqli_error() [function.mysqli-error]: Couldn’t fetch cmysqli in /hermes/bosweb/web126/b1262/ipg.sdservicescentralcom/cscart/core/db/mysqli.php on line 149
----
Please help!
Thanks for your help in advance.
You have a connection failure.
Given your first message above, I’d check things in this order:
Your database name is wrong. If you name it xyz, you might have to add a prefix based on your environment prefx_xyz (talk to your hosting provider).
Your credentials are bad. Wrong username or password. Might have a prefix of the user name too.
[quote name=‘tbirnseth’]You have a connection failure.
Given your first message above, I’d check things in this order:
Your database name is wrong. If you name it xyz, you might have to add a prefix based on your environment prefx_xyz (talk to your hosting provider).
Your credentials are bad. Wrong username or password. Might have a prefix of the user name too.[/QUOTE]
The database is fine,
Open confit.local.php and change the values of mysqli to mysql.
Your store is looking for the mysql improved extension that your server currently lacks. Either recompile apache/mysql with mysql improved or change the value as mentioned prior in config.local.php
[quote name=‘JesseLeeStringer’]The database is fine,
Open confit.local.php and change the values of mysqli to mysql.
Your store is looking for the mysql improved extension that your server currently lacks. Either recompile apache/mysql with mysql improved or change the value as mentioned prior in config.local.php[/QUOTE]
So apparently I can’t do it the normal way because iPage (my host) doesn’t allow remote connection to the databases.
But Note: I checked my config.local.php and it didn’t have “mysqli” written in it. there was only “mysql”
Thanks for your help.
Hello Credizian,
Please refer to the answer on this thread: [url]http://forum.cs-cart.com/showthread.php?t=25172[/url] Most probably, it will help you resolve the problem.
—
Anastasiya Kozlova
CS-Cart Support team