Stuck in Maintenance Mode

[JoMinx]

Hi Folks

I've been upgrading my forum of recent days and after installing ADK Portal, I got the dreaded white maintenance mode screen and no ability to log in.  I have followed the advice in this post:

http://www.simplemachines.org/community/index.php?topic=287318.0

and this one:

http://www.simplemachines.org/community/index.php?topic=262562.0

Changing my settings.php maintenance to 0 changes the error message to the "Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later." one

I've read in the posts above that this is common but I can't seem to find what to do now with this error.

Any help greatly appreciated. 
yours in newbie/idiot frustration

Jo

[Dzonny]

Hello there and welcome to smf community.

Are you sure that your database settings are correct? Please upload repair_settings.php file and see if there is something that isnt correct. What is repair_settings.php?

If settings if fine i would suggest to contact your host and see if there could be some problem with high load or something that can couse this database issue.

Regards.

[JoMinx]

Hey Dzonny

I just had a go at repair_settings and get this warning:

Some settings are not being shown because the MySQL connection information is incorrect.

And in Paths & URL's there is only
Forum URL
Forum Directory
Forum Sources

Obviously something amiss, but I am way too stoopid with php to figure it out.  *Blinks eyelashes and smiles nicely*  Any ideas?
regards
Jo

[Illori]

do you still have your settings_bac.php file? if so copy it and rename the copy settings.php and delete the old settings.php file.

[JoMinx]

I'm afraid I tried that but no luck.  Still get the white maintenance mode no log in screen.

[Illori]

does repair_settings.php still say that the database can not be connected to? can you find out the correct login information for the database and put it in the repair_settings.php file and save it?

[Dzonny]

Please run repair_settings.php again and see if there is still the same error:
"Some settings are not being shown because the MySQL connection information is incorrect. "
If not you should just edit settings.php and change value for mainteanance from 1 to 0 (line 27) and see if it helps.

However if there is error in repair_settings.php you should correct your information and try again.

Edit:
Illori, sorry about "inbreaks" these days

[JoMinx]

Hey Illori and Dzonny,

Thanks for the help guys.  I have managed to fix it.  For some reason my settings.php had the wrong password.  Instead of capitalisation of the first letter, it had dropped it to lowercase.  I've looked at it 100 times and not noticed.  Changed that, and voila - I have access again.

Once again thanks so much for helping out.  You guys rock

hugs
Jo