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
Not able to connect to the phpmyadmin database
Re: Not able to connect to the phpmyadmin database
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
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
- paulbaker
- 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
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
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
https://docs.cmsmadesimple.org/troubles ... nformation
CMS Made Simple Geekmoots attended:
Nottingham, UK 2012 | Ghent, Belgium 2015 | Leicester, UK 2016
Re: Not able to connect to the phpmyadmin database
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.
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.
- paulbaker
- 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
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...
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
https://docs.cmsmadesimple.org/troubles ... nformation
CMS Made Simple Geekmoots attended:
Nottingham, UK 2012 | Ghent, Belgium 2015 | Leicester, UK 2016
Re: Not able to connect to the phpmyadmin database
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.
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.