Whenever a new user signs up I get this message in my email. Is there a fix?
SELECT `SDatingEvents`.`ID`, `Title`, (NOW() > `EventEnd` AND NOW() < DATE_ADD(`EventEnd`, INTERVAL `ChoosePeriod` DAY)) AS `ChooseActive`, (`SDatingParticipants`.`ID` IS NOT NULL) AS `IsParticipant`
LEFT JOIN `SDatingParticipants` ON `SDatingParticipants`.`IDEvent
` = `SDatingEvents`.`ID` AND `SDatingParticipants`.`IDMember` =
WHERE `SDatingEvents`.`Status` = 'Active'
AND NOW() < DATE_ADD(`SDatingEvents`.`EventEnd`, INTERVAL `SDatingEvents`.`ChoosePeriod` DAY)
AND FIND_IN_SET('', `SDatingEvents`.`EventSexFilter`)
AND ( TO_DAYS('')
BETWEEN TO_DAYS(DATE_SUB(NOW(), INTERVAL `SDatingEvents`.`EventAgeUpperFilter` YEAR))
AND TO_DAYS(DATE_SUB(NOW(), INTERVAL `SDatingEvents`.`EventAgeLowerFilter` YEAR)) )
AND ( INSTR(`SDatingEvents`.`EventMembershipFilter`, '\'all\'') OR INSTR(`SDatingEvents`.`EventMembershipFilter`, '\'1\'') )
ORDER BY `SDatingEvents`.`EventStart` DESC
Mysql error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `SDatingEvents`.`Status` = 'Active'
AND NOW() < DATE_ADD(`SDatingEven' at line 4
Found error in file /home/youtenet/public_html/
cuckoldshare.com/member.php at line 691. Called db_res function
with erroneous argument #0
Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/youtenet/public_html/
cuckoldshare.com/member.php [line] => 691
[function] => db_res
[args] => Array
(
[0] => SELECT `SDatingEvents`.`ID`, `Title`, (NOW() > `EventEnd` AND NOW() < DATE_ADD(`EventEnd`, INTERVAL `ChoosePeriod` DAY)) AS `ChooseActive`, (`SDatingParticipants`.`ID` IS NOT NULL) AS `IsParticipant`
FROM `SDatingEvents`
LEFT JOIN `SDatingParticipants` ON `SDatingParticipants`.`IDEvent` = `SDatingEvents`.`ID` AND `SDatingParticipants`.`IDMember` =
WHERE `SDatingEvents`.`Status` = 'Active'
AND NOW() < DATE_ADD(`SDatingEvents`.`EventEnd`, INTERVAL `SDatingEvents`.`ChoosePeriod` DAY)
AND FIND_IN_SET('', `SDatingEvents`.`EventSexFilter`)
AND ( TO_DAYS('')
BETWEEN TO_DAYS(DATE_SUB(NOW(), INTERVAL `SDatingEvents`.`EventAgeUpperFilter` YEAR))
AND TO_DAYS(DATE_SUB(NOW(), INTERVAL `SDatingEvents`.`EventAgeLowerFilter` YEAR)) )
AND ( INSTR(`SDatingEvents`.`EventMembershipFilter`, '\'all\'') OR INSTR(`SDatingEvents`.`EventMembershipFilter`, '\'1\'') )
ORDER BY `SDatingEvents`.`EventStart` DESC
)
)
[2] => Array
(
[file] => /home/youtenet/public_html/
cuckoldshare.com/member.php [line] => 157
[function] => pagecompmemberinfo
[args] => Array
(
[0] =>
[1] =>
)
)
[3] => Array
(
[file] => /home/youtenet/public_html/
cuckoldshare.com/member.php [line] => 128
[function] => getpageblocks
[args] => Array
(
[0] => 2
)
)
)
Called script: /member.php
Request parameters:
Array
(
[strSec] => 93abb90580f789bec75d4ddcca47fe26
[IDc] => sep6gevYuZPvo
[memberID] => 49
[memberPassword] => d8a5323800baab621ff227ebb014b60d
)
Secondly, what mods or changes have you done to your site?