Post by ico88 » Sun Feb 28, 2010 2:45 pm

Hello all,
i'm using OpenCart v1.4
When i fill :

*Database Host:
*User:
Password:
*Database Name:

*Username:
*Password:
*E-Mail

on step 3 and press continue this error apears "Error: Could not connect to the database please make sure the database server, username and password is correct!"

How to correct this error ?

( I'm sorry for the bad english )

Newbie

Posts

Joined
Sun Feb 28, 2010 2:35 pm

Post by i2Paq » Sun Feb 28, 2010 7:01 pm

ico88 wrote:Hello all,

on step 3 and press continue this error apears "Error: Could not connect to the database please make sure the database server, username and password is correct!"

How to correct this error ?

( I'm sorry for the bad english )
You English looks OK to me ;)

The error you get is because the info you used is incorrect.
Maybe ask your hoster for the crorrect names and passwords.

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by jontorbs » Thu Mar 04, 2010 8:22 am

I am having the same problem and am wondering if it is something to do with the hosts as the info i am using is correct as far as I know - but it is simply not accepted.... what else would they have it as and how would I find that out!?

New member

Posts

Joined
Mon Feb 15, 2010 10:51 pm

Post by i2Paq » Thu Mar 04, 2010 4:20 pm

The only time you gets this is when the info you used is incorrect.
Have your hoster look at this.

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by Gerrit » Thu Mar 04, 2010 8:07 pm

Create a phpinfo page with the the following code:

Code: Select all

<?php 
  phpinfo();
?>
Save it as phpinfo.php, upload this and run it from your browser.
See if there is a MySQL division and if it is enabled.

If not then contact your provider.

For modelcars cars see my OC 3.0.2.0 shop: http://www.gbcars.nl/
For Wooden Toys see my 2.3.0.2 shop: https://www.dehoutentreinenwinkel.nl/


User avatar
Active Member

Posts

Joined
Fri Nov 27, 2009 9:06 pm

Post by jontorbs » Thu Mar 04, 2010 11:38 pm

Gerrit wrote:Create a phpinfo page with the the following code:

Code: Select all

<?php 
  phpinfo();
?>
Save it as phpinfo.php, upload this and run it from your browser.
See if there is a MySQL division and if it is enabled.

If not then contact your provider.
Ok random one here - when I ran that phpinfo file (just note I have cleared OC off the web host before I ran it but not uninstalled phpmyadmin) I get the following:


Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /home/fhlinux007/m/moonstoneyarns.co.uk/user/htdocs/phpinfo.php on line 8

Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /home/fhlinux007/m/moonstoneyarns.co.uk/user/htdocs/phpinfo.php on line 9

Warning: Unexpected character in input: ''' (ASCII=39) state=1 in /home/fhlinux007/m/moonstoneyarns.co.uk/user/htdocs/phpinfo.php on line 9

Parse error: syntax error, unexpected T_STRING in /home/fhlinux007/m/moonstoneyarns.co.uk/user/htdocs/phpinfo.php on line 9

Which is even more interesting given that the file is only 3 lines long!!!!!

New member

Posts

Joined
Mon Feb 15, 2010 10:51 pm

Post by i2Paq » Fri Mar 05, 2010 12:54 am

The file is called phpinfo.php right?

Created with an editor like pspad?

As it looks like the format of the file/characters used is incorrect.

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by jontorbs » Fri Mar 05, 2010 2:15 am

Top tip that! Worked fine after creating it in DW rather than the original Textedit,

Looks like the MySQL is installed but on a shared host... could that be something to do with it (whilst I have worked with SQl before this is my first time on php/mysql server) so have got the following info (only entries featuring mysql included here):

Ok I have gotten through most of my woes and imported the database successfully (at last!) but have come round again with Error: Could not connect to database ... aargh! and i thought that I was doing so well!

I have checked the two config files, phpmyadmin and the host interface and the password is the same throughout. When i run the fasthosts test script it connects ok, so no problems there.

The database is imported, populated and contains all of the localhost data, but I forgot to drop tables before doing it in my excitement.. could that be it?

New member

Posts

Joined
Mon Feb 15, 2010 10:51 pm

Post by jontorbs » Fri Mar 05, 2010 8:42 am

Sorted! Site is now up, running, modded template in place and ready to start content loading for testing! Phew! Only one day to spare!

Thanks once again for your help everyone!

New member

Posts

Joined
Mon Feb 15, 2010 10:51 pm

Post by i2Paq » Fri Mar 05, 2010 11:07 pm

jontorbs wrote:Sorted! Site is now up, running, modded template in place and ready to start content loading for testing! Phew! Only one day to spare!

Thanks once again for your help everyone!
Great news!

What did you do to solve it?

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by jontorbs » Thu Mar 25, 2010 12:47 am

Started again with fresh install, basically just played with it until it all seemed to work ok.. was some very odd intricacy of the hosting provider I think.. had to manually create the database using their admin site/interface and then had to do a clean install and restored from there and it seemed to work!

New member

Posts

Joined
Mon Feb 15, 2010 10:51 pm
Who is online

Users browsing this forum: Bing [Bot] and 7 guests