Hi.
I have been using my forum for about a month now, and smf is great. But I think Ive dropped a clanger.
I cannot go to my forum. Get this error message: "Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later. "
My database is still there, and my server is fine.
I am using 1.1.13 default template.
I think I may know the error, but not sure how to correct.
I deleted a database user by mistake. This may have been the smf default as it was something like donnaand_smf
I still have another user with all priveleges, but have I deleted the important one? :(
Any help appreciated.
Chris
if that is the database for your forum and you have no backup, your best option is to ask your host if they can restore it, otherwise you are out of luck.
scorpio66uk, as long as your database is in tact on the server, it doesn't matter is there are one or two or no database users linked to that database. You can always edit the current database user to modify its privileges to give it all access. Or just add a new db user with all permissions.
The upload the repair_settings.php file to your forum directory via FTP. I personally recommend FileZilla, as it's the best free FTP manager.
Then just visit the address to that repair file and you can then check all the database name and password details. That should fix your forum. If it doesn't, then it is definitely a server problem/overload. In that case, you must ask your hosting support for help. BTW, what host are you using?
Usually, if you only remove a DB user - you can add a new one quite easily, but how to do it exactly depends on your hosting, so if the DB is still there - perhaps ask your host about creating a new user for it.
Then you can use repair_settings.php to change the DB username and password that SMF uses.
EDIT: Ninja'd :P
Thanks guys for your prompt responses! Wow!
I have corrected the problem
I copied my settings.php file fromFilezilla to my desktop.
The I opened it to find the 'database info' section, and there was the user info and password I needed.
I readded the user details as a new user in the database, changed the passwords in the database and settings.php then uploaded back up through Filezilla.
All is well once more.
Couldnt have done it without the tips on here though.
Many thanks. Have a great day. :D
RESOLVED
Chris
Glad you got it fixed :)