MySQL datatbase error...

Database error in SITE TITLE
Query:
SELECT COUNT(*) FROM `Profiles` WHERE  AND (`Profiles`.`Couple`='0' OR `Profiles`.`Couple`>`Profiles`

.`ID`) AND `Profiles`.`Status` = 'Active'

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 'AND (`Profiles`.`Couple`='0' OR `Profiles`.`Couple`>`Profiles`
.`ID`) AND `Profil' at line 1

Found error in file /home/.manet/deciphagear/deciphagear.com/dolphin/browse.php
at line 199. Called db_arr function
with erroneous argument #0

Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/.manet/deciphagear/deciphagear.com/dolphin/inc/db.inc.php
[line] => 115
[function] => db_res
[args] => Array
(
[0] => SELECT COUNT(*) FROM `Profiles` WHERE  AND (`Profiles`.`Couple`='0' OR `Profiles`.`Couple`>`Profiles`
.`ID`) AND `Profiles`.`Status` = 'Active'
[1] => 1
)

)

[2] => Array
(
[file] => /home/.manet/deciphagear/deciphagear.com/dolphin/browse.php
[line] => 199
[function] => db_arr
[args] => Array
(
[0] => SELECT COUNT(*) FROM `Profiles` WHERE  AND (`Profiles`.`Couple`='0' OR `Profiles`.`Couple`>`Profiles`
.`ID`) AND `Profiles`.`Status` = 'Active'
)

)

[3] => Array
(
[file] => /home/.manet/deciphagear/deciphagear.com/dolphin/browse.php
[line] => 61
[function] => PageCompPageMainCode
[args] => Array
(
)

)

)


Called script: /dolphin/browse.php

Request parameters:
Array
(
[strSec] => 314a4448666190f877456fcb1a8d35
4d
[memberID] => 1
[memberPassword] => 440fea0149d209c8e812c579fc3b54
6c
)


--
Auto-report system



Anyone know how to fix this?? Right now I can't view the members section.. a page pops up that says database error
Quote · 26 Jun 2008

i re-added the date option and it seems to be working fine now..

Quote · 26 Jun 2008
 
 
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.