HomeUnityBlogs
 
 
harpoon

Database error when new user signs up

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
)

bad
0
good
 
 

Comments

CyberXing
CyberXing 88 days agocomment permalink
 
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?
 
bad
0
good
 
 
harpoon
harpoon 88 days agocomment permalink
 
I havent done any mods or changes
 
bad
0
good
 
 


Post a Comment

Please login to post a comment.

This Post
 
 
harpoon Blog
All Blogs
Found a bug? Have a suggestion? We really value your feedback!
 
© 2008 BoonEx Ltd
ABN 27 127 966 581
 
PET:0.386750936508