Landracing Forum

Misc Forums => Website Suggestions => Topic started by: landracing on April 11, 2007, 08:54:08 PM

Title: Board Back Online
Post by: landracing on April 11, 2007, 08:54:08 PM
Group,

Had some major database problems. There were some log files, that I did not know existed, these files created about 6 files that had more then 6 gig of data. This created a problem that MYSQL database could not fit any more data into a directory that I had at 6 gig maximum. This created the problem that a few database tables stayed "open" and never close a connection. This explains why the board went down a week ago and again a couple days ago. This also created severe loads on the server, which was running at a snails pace.

Luckily I had a backup of the board from the 4th of April. That is what is installed, so we lost a few days posts over the Easter Weekend.

I have corrected the log file problem, and im writing a few commands for a "Cron" job to backup the database every 2 days. And the backups wont write over each other, they will saved by date file name.

If you find something not working correctly please post it here, so I can keep tabs on issues, and it lets others know if there is a problem also.

Jon
Title: Re: Board Back Online
Post by: Glen on April 11, 2007, 08:56:41 PM
Good job as always Jon.
Glen
Title: Re: Board Back Online
Post by: Harold Bettes on April 11, 2007, 09:02:41 PM
Jon,

I lost my hard earned status as a full member and it has tossed me back to Junior status. What a bummer! :?
Also lost a photo that I had plugged in as well. :cry:

I can just build it back up again. :-D Hope that I didn't cause the thing to crash.

Surely you have done a good job restoring it as quickly as you have done, but I was going through some signs of withdrawl.

Regards,
HB2
Title: Re: Board Back Online
Post by: Tom Shannon on April 11, 2007, 09:06:52 PM
Jon;

Great job! Thanks for all you do. BTW Mr Glen. Who smuggled the computer into your hospital room?? Fess up Tami!! LOL Good to hear from 'ya buddy!
Now send some decent St George weather up North!!Now get Better!!
Title: Re: Board Back Online
Post by: Sumner on April 11, 2007, 09:09:37 PM
Thanks Jon, I imagine this was a major effort on your part.  Thanks for all the time you put in so that we can post and keep track of what is going on in LSR,

Sum

Title: Re: Board Back Online
Post by: landracing on April 11, 2007, 09:11:48 PM
Jon,

I lost my hard earned status as a full member and it has tossed me back to Junior status. What a bummer! :?
Also lost a photo that I had plugged in as well. :cry:

I can just build it back up again. :-D Hope that I didn't cause the thing to crash.

Surely you have done a good job restoring it as quickly as you have done, but I was going through some signs of withdrawl.

Regards,
HB2

Harold,
Dont worry you are two posts away from the Full member status, you probably got that status over easter weekend and we lost about 3-4 days of posts.

No you didn't crash the board :)

What photo? I should be able to recover it. Just tell me where the photo was, in a post, your avatar???

Jon
Title: Re: Board Back Online
Post by: 836dstr on April 11, 2007, 09:12:25 PM
Jon,

Thanks for all you do!

I tried about 4 times to log in today and was really bummed to find the site down.

Tom
Title: Re: Board Back Online
Post by: JackD on April 11, 2007, 09:13:27 PM
Good job as always Jon.
Glen
I was gonna lay it off on Glen but he is loose.
NO, not that way !
 I mean he got booted out of the Hospital.
I hope all the hard work and dedication on Jon's part makes Glen feel even better.
NO, not that way !
I guess we will be hearing more from him and you might as well get accustomed to it.
Title: Re: Board Back Online
Post by: Dean Los Angeles on April 11, 2007, 10:15:26 PM
Jon!!!!!!! Great job.

Glad to see everyone back.

I had to talk to the WIFE for three days!
Title: Re: Board Back Online
Post by: Freud on April 11, 2007, 10:25:02 PM
Jon......I didn't desert you. I just didn't contact you when I
knew you were diggin' as fast as possible.
CONGRATULATIONS !
FREUD
Title: Re: Board Back Online
Post by: Freud on April 11, 2007, 10:30:22 PM
Carol, Glen's wife, would probably pay for overtime help for Jon if he needed it to get the board back online. Can you imagine Barrett at home and not being able to access the site?
That would be intense !!

FREUD
Title: Re: Board Back Online
Post by: RidgeRunner on April 11, 2007, 10:39:23 PM
     THANK YOU Jon!

     No more left out feeling and a speed fix available whenever I feel the need.  Life is great again :-D

     Hope you can now get a chance at a well deserved break.

     Your efforts are always very much appreciated here in the North East corner :-)
Title: Re: Board Back Online
Post by: bak189 on April 11, 2007, 10:49:59 PM
Thanks Jon........................welcome home Glen!!!!!!!!!
Title: Re: Board Back Online
Post by: Stainless1 on April 11, 2007, 11:07:23 PM
Jon, does this mean we have to re-post our banter and say nice things about Glen again?  Once was almost my limit...  :lol: Glad to see you back Glen, you still have a lot of catching up to do. 
I had a couple of extra hours to work on the bike this week since the site was down.
Good work Jon, even if you let the site die every now and then.  :roll:
Title: Re: Board Back Online
Post by: salt27 on April 12, 2007, 12:55:58 AM
Jon;
Thank you for getting us all back together. This site is extremely valuable to our sport.

Thanks again
          Don
Title: Re: Board Back Online
Post by: Scott on April 12, 2007, 01:21:39 AM
Thanks, got my LSR fix.
SB
Title: Re: Board Back Online
Post by: Freud on April 12, 2007, 01:43:55 AM
Well since we tell him how much we miss the site, let's grease his palm a little.
I know it costs to keep this site alive and I can imagine that he took time off
work to get back on line.
I'm sending my wife's beer money. She will be out of town a day or two and
won't miss it.
FREUD
Title: Re: Board Back Online
Post by: Mile High Talon on April 12, 2007, 01:57:36 AM
Thanks for this excellent forum Jon! I haven't posted much since joining a couple years ago, but have learned alot from all you folks!!

Get a message "an error has occurred" when trying to post photos to "My Gallery" which I created after 4/4. Its gone, and I can't locate the menu tabs to re-build it.

James LaMere
Title: Re: Board Back Online
Post by: JonA on April 12, 2007, 02:06:44 AM
Mile High,

Are you sure you are going to correct place.

http://www.landracing.com/gallery
then under the "@" symbol, you have to mouse over, and then select my galleries.

I just created one with this username, not an admin user, just everyday user, added a new album and uploaded a pic just fine.

I do see all your pictures still there. Those were uploaded and stay there no matter what happens to database.

Jon

If not, PM me your password and ill see if I can duplicate the problem.

Title: Re: Board Back Online
Post by: hawkwind on April 12, 2007, 03:48:54 AM
A bbbbbiiiiiiggggggggg thankyou my lil buddy ,much appreciated , how do I send you some Aussie peso's in appreciation ?
Gary
Title: Re: Board Back Online
Post by: dwarner on April 12, 2007, 08:53:34 AM
Jon,

Please allow me to add my thanks to the long list. Your dedication and hard work have made this the premier LSR website. This is the site that other message boards point to when a LSR question is posted.

DW
Title: Re: Board Back Online
Post by: PorkPie on April 12, 2007, 02:10:15 PM
Hi Jon,

thanks for fixing the problem.

At first I thought that the anti (engine) smoker community* sent you a MS Virus.....

* = this community was found in LA, after they heard from the Phoenix and his smoke alarm he produced at the salt.....