Page 1 of 1

database opencart issue

Posted: Tue Aug 04, 2015 3:34 am
by ianhaney
Hi

I need some help please

I have installed opencart 1.5.6.4 into a folder call shop on a customers domain http://www.upyerpole.co.uk but it don’t seem to be connecting to the database as the admin side keeps saying no match for username and or password when is clearly there in the database and the main site for the shop just displays the links etc. but should display the demo products etc.

If I go directly into the database in phpmyadmin, all the opencart tables are there as well as the demo products and admin login info

All the permissions are correct and the two config files are correct and it installed all successfully and did not show any errors during the installation process so am lost with it?

Can anyone help or have any ideas, I have asked the hosting company if they know any reason as well but waiting for a reply from them but has been quite a while now

Kind regards

Ian

Re: database opencart issue

Posted: Tue Aug 04, 2015 5:35 am
by chulcha
check config.php root of store

.../shop/config.php
See section
//DB

Re: database opencart issue

Posted: Tue Aug 04, 2015 4:22 pm
by ianhaney
Hi Chulcha

I checked that config file as well as the admin one and both are the correct details

I installed opencart 1.5.6.4 on wamp and works perfect so wonder if is a host issue?

Re: database opencart issue

Posted: Tue Aug 04, 2015 6:37 pm
by chulcha
But you are running adminpanel
You do not work frontend

If you give access to FTP, I can see (PM)

Re: database opencart issue

Posted: Tue Aug 04, 2015 6:54 pm
by ianhaney
oh right ok

I'll PM you the FTP info

Re: database opencart issue

Posted: Tue Aug 04, 2015 6:58 pm
by ianhaney
Just sent a PM Chulcha

Hopefully has came through or will do shortly

Re: database opencart issue

Posted: Tue Aug 04, 2015 7:32 pm
by chulcha
All right.

I changed the sql driver from mysqli to mysql

Re: database opencart issue

Posted: Tue Aug 04, 2015 7:47 pm
by ianhaney
Hi

Ahh yeah just see you changed it to mysql instead of mysqli

Isn't mysql not as secure as mysqli though or is it ok just for sql driver