Help Please - Can't Get My Forum Site to Come Up

Started by mariafgp, March 29, 2009, 02:11:48 AM

Previous topic - Next topic

mariafgp

I was going to try to make some additions to the registration process so I logged out. I was signed in as administrator. When I went to get the forum to open up I got this error:

Database Error: Lost connection to MySQL server during query
File: /home/content/m/a/r/mariafgp1/html/datehookupforums/Sources/Security.php
Line: 279

This is the code for that error. Line 279 is the last AND line.


           $request = db_query("
                SELECT bi.ID_BAN, bi.email_address, bi.ID_MEMBER, bg.cannot_access, bg.cannot_register,
                    bg.cannot_post, bg.cannot_login, bg.reason
                FROM ({$db_prefix}ban_groups AS bg, {$db_prefix}ban_items AS bi)
                WHERE bg.ID_BAN_GROUP = bi.ID_BAN_GROUP
                    AND (bg.expire_time IS NULL OR bg.expire_time > " . time() . ")
                    AND (" . implode(' OR ', $ban_query) . ')', __FILE__, __LINE__);


I am using SMF 1.18, Vista OS and GoDaddy hosting. I did search the forums and found that it could be related to GoDaddy BUT I had 3 friends look at the link and were able to see the site. I even opened my laptop up and got in that way but as soon as I logged out got the same error on the laptop as well. I cleared the cache and cookies. Tried it on IE, Firefox and Netscape and still the same error message.

I called GoDaddy about it and they said it was a scripting error but if that were true then no one should be able to see it. Does anyone know how to create a mysql.ini file? One forum topic said "To resolve the problem you may need to increase the values of the MySQL wait_timeout and connect_timeout settings." I was going to try to add one to my hosting but I am sure that isn't the problem. Here is the site link.  http://www.datesiteforums.com/
If you you know how I can fix this please let me know. I don't know what else I can do short of finding new hosting and I am not ready to do that yet. The site isn't that active yet and I am not sure it is going to be. Thanks in advance for any help you can give me.

Tyrsson

PM at your own risk, some I answer, if they are interesting, some I ignore.

H

-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

mariafgp

Quote from: H on March 29, 2009, 07:07:00 AM
Please take a look at this :)

I did look at that and asked GoDaddy about it. They said they can't do anything to fix it and that I could add my own mysql.ini file but I haven't found an example of how to make one.

To Tyrsson: I know the site loads fine for other people. The problem is I can't get it to load for me. Any suggestions?

Something like that

Disable persistent connections if you have them enabled.

mariafgp

I ended up backing up my database and re-installing the forum. Fortunately SMF saw that my database was already populated. Logged out and it happened again. Re-installed and disabled hostname lookups and it is now working fine. Thanks for your suggestions. I think I will work on the 18 things to make it faster.

JimM

Is this issue solved or do you still require assistance?  What you are experiencing is actually not a problem with SMF.  Shared hosting can really have you going in so many directions trying to fix problems that you actually do not have control of.  Sometimes the last resort is to find a host that values quality before quantity.
Jim "JimM" Moore
Former Support Specialist

mariafgp

Well I can get back into my forum so I guess it is "solved" but if I enable hostname lookups I will probably have the problem again.

JimM

That's true.  I have that disabled on my host as well.  I can't think of a good reason to enable it myself.  You can click the topic solved link at the bottom left of the page.
Jim "JimM" Moore
Former Support Specialist

mariafgp

Quote from: JimM on March 29, 2009, 03:54:14 PM
That's true.  I have that disabled on my host as well.  I can't think of a good reason to enable it myself.  You can click the topic solved link at the bottom left of the page.

What about banning by hostname? That is if I ever need to.

JimM

Actually that's not a good practice so I don't think you will miss it.  Weighing the increase in speed against the possibility that you might need a feature, leaves you with a pretty simple decision.
Jim "JimM" Moore
Former Support Specialist

Something like that

Quote from: mariafgp on March 29, 2009, 07:43:19 PM
What about banning by hostname? That is if I ever need to.

Pretty much any hostname will always resolve to the same IP address. It's extremely rare they change. Banning by IP should be sufficient :)

Advertisement: