Database error when new user signs up

harpoon posted 7th of April 2008 in Community Voice. 2 comments.
Whenever  a new user signs up I get this message in my email. Is there a fix?

Database error in CuckoldShare
Query:
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

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
)

 
Comments
·Oldest
·Top
Please login to post a comment.
First off, I would stop posting the complete error message as it contains passwords etc.

Secondly, what mods or changes have you done to your site?
harpoon
I havent done any mods or changes
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.
PET:0.043735027313232