Sunday, August 21, 2011

Bug? Squashed!

What a frustrating day!

After finding and correcting a number of unexpected bugs on Friday and Saturday I was in full on prepare to release mode.

I was finalising the help file with Dr.Explain which has proved to be absolutely fantastic.  The help contents that I’d been drafting in Word just took a cut and paste into Dr.Explain and with some setup of theme, header and footers I had the CHM and HTML Files for a great looking help file.

A final run through each of the versions of StrokePlay (Debug, Release and Free Trial) was the start of the problems.  The Debug and Free Trial editions looked good but the Release version appeared to be recording some invalid data which caused the charting SQL queries to misbehave.

In the end it all boiled down to a old SQL statement I’d missed when the final table layouts were made.  This resulted in some score data being reset before insertion which in turn led to the charts getting invalid data.  It took an age to track down because it only happened in the release version – which is full of anti-debug and anti-trace code!

At the end of the day it was a bug.  It’s now an ex-bug which will no longer appear in the release version.

I had extra time during all the wait time between builds too, so I put the support forums in place on the website using phpBB.  An added bonus.

Back into release prep mode now moving forward quickly.

No comments: