Page 1 of 1
MySQL connections
Posted: Fri Oct 26, 2007 9:41 am
by ~Z~
After getting this MySQL error message on and off for the past two days, I just changed how this message board connects to the main database that has all of the forum posts in it. Please let me know if you notice any kind of change in speed, errors, or problems with the shoutbox. Trying some tweaking and hoping this will help those issues.
Posted: Fri Oct 26, 2007 2:09 pm
by ~Z~
is anyone noticing any kind of difference at all? is it running the same for you?
Posted: Fri Oct 26, 2007 2:11 pm
by CAT345C
funny, I took a screen shot of what it did, but I didn't save it. The shout box looked like it was written in Microsoft word (never a good thing) No formating, just white, with huge font.
Posted: Fri Oct 26, 2007 4:21 pm
by Norm
No change here; everything running smoothly.
Glad you know your SQL commands. I administer an aviation forum using UBB threads, and worry about using them. One wrong move, and things can get screwed up in a hurry.
Posted: Fri Oct 26, 2007 7:57 pm
by J T
I can use two cans and wire to communicate.
Posted: Thu Dec 13, 2007 3:57 pm
by ~Z~
Well, decided to reverse this and back up even further. Turned on in more places what's called "persistant connections." What this is supposed to do is keep you connected to the big MySQL database that holds all the text and information for the message board and gallery.
I'm working within a small window from the host of mine that eats banannas. If too many people are have been accessing the SQL database, we'll get some errors said "error, max connections blah blah blah"
By making your windows persisant, each user should only use one connection, so things might be fine now... Hopefully you won't notice any speed issues.
I also hope this takes care of a problem the host had with us users lately...seems as though if you opened up 30 or more pages on the site within a short time, you got blocked by your IP address, and pretty much were banned from the site... i can think of at least 10 people that this happened to, including MYSELF, recently.
Anyway, let me know if you see any errors come up... keep this email address for reference in case you have problems:
zysegur@hotmail.com
That's an external address that should always work, even when the site goes down.
Posted: Thu Dec 13, 2007 7:34 pm
by i995impalass
I had a bit of a thing sending PM about a week ago. It said message could not be sent error Debugging.
Been working great since tho...