Love the prank theme, btw! When I was Googling my problem and stumbled across this, I thought the discussions were rather advanced for a Brony forum (wasn't looking at the URL)!
So first off, I did read some old topics. From what I gather, I have a version of Joomla (and to be honest, I am not familiar with that) that is not compatible with SMF 2.x, and thus I'm getting these messages:
QuoteConnection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.
Warning: Cannot modify header information - headers already sent by (output started at /home/site/public_html/Sources/Errors.php:415) in /home/site/public_html/Sources/Errors.php on line 346
Warning: Cannot modify header information - headers already sent by (output started at /home/site/public_html/Sources/Errors.php:415) in /home/site/public_html/Sources/Errors.php on line 347
Warning: Cannot modify header information - headers already sent by (output started at /home/site/public_html/Sources/Errors.php:415) in /home/site/public_html/Sources/Errors.php on line 348
Warning: Cannot modify header information - headers already sent by (output started at /home/site/public_html/Sources/Errors.php:415) in /home/site/public_html/Sources/Errors.php on line 351
Warning: Cannot modify header information - headers already sent by (output started at /home/site/public_html/Sources/Errors.php:415) in /home/site/public_html/Sources/Errors.php on line 352
Warning: Cannot modify header information - headers already sent by (output started at /home/site/public_html/Sources/Errors.php:415) in /home/site/public_html/Sources/Errors.php on line 353
Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.
This is the 346-353
// Don't cache this page!
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');
header('Cache-Control: no-cache');
// Send the right error codes.
header('HTTP/1.1 503 Service Temporarily Unavailable');
header('Status: 503 Service Temporarily Unavailable');
header('Retry-After: 3600');
Around 415
// What to do? Language files haven't and can't be loaded yet...
else
echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="robots" content="noindex" />
<title>Connection Problems</title>
</head>
<body>
<h3>Connection Problems</h3>
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.
</body>
</html>';
die;
Line 415 being the </html>'; bit
Is this a Joomla problem? If it is, then it's due to a mod. If so, how do I know which mod?
Thank you in advance!
hmmm....
smf version?
mods installed?
url?
SMF 2.0.4
Yes, I like my mods. :D
1. The Rules 1.1 [ Uninstall ] [ List Files ] [ Delete ]
2. Custom Report Mod 1.4 RC2 [ Uninstall ] [ List Files ] [ Delete ]
3. SMF 2.0.4 Update 1.0 [ Uninstall ] [ List Files ] [ Delete ]
4. Password Strength Meter 1.1 [ List Files ] [ Delete ]
5. Topic View Log 1.2 [ Uninstall ] [ List Files ] [ Delete ]
6. Hide User Names from Guests 1.1 [ Uninstall ] [ List Files ] [ Delete ]
7. Avatar Verification 1.5 [ Uninstall ] [ List Files ] [ Delete ]
8. PM to New Members 1.2 [ Uninstall ] [ List Files ] [ Delete ]
9. Colorized Membergroups 1.0 [ List Files ] [ Delete ]
10. Auto Embed Video Clips 2.1.5 [ Uninstall ] [ List Files ] [ Delete ]
11. Add Join Date to Post 1.0 [ Uninstall ] [ List Files ] [ Delete ]
12. Email Template Editor 1.0 [ List Files ] [ Delete ]
13. Copyright and Footer Links 3.2 [ Uninstall ] [ List Files ] [ Delete ]
14. Search User In MP 1.1 [ Uninstall ] [ List Files ] [ Delete ]
15. MetaTags Modification 2.0.2 [ Uninstall ] [ List Files ] [ Delete ]
16. Force Topic Read On Login Mod 2.1 [ Uninstall ] [ List Files ] [ Delete ]
17. Signature Area BBCode Buttons 2.0.1 [ List Files ] [ Delete ]
18. AJAX Recent Topics 1.0.0 [ List Files ] [ Delete ]
19. Send Pm When Rank Change 1.0 [ Uninstall ] [ List Files ] [ Delete ]
20. Member Color Link 3.0.6 [ List Files ] [ Delete ]
21. SimpleColorizer 1.1 [ Uninstall ] [ List Files ] [ Delete ]
22. SSI_Register_Function 1.0 [ Uninstall ] [ List Files ] [ Delete ]
23. Board Notification Mod 1.2.1 [ Uninstall ] [ List Files ] [ Delete ]
24. Poll Option in Post 1.0 [ List Files ] [ Delete ]
25. EmailFlash 2.0 [ List Files ] [ Delete ]
26. Default Avatar 1.1.1 [ Uninstall ] [ List Files ] [ Delete ]
27. Custom Report Mod 1.3 [ List Files ] [ Delete ]
28. WysiBB for SMF 0.5 [ Uninstall ] [ List Files ] [ Delete ]
29. Bookmarks 2.5 [ Uninstall ] [ List Files ] [ Delete ]
30. Posting_Announcement 2.0 [ Uninstall ] [ List Files ] [ Delete ]
31. Load Standard Language 1.0.2 [ List Files ] [ Delete ]
32. Logout pop up 0.1 [ List Files ] [ Delete ]
33. Avatar Verification 1.4.2 [ List Files ] [ Delete ]
34. Active Users Privacy 0.1 [ List Files ] [ Delete ]
URL, rather not give, no offense. It's just a very private board :) I can take a screen shot of the errors I get, though. I can tell you for sure that it's after a post is made or when I'm doing mod actions such as splitting, locking, or moving. Staff and regular members get the error. In all cases, the action such as posting or splitting always goes through, even if you get the error.
@Autumn
Apologies for intruding but you have two versions of the Custom Report mod and you have simplecolorizer and Member Color Link which do a similar job.
:)
Old Fossil, no apologies necessary! Thanks for pointing it out. I actually had a bunch of different mods, but when we upgraded to 2.0.2 I think it was, a lot of my mods were no longer compatible when we used the new default layout. It was not anticipated that we'd have a different layout, so I'm still cleaning things up.
Thanks again!
BTW
On one forum I owned I had 84 mods.
???
Wow, I don't feel so bad then!
Still looking for some help on this :)
QuoteSorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.
is your
ONLY error. The cascade of "headers already sent" errors is a consequence of this. Fix the database problem, and the others will disappear.
Can you access your database through phpMyAdmin? If not, rattle your host's cage -- the database server is down. If the database server is up, check your Settings.php file that it still has all the right database connection information.
Mr. Phil, yes I do have access to phpMyAdmin. I also ran SMF's repair settings. I clicked on all of the recommended paths, which some of them changed/updated. I thought that would fix it, but it didn't :\
If the database connection settings (database name, location, user ID, password) aren't right, I don't think repair_settings.php will get very far. If it didn't complain about being unable to connect, then the connection settings are probably OK. The other stuff changed by repair_settings would be irrelevant for this problem. So, if the database connection settings are OK, and you're getting errors that SMF can't connect to the database, there is something wrong elsewhere. Possibly you're trying to use a "persistent connection" that your host doesn't support, or your IP address has been blocked because you attempted to connect too many times over too short a period (your host read it as a DoS attack), or something else entirely. If you have a very cheap host (overseller), their server may simply be overloaded. Are you still able to connect from time to time, or is this constant for you and all your members? (fails every single time)
My host is a personal friend, but can be hard to get a hold of, so I do as much as I can on my own (and learn a lot in the process).
Yes, we are able to connect from time to time. It is not a constant error, but it is frequent.
If you can connect from time to time, your settings are correct. Your host, as dear a friend as they may be, has some work to do to provide reliable hosting. I shudder at the thought that it's some guy running a *AMPP server out of his bedroom PC -- not so much as the lack of capacity and redundancy, as the probable fact that it's probably poorly secured.
He runs an actual business web hosting. I can see how the term "friend" implies someone running it from their bedroom, but no need to make assumptions :)
I appreciate your input on possible problems, though.
Quote from: Autumn13 on April 06, 2013, 12:56:50 PM
He runs an actual business web hosting. I can see how the term "friend" implies someone running it from their bedroom, but no need to make assumptions :)
I appreciate your input on possible problems, though.
Has your topic been resolved? We would like to mark it as such. Hopefully you have spoken with your provider.
My issue is still not resolved. If I ever do get it resolved, I will come back and update this.
You can mark it solved if you'd like.
A note to anyone who comes to this thread looking for help: I guess this is something you can't fix on your own and will have to talk to whoever is hosting your site.
since yesterday until now at 2:15am I have gotten the can not connect to database error about 12 times. I also have the header errors in an error log for one of our forums on the vps.
I did just now sent a work ticket to hostgator to let them know that it is more than likely NOT a hiccup in the web but something going wrong with the vps. I also rebooted the server, just in case that would help but we can still connect to our sties--all of them.
database is correct/ optimized/repaired and backed up just in case.