problem with birthdays

I ran into a bit of an issue on my site over the past few weeks when I started allowing registrations without setting birthdate. My memberbase doesn't particularly care about birthdates or ages of other members, and nor do I want it to be required. But now I'm finding that the null value of 0000-00-00 in the database is causing an error when sitename.com/browse.php is accessed. Members see a blank white page, and I get the error quoted below in an email.

Is it possible to omit the code so browse.php doesn't error out? My thoughts are that this is coming from the table selection where you can click an age group to browse within.

Thanks in advance for any hints - if you post me a link to a paid extension for this I will smack you... :)

SELECT COUNT(*) FROM `Profiles` WHERE `Status` = 'Active' 
						AND
					((YEAR(CURDATE())-YEAR(`DateOfBirth`)) - (RIGHT(CURDATE(),5)<RIGHT(`DateOfBirth`,5))) >= 13
						AND
					((YEAR(CURDATE())-YEAR(`DateOfBirth`)) - (RIGHT(CURDATE(),5)<RIGHT(`DateOfBirth`,5))) <= 15

Hello!

Better to restore DateOfBirth field in `Profiles` table via execution this query:

ALTER TABLE `Profiles` ADD `DateOfBirth` date NOT NULL;

It is simplest way of fixing.

Regard

Thanks LeonidS,

I gave it a shot, however it appears it did not solve the issue. Upon checking the database in phpmyadmin, the field is set as 'not null', and everyone that had registered without a birthdate is showing 0000-00-00.

I cleared cache and everything with no luck. This issue also appears to be much more severe than originally anticipated, I can no longer administrate members within the administration backend.. all member related pages are showing up blank!

Do you happen to have any other suggestions?

Anyone able to provide me any insight with this one? It is becoming a bigger issue than what I originally anticipated. Not being able to browse members in the admin panel is a HUGE issue :(.

I modified my site settings to allow ages 0-100, and went through the last 30 or so members that joined since making the modification to the join page and gave them a birthday of Aug 6 2010 just to see what would happen, I did not make any progress with those changes. Should I try setting them out beyond a year old?