I have skadate dating software. And There's a bug in the software.
Firstly, This bug should be fixed.
When I enable this in admin area "Members can see only profiles of preferred sex in Profile lists" in additional settings, the site gives a error. This problem need to solve. And certainly the females members won't see each other in the site, in the same way, also the males members won't see each other in the site.
the error is:
Warning: MySQL error: Unknown column '[login to view URL]' in 'where clause'
in query: SELECT COUNT( `main`.`profile_id` ) FROM `skadate_profile` AS `main` LEFT JOIN `skadate_profile_extended` AS `extend` USING( `profile_id` ) LEFT JOIN `skadate_profile_online` AS `online` USING( `profile_id` ) WHERE 1 AND `main`.`profile_id` NOT IN ( SELECT `blocked_id` FROM `skadate_profile_block_list` WHERE `profile_id` =1 ) AND YEAR('2012-02-27 03:12:38')-YEAR(`birthdate`)- IF( DAYOFYEAR(`birthdate`) >= DAYOFYEAR('2012-02-27 03:12:38'),1,0) >= 20 AND YEAR('2012-02-27 03:12:38')-YEAR(`birthdate`)-IF( DAYOFYEAR(`birthdate`) >= DAYOFYEAR('2012-02-27 03:12:38'),1,0) <=102 AND SUBSTRING_INDEX( `match_agerange`, '-', 1 ) <= 25 AND SUBSTRING_INDEX( `match_agerange`, '-', -1 ) >= 25 AND ( 2&IF( ISNULL(`match_sex`) OR `match_sex`=0, 0xffffffffffffffff, `match_sex` ) AND 1&IF( ISNULL(`sex`) OR `sex`=0, 0xffffffffffffffff, `sex` ) ) AND ( `main`.`status`='active' ) AND `main in /home/site/public_html/site1/internals/SK6_inc/[login to view URL] on line 299
--------------------------------
And then:
So, my site is religion site. It must not ask to the members looking for male or famale fields in join. So, when the members select to their gender, system should detect the gender and If the member select the male, it should detect and show famales members. And If the member select the female, it should detect and show males members. And certainly the females members won't see each other in the site, in the same way, also the males members won't see each other in the site. And also system must not ask to members their gender in search and quick search. It should detect automatically genders.