Not able to connect to the phpmyadmin database

For questions and problems with the CMS core. This board is NOT for any 3rd party modules, addons, PHP scripts or anything NOT distributed with the CMS made simple package itself.
Post Reply
ArneDB
Forum Members
Forum Members
Posts: 13
Joined: Mon Jan 15, 2018 12:43 pm

Not able to connect to the phpmyadmin database

Post by ArneDB »

Dear community,

I am a front-end "developer", and for a customer I have to debug a very old website.
There's something wrong with the FrontEndUsers (FEU) module, in which it keeps saying "Invalid User"

And for this reason I'm trying to run his site locally so I can do some testing before I get on the real thing.

Now I copied all his root files and his database en put them in a XAMPP environment.

When I try to go to the website I get the following error:
https://i.gyazo.com/e043486759f07edfddd ... fd7b43.png

So I checked the config.php file and made some changes. Now I'm not really sure everything checks out here.
Here's my file:
https://i.gyazo.com/658fa7cedb76a3781c9 ... f736fc.png

I already tried changing the db_port to 3306 (which is for XAMPP)

Also I remember from my WordPress experience that you had to make some changes in .htaccess to make it go to the right folder. Is this also the case for CMSMS, if yes, how so?

Kind Regards
ArneDB
Forum Members
Forum Members
Posts: 13
Joined: Mon Jan 15, 2018 12:43 pm

Re: Not able to connect to the phpmyadmin database

Post by ArneDB »

UPDATE:

In config.php when I change this line

$config['dbms'] = 'mysql';
to
$config['dbms'] = 'mysqli';

mysql -> mysqli

I get the following error:
https://i.gyazo.com/a0a15b319f24c0b9d3c ... 5c1f2c.png

I'm not sure if this is valuable information.
I use XAMPP version 7.0.21
User avatar
paulbaker
Dev Team Member
Dev Team Member
Posts: 1465
Joined: Sat Apr 18, 2009 10:09 pm
Location: Maidenhead, UK
Contact:

Re: Not able to connect to the phpmyadmin database

Post by paulbaker »

My first guess would be a PHP version issue. Looks like an old version of CMSMS (what version is it?) and a very new version of PHP on your local system (7?) Try to lower your PHP version temporarily to move on...?

When you are past the errors you will need to upgrade:
https://docs.cmsmadesimple.org/upgradin ... nformation
https://docs.cmsmadesimple.org/upgrading/old-versions
To copy System Information to the forum:
https://docs.cmsmadesimple.org/troubles ... nformation

CMS Made Simple Geekmoots attended:
Nottingham, UK 2012 | Ghent, Belgium 2015 | Leicester, UK 2016
ArneDB
Forum Members
Forum Members
Posts: 13
Joined: Mon Jan 15, 2018 12:43 pm

Re: Not able to connect to the phpmyadmin database

Post by ArneDB »

The shared server where the website is hosted was running on PHP version 5.6.

I tried lowering it to 5.3, because I read that on these forums somewhere, but without succes.

The version of CMSMS that is running is 1.10.3

When updating this, what kind of things should we be aware of.
One thing I do know is to make a backup.
User avatar
paulbaker
Dev Team Member
Dev Team Member
Posts: 1465
Joined: Sat Apr 18, 2009 10:09 pm
Location: Maidenhead, UK
Contact:

Re: Not able to connect to the phpmyadmin database

Post by paulbaker »

You should not need anything special in your htaccess. I see from the config file that pretty URLs (url_rewriting) is not set, so that is fine.

Leave the shared server on 5.6 for now.

You don't say what version your local PHP is. Try to reduce it to 5.6 if possible just to get going without error.

Then increase it as you upgrade on your local system. If you take backups at each stage you will always be able to go back just one step if it goes wrong. Upgrade one major version at a time, as the link I posted explains. From 1.10.3 it isn't too bad.

Also are you absolutely certain you have entered the correct local db name, username & password in your local config file?

Someone else might come in with a more specific idea about your error messages...
To copy System Information to the forum:
https://docs.cmsmadesimple.org/troubles ... nformation

CMS Made Simple Geekmoots attended:
Nottingham, UK 2012 | Ghent, Belgium 2015 | Leicester, UK 2016
ArneDB
Forum Members
Forum Members
Posts: 13
Joined: Mon Jan 15, 2018 12:43 pm

Re: Not able to connect to the phpmyadmin database

Post by ArneDB »

Dear,

I use XAMPP Version 7.0.21, so I think that's the PHP version?

I tried running it on XAMPP 5.6.33, there it did make a DB connection (that's how I know my credentials are correct). But I encoutered another error which I can't reproduce atm.

I guess I'll read through the two links you posted and try to upgrade CMSMS & the Front End Users module on the shared server.
Post Reply

Return to “CMSMS Core”