hi there
I have skadate 9. I want to several design in my template. And There are several bugs in Skadate. And could quote a price for these? I'am waiting for reply.
Hi,
Bug 1:
When I enable this "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)