Post by charliewhyman » Tue Aug 27, 2013 7:03 pm

Hi - please can someone help me? I am trying to install OpenCart for the first time and downloaded the latest version last Friday.

My collegue has set me up an SQL Database and i have followed all of the steps on the installation guide. the problem is that when i enter my SQL details i am told that it can't connect to the database. I am assured that all of my details are correct and there are no issues wiht the user name or password or anything.
OpenCart Error.PNG

Error Message - OpenCart Error.PNG (45.78 KiB) Viewed 2709 times

Does open Cart work with My SQL 5? i only have one option when selecting the Database Driver and that is just MySQL.

Help?

Thanks
Charlie

Newbie

Posts

Joined
Tue Aug 27, 2013 6:59 pm

Post by mrwell » Wed Aug 28, 2013 10:42 pm

I am having the same problems. It only works if you enter your cpanel log in details.

New member

Posts

Joined
Wed Jun 29, 2011 6:16 am

Post by charliewhyman » Wed Aug 28, 2013 10:47 pm

Hi - what are cpanel login details?

Thanks
Charlie

Newbie

Posts

Joined
Tue Aug 27, 2013 6:59 pm

Post by ogun » Wed Aug 28, 2013 11:49 pm

Copy and paste this into notepad:

Code: Select all

<?php
$mysqli_connection = new MySQLi('localhost', 'user', 'pass', 'db');
if ($mysqli_connection->connect_error) {
   echo "Not connected, error: " . $mysqli_connection->connect_error;
}
else {
   echo "Connected.";
}
Edit it to replace the parameters for the connection with your real connection details and save it as test.php.

Upload that to your server and visit the page - if it produces an error instead of saying "Connected", show the error to your friend or post back here.

Active Member

Posts

Joined
Tue Aug 14, 2007 6:04 am

Post by charliewhyman » Thu Aug 29, 2013 12:03 am

It just says page not found. Have i done something wrong here :(

Newbie

Posts

Joined
Tue Aug 27, 2013 6:59 pm

Post by ogun » Thu Aug 29, 2013 12:20 am

Assuming you're looking at the address you uploaded the file to, you're doing the right thing.

It may be being affected by a htaccess file (although that seems unlikely given that you've only just started)?
Try putting test.php in its own folder at the same level or above the opencart folder.

Is the 'page not found' message within OpenCart or is it coming from apache/iis?

Active Member

Posts

Joined
Tue Aug 14, 2007 6:04 am

Post by mrwell » Thu Aug 29, 2013 12:34 am

I had to change "localhost" to "127.0.0.1" for it to work. No problems now.

New member

Posts

Joined
Wed Jun 29, 2011 6:16 am

Post by makfor49 » Tue Oct 08, 2013 10:07 pm

hello , i have a same problem , but i am not sure what "error" is ,so i put it here in SQL Database Error

i use Mac and MAMP

when i install the opencart as localhost , all working fine , but when i try to access my opencart from other pc in my network the shop not working properly , so i think to make a new install from my "client" pc

my mac have 192.168.1.94 , so from my client i give the 192.168.1.94:8888 i connect to opencart install , and in the step_3 , when i give the database name , user/pass , i receive error that i have error "could not connect to the database ...."

i use as database host the 192.168.1.94
i have create the database myeshop .. i give the right user/pass ... BUT nothing ..

i try phpmyadmin from my client and work perfect (i create table , i put data ... all work) ...

as anyone know what can i do ?

thank you

Newbie

Posts

Joined
Tue Oct 08, 2013 9:44 pm

Post by ogun » Thu Oct 10, 2013 4:40 pm

Try the solution from the previous post (writing the address in step 3 as localhost or 127.0.0.1 rather than 192.168.1.94).

Active Member

Posts

Joined
Tue Aug 14, 2007 6:04 am
Who is online

Users browsing this forum: No registered users and 30 guests