Advertisement:

Author Topic: Connection error (SMF 2.4)  (Read 8304 times)

Offline dimalaoshi

  • Semi-Newbie
  • *
  • Posts: 14
    • Ask Dimalaoshi® - Your right (and left) hand in China
Connection error (SMF 2.4)
« on: October 11, 2008, 03:56:39 AM »
I keep receiving this error:
There has been a problem with the database!

This is a notice email to let you know that SMF could not connect to the database, contact your host if this continues.

According to http://dimalaoshi.com/database.php [nofollow] there is no problem. My host is telling me that I should double check my script:
"Inform your website developer to double check the "connection script" to
your websites database, since it's giving you the error message about database"


Please advise. Thanks in advance.

Offline DirtRider

  • SMF Hero
  • ******
  • Posts: 1,415
  • Gender: Male
  • Just Looking
    • TriumphTalk
Re: Connection error (SMF 2.4)
« Reply #1 on: October 11, 2008, 04:13:59 AM »
Ok firstly you have posted this topic twice. ;D Now are you able to access the site or is this also giving you the database error. If you are able to access your site and it seems to be working correctly it could be that SMF software is losing connection with the database even for a second and it would send you the mail. I would also suggest that you post a link to your forum here             
http://www.triumphtalk.com

"The real question is not whether machines think but whether men do. "

Offline dimalaoshi

  • Semi-Newbie
  • *
  • Posts: 14
    • Ask Dimalaoshi® - Your right (and left) hand in China
Re: Connection error (SMF 2.4)
« Reply #2 on: October 11, 2008, 10:38:31 AM »
Sorry, I posted twice by accident. I am also not able to access the site when i get the error (screenshot attached). i get this error almost on a daily basis, each time the outage lasts for about 5 min. My forum link is http://dimalaoshi.com [nofollow]
I was also suggested to use settings_repair.php file to see if that can solve the problem. Thanks for your feedback and, once again, sorry for double posting.

Offline DirtRider

  • SMF Hero
  • ******
  • Posts: 1,415
  • Gender: Male
  • Just Looking
    • TriumphTalk
Re: Connection error (SMF 2.4)
« Reply #3 on: October 11, 2008, 10:57:23 AM »
Ok when this happens take a screen shot of it. Then login to your host Control Panel. Now in the control panel you should have a MySQL Administration option. Now enter this area and you should see your database with an edit next to it. Hit the edit. If you get a similar error take a screen shot of this. Now send both screen shots along to you host and tell them to fix the problem they have on the server.

I was getting the same thing and the same run around from my host until I did this. They have now sent it to high level support for further investigation. I was told to inform then immediately if it occurs and so far nothing has come up again.

Oh and don't worry about the double post it does not worry me  ;D
http://www.triumphtalk.com

"The real question is not whether machines think but whether men do. "

Offline DirtRider

  • SMF Hero
  • ******
  • Posts: 1,415
  • Gender: Male
  • Just Looking
    • TriumphTalk
Re: Connection error (SMF 2.4)
« Reply #4 on: October 11, 2008, 11:00:04 AM »
ROTFL Oh and by the way I have the same host as what you have  :o :D :D :D :D :D :D
http://www.triumphtalk.com

"The real question is not whether machines think but whether men do. "

Offline Adish - (F.L.A.M.E.R)

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,614
  • Gender: Male
  • I am a ninja!
    • adishpatel on Facebook
    • https://www.linkedin.com/in/adishpatel on LinkedIn
Re: Connection error (SMF 2.4)
« Reply #5 on: October 11, 2008, 11:04:42 AM »

Offline dimalaoshi

  • Semi-Newbie
  • *
  • Posts: 14
    • Ask Dimalaoshi® - Your right (and left) hand in China
Re: Connection error (SMF 2.4)
« Reply #6 on: October 12, 2008, 05:53:54 AM »
Thanks for your help, really appreciate it.

Offline DirtRider

  • SMF Hero
  • ******
  • Posts: 1,415
  • Gender: Male
  • Just Looking
    • TriumphTalk
Re: Connection error (SMF 2.4)
« Reply #7 on: October 12, 2008, 06:16:07 AM »
Well lets hope the host fixes your problem I have not had it happen again this week
http://www.triumphtalk.com

"The real question is not whether machines think but whether men do. "

Offline Adish - (F.L.A.M.E.R)

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,614
  • Gender: Male
  • I am a ninja!
    • adishpatel on Facebook
    • https://www.linkedin.com/in/adishpatel on LinkedIn
Re: Connection error (SMF 2.4)
« Reply #8 on: October 12, 2008, 06:28:11 AM »
I love those image icons...



Awsome one !!

Offline dimalaoshi

  • Semi-Newbie
  • *
  • Posts: 14
    • Ask Dimalaoshi® - Your right (and left) hand in China
Re: Connection error (SMF 2.4)
« Reply #9 on: October 13, 2008, 04:31:56 AM »
To: DirtRider

I did exactly what you suggested. Take a look at the screenshots attached. We'll see what 1and1's customer service have to say. The problem is getting worse, btw.

Offline DirtRider

  • SMF Hero
  • ******
  • Posts: 1,415
  • Gender: Male
  • Just Looking
    • TriumphTalk
Re: Connection error (SMF 2.4)
« Reply #10 on: October 13, 2008, 04:48:10 AM »
That is the exact same story I had. I must admit since I really complained to them by attaching all the mails sent to me by SMF when this occurred plus all my previous correspondence to then and I was then quite insistent that they should sort it out. I have not had the error occur again.
http://www.triumphtalk.com

"The real question is not whether machines think but whether men do. "

Offline dimalaoshi

  • Semi-Newbie
  • *
  • Posts: 14
    • Ask Dimalaoshi® - Your right (and left) hand in China
Re: Connection error (SMF 2.4)
« Reply #11 on: October 13, 2008, 06:27:39 AM »
this is the response I just got:
----------------
Thank you for contacting us.

The issue we had recently with our database  has been resolved by our
administrators.
Your website should be up and running without any issues now.

We sincerely apologize for the inconvenience this has caused, and assure
you, we will take steps to
prevent this type of outage in the future.

Your patience is highly appreciated on this matter.

If you have any further questions please do not hesitate to contact us.
-----------------


We'll see what happens :)

Offline DirtRider

  • SMF Hero
  • ******
  • Posts: 1,415
  • Gender: Male
  • Just Looking
    • TriumphTalk
Re: Connection error (SMF 2.4)
« Reply #12 on: October 13, 2008, 06:35:16 AM »
Yip that is the standard one they will send you every time you report it. If they actually looked at the problem I cannot tell you. Now save each and every one of these along with the mail SMF should be sending you. Now next time attached the whole lot and send it off to them telling them to fix the server as you have now reported this numerous time with no results. It seems this is a common problem with 1&1 as I have seen it reported here a few times by different members     
http://www.triumphtalk.com

"The real question is not whether machines think but whether men do. "

Offline dimalaoshi

  • Semi-Newbie
  • *
  • Posts: 14
    • Ask Dimalaoshi® - Your right (and left) hand in China
Re: Connection error (SMF 2.4)
« Reply #13 on: October 13, 2008, 06:50:32 AM »
I've saved everything, they should be able to see the whole thread of our correspondence along with the screenshots. If they can't handle it, then I'll move to greener pastures.

Offline DirtRider

  • SMF Hero
  • ******
  • Posts: 1,415
  • Gender: Male
  • Just Looking
    • TriumphTalk
Re: Connection error (SMF 2.4)
« Reply #14 on: October 13, 2008, 07:01:48 AM »
Except for this problem I am quite happy with the service so far but I have only been with them a few months.
http://www.triumphtalk.com

"The real question is not whether machines think but whether men do. "

Offline dimalaoshi

  • Semi-Newbie
  • *
  • Posts: 14
    • Ask Dimalaoshi® - Your right (and left) hand in China
Re: Connection error (SMF 2.4)
« Reply #15 on: October 14, 2008, 09:37:32 PM »
Well, I've encountered connection problem again. Looks like you were right, they just sent out standard email without even trying to resolve this issue

Offline DirtRider

  • SMF Hero
  • ******
  • Posts: 1,415
  • Gender: Male
  • Just Looking
    • TriumphTalk
Re: Connection error (SMF 2.4)
« Reply #16 on: October 15, 2008, 01:25:22 AM »
Yeah I also had it again yesterday   :(
http://www.triumphtalk.com

"The real question is not whether machines think but whether men do. "

Offline dimalaoshi

  • Semi-Newbie
  • *
  • Posts: 14
    • Ask Dimalaoshi® - Your right (and left) hand in China
Re: Connection error (SMF 2.4)
« Reply #17 on: October 15, 2008, 03:35:16 AM »
Perhaps we could submit a  "class action tech support complaint” ?  :)

Offline DirtRider

  • SMF Hero
  • ******
  • Posts: 1,415
  • Gender: Male
  • Just Looking
    • TriumphTalk
Re: Connection error (SMF 2.4)
« Reply #18 on: October 15, 2008, 05:05:46 AM »
I wonder how many other here are with them and having the same problem. So far I did not even get the standard reply from them  :P :D   
http://www.triumphtalk.com

"The real question is not whether machines think but whether men do. "

Offline dimalaoshi

  • Semi-Newbie
  • *
  • Posts: 14
    • Ask Dimalaoshi® - Your right (and left) hand in China
Re: Connection error (SMF 2.4)
« Reply #19 on: October 15, 2008, 05:18:26 AM »
check this out:
"Thank you for contacting us.

Thank you for the email and for beariing with us.
It is my priviledge to help you and offer you assistance with regard to
your concern the problem with your database is that there is a limit on
concurrent MySQL server connections. The allowed connections is only 18
at the same time so when you exceed the allowed concurrent
connection(which is 18) you will encounter an error. I do apologize with
the problems you are experiencing right now.

If you have further doubts and concerns  call us back again our
Technical Support Department is available 24/7."


Offline fedup-really-fedup

  • Newbie
  • *
  • Posts: 2
Re: Connection error (SMF 2.4)
« Reply #20 on: October 15, 2008, 05:26:37 AM »
i AM HAVING THE PROBLEM WITH DB CONNECTION AS WELL, THE SAME PROBLEM. I THINK SOMETHING IS WRONG WITH SMF 2.0 BETA 4 (THE MOST SPECIAL VERSION WHICH DISAPPOINTED ME ALOT)

Offline Adish - (F.L.A.M.E.R)

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,614
  • Gender: Male
  • I am a ninja!
    • adishpatel on Facebook
    • https://www.linkedin.com/in/adishpatel on LinkedIn
Re: Connection error (SMF 2.4)
« Reply #21 on: October 15, 2008, 05:49:58 AM »
@ fedup-really-fedup

Check your settings in settings.php it is not a problem with SMF, it is mainly with MySQL, you cant do anything with that ! if your information is correct then it is the host which has the problems.

Offline DirtRider

  • SMF Hero
  • ******
  • Posts: 1,415
  • Gender: Male
  • Just Looking
    • TriumphTalk
Re: Connection error (SMF 2.4)
« Reply #22 on: October 15, 2008, 06:09:40 AM »
check this out:

Funny they don't seem to tell you this before you sign up. Also the story of your database only being up to 100 megs. I have looked at other hosting but they seem to be rather small in what they give you. I would hate to change over and only find out later that I don't have enough disk space or bandwidth for my forum. I have tried to get stats from other members here on what there forum is using but never really got much. To change over I need to know that the hosting will serve my purposes without having to change again. 

What hosting package have you got with them, I am on the "Home package"
« Last Edit: October 15, 2008, 06:27:23 AM by DirtRider »
http://www.triumphtalk.com

"The real question is not whether machines think but whether men do. "

Offline CarlT100

  • Semi-Newbie
  • *
  • Posts: 54
  • Gender: Male
    • Triumph Talk
Re: Connection error (SMF 2.4)
« Reply #23 on: October 15, 2008, 08:40:59 AM »
Dirtrider, this occurred again yesterday (Sunday) to our forum.  I was not on line; but I received the email notification.  Usually, the site becomes slow prior to being unable to connect.
CarlT100


Offline DirtRider

  • SMF Hero
  • ******
  • Posts: 1,415
  • Gender: Male
  • Just Looking
    • TriumphTalk
Re: Connection error (SMF 2.4)
« Reply #24 on: October 15, 2008, 08:56:06 AM »
Yes I also go the mail and sent it off to them as they requested. Never got a reply from them about it.   
http://www.triumphtalk.com

"The real question is not whether machines think but whether men do. "

Offline dimalaoshi

  • Semi-Newbie
  • *
  • Posts: 14
    • Ask Dimalaoshi® - Your right (and left) hand in China
Re: Connection error (SMF 2.4)
« Reply #25 on: October 15, 2008, 10:00:27 AM »
this will probably shed some light on the problems some of us are experiencing:

 (this time I know it's not just a standard reply):

"Thank you for contacting us.

Thank you for the quick email reply.
Regarding your concern we can check your settings in our end using our
tools (SSH) you can also refer to this link
http://www.phpfreaks.com/forums/index.php?topic=218152.0 [nofollow]. This link is
also about MySQL error which have too many connections at the same time.
We also see this information using our tool
Question Is there a limit on concurrent MySQL server connections from a
Linux Shared package?

Answer Yes, there is a limit. Not more than 18 connections are allowed
at the same time.

This is what we got when we check in your MySQL settings.

mysql> SHOW VARIABLES;
and should see a long output like this:

| max_user_connections
18

| max_tmp_tables | 32
| transaction_alloc_block_size
|8192
|| transaction_prealloc_size |
4096
|| version |
4.0.25-standard-log
|| version_comment | Official MySQL
RPM
|
| version_compile_os |
pc-linux-gnu
|| wait_timeout | 3

If your site will grow then I advise that you buy a server package.
There is no way to lift this but really need to buy a server package to
maximize the number of concurrent connections that can go to your site
at the same time.

If you have any further questions please do not hesitate to contact us.

--
Sincerely,
Technical Support
1&1 Internet"

Offline CarlT100

  • Semi-Newbie
  • *
  • Posts: 54
  • Gender: Male
    • Triumph Talk
Re: Connection error (SMF 2.4)
« Reply #26 on: October 15, 2008, 10:10:49 AM »
Thank you for posting this.  I sent the link on to Dirtrider since he is our forum owner.  I have noticed the problem occurs in our forum during the peak hours of North American usage. I am not sure what a server package is; but Dirtrider will know.
CarlT100


Offline DirtRider

  • SMF Hero
  • ******
  • Posts: 1,415
  • Gender: Male
  • Just Looking
    • TriumphTalk
Re: Connection error (SMF 2.4)
« Reply #27 on: October 15, 2008, 10:13:11 AM »
I have just tried to log onto 1&1 web site and I get this  :P

Service Temporarily Unavailable

The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
http://www.triumphtalk.com

"The real question is not whether machines think but whether men do. "

Offline DirtRider

  • SMF Hero
  • ******
  • Posts: 1,415
  • Gender: Male
  • Just Looking
    • TriumphTalk
Re: Connection error (SMF 2.4)
« Reply #28 on: October 15, 2008, 10:16:23 AM »
I see the server package that they suggest starts off at  $29/month  :o There is no ways I could afford this for my forum  :(

Have a look at this http://webhostinggeeks.com/ I will be checking out a few of these for future reference
« Last Edit: October 15, 2008, 10:21:31 AM by DirtRider »
http://www.triumphtalk.com

"The real question is not whether machines think but whether men do. "

Offline CarlT100

  • Semi-Newbie
  • *
  • Posts: 54
  • Gender: Male
    • Triumph Talk
Re: Connection error (SMF 2.4)
« Reply #29 on: October 15, 2008, 10:25:26 AM »
I see the server package that they suggest starts off at  $29/month  :o There is no ways I could afford this for my forum  :(

Have a look at this http://webhostinggeeks.com/ I will be checking out a few of these for future reference

That is too steep for us.  It is time to start looking for a change.
CarlT100


Offline DirtRider

  • SMF Hero
  • ******
  • Posts: 1,415
  • Gender: Male
  • Just Looking
    • TriumphTalk
Re: Connection error (SMF 2.4)
« Reply #30 on: October 15, 2008, 11:19:20 AM »
Far too steep we are still to small to warren something like this  :o

 :P have a look at this http://www.webhostingreviews.com/1and1-reviews.htm
« Last Edit: October 15, 2008, 12:02:26 PM by DirtRider »
http://www.triumphtalk.com

"The real question is not whether machines think but whether men do. "