Thursday, August 11, 2016

The Community Forum is up and running.

Well after much hair pulling and asking a bunch of questions I finally got the Community Forum back up and running. We may have lost a couple days of data. The Backup that I restored was from Saturday so don't be surprised if you don't find your last post.

Thanks to all the readers who sent suggestions. Here is what happened for those who are interested.

I use iPower web hosting and they did their job reasonably quickly. They had a hardware issue on one of their servers. It took over night for them to get it repaired which is okay for the level of service I pay for. After the server was back up both my Pattern Catalog and Community Forum were down. The Pattern Catalog was fairly easy to fix. I restored the database from a backup and reconnected it and it was fine.

The Community Forum would still not work after I did the same restore form it's backup. What I did not realize is that the restore was timing out before it completely finished. The script that does the upload has a timeout interval. If it reaches that time it stops. I missed the message that said it timed out so I thought it was done. What you have to do is keep resubmitting the same file until it completes. It's a strange way for it to work but that's how it works. I had to upload the same backup five times for it to complete. After two days of working on it that's all it took.

It's strange that two completely different databases became corrupted at the same time. All I can think of is that they were both being accessed when the server powered off abruptly. The databases just did not get closed appropriately and they did not like that. It's what is known as not having a graceful shutdown. I used to see it at work from time to time. It's just a crap shoot whether is causes a problem or not.

Sorry about the long boring story but several readers emailed with advise so I just wanted to tell my story of woe. 

I Love My Soldier Scroll Saw Pattern.

I Love My Soldier word art pattern. Let your military family member know that you are proud of them and their service. The word art is 10" X 4.25". 

Running this blog gives me a great deal of enjoyment. I love the creative side of what I do and I love meeting and working with people all over the world. I have also always been a computer enthusiast so I even enjoy the technical side of maintaining a web site.

The last two days however have strained that enjoyment. :) To make a long, long story short the database server for my site died. That took down my free online catalog and the Community forum. My hosting service worked to get the hardware fixed but the databases were corrupted so backups had to be used.

Luckily the database backup for the Online catalog worked and I only lost two days of data. Easy to fix. Unluckily the backup for the Community forum is not working. The data is still there but I can't get it to connect to the forum software. After many hours and little sleep I give up. I'm going to have to call in some expert help.

What this means is that the forum may be down a couple more days. Hang in there with me and I'll get it fixed as soon as possible.  

 

The Scrollsaw Workshop is primarily supported by donations. If you enjoy this Blog and would like to make a donation please click this Button. Your support is greatly appreciated. 
You do not need a PayPal account to donate. All donations are handled securely through PayPal. I do not see your credit card information. I do receive your email address. I only use the email address to send thank you emails. Your email will not be sold or given away.
http://www.stevedgood.com/donate2.html


http://www.stevedgood.com/woodenvases.html
Each digital book is available for download immediately after payment.
The books are $12 per edition and contains eight unique patterns each.
Click now and make a family heirloom this weekend.

If you would like to have all the patterns in the Scrollsaw Workshop catalog you can buy the first six years DVD and the 2013 update DVD at this link. DVD #1 is $20 and contains over 1,100 patterns. The 2013 update DVD is $7.50 and has another 178 patterns. The 2014 update DVD is $7.50 and has another 223 patterns.
http://amzn.to/2b9TNAC
Proud to be a NAVY MOM T 
 
The Ladies Proud Navy Mom T is an AFG exclusive design and available on a high quality T that's truly fit for a lady! If you know, or are, a Proud Navy Mom it's time to show it with style!