I'm getting this error on the page where I need to moderate photos. I see the list of active members and the "unapproved photo" - but when I click on the "with unapproved photo" I get the database error you see below. I have no idea what this means. Prior photos approved fine, so I'm not sure why this suddenly is spitting out errors. Help?
Database error in Digital Queer
Query:
SELECT
`Profiles`.`ID` as `ID`,
`NickName`,
`Email`,
`Sex`,
DATE_FORMAT(`DateLastLogin`, '%m-%d-%y %H:%i' ) AS `DateLastLoginCur`,
DATE_FORMAT(`DateReg`, '%m-%d-%y %H:%i' ) AS `DateReg`,
`Status`
, `IDLevel`, IF(ISNULL(`MemLevels`.`Name`),'', `MemLevels`.`Name`) AS `MemName`
FROM `Profiles`
LEFT JOIN `media` ON (`media`.`med_prof_id` = `Profiles`.`ID`)
LEFT JOIN `ProfileMemLevels` ON `ProfileMemLevels`.`IDMember` = `Profiles`.`ID`
LEFT JOIN `MemLevels` ON `ProfileMemLevels`.`IDLevel` = `MemLevels`.`ID`
WHERE
1 AND `med_status` = 'passive' AND `med_type`='photo' AND (`Couple`=0 OR `Couple`>`Profiles`.`ID`)
GROUP BY `Profiles`.`ID`
GROUP BY `Profiles`.`ID`
ORDER BY ID DESC
LIMIT 0, 30
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 'GROUP BY `Profiles`.`ID`
ORDER BY ID DESC
LIMIT 0, 30' at line 18
Found error in file /home/queer/public_html/community/admin/profiles.php
at line 268. Called db_res function
with erroneous argument #0
Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/queer/public_html/community/admin/profiles.php
[line] => 268
[function] => db_res
[args] => Array
(
[0] =>
SELECT
`Profiles`.`ID` as `ID`,
`NickName`,
`Email`,
`Sex`,
DATE_FORMAT(`DateLastLogin`, '%m-%d-%y %H:%i' ) AS `DateLastLoginCur`,
DATE_FORMAT(`DateReg`, '%m-%d-%y %H:%i' ) AS `DateReg`,
`Status`
, `IDLevel`, IF(ISNULL(`MemLevels`.`Name`),'', `MemLevels`.`Name`) AS `MemName`
FROM `Profiles`
LEFT JOIN `media` ON (`media`.`med_prof_id` = `Profiles`.`ID`)
LEFT JOIN `ProfileMemLevels` ON `ProfileMemLevels`.`IDMember` = `Profiles`.`ID`
LEFT JOIN `MemLevels` ON `ProfileMemLevels`.`IDLevel` = `MemLevels`.`ID`
WHERE
1 AND `med_status` = 'passive' AND `med_type`='photo' AND (`Couple`=0 OR `Couple`>`Profiles`.`ID`)
GROUP BY `Profiles`.`ID`
GROUP BY `Profiles`.`ID`
ORDER BY ID DESC
LIMIT 0, 30
)
)
)
Called script: /community/admin/profiles.php
Request parameters:
Array
(
[media] => photo
[status] => passive
[sortor] => ID
[sorttype] => DESC
[__utma] => 171541557.3940352683715730400.1217572909.1218411543.1218482514.20
[__utmz] => 171541557.1217572909.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
[__utmb] => 171541557.5.10.1218482514
[__utmc] => 171541557
[profile_polls_question_2] => 1
[profile_polls_question_3] => 1
[logintheme] =>
[cprelogin] => no
[cpsession] => closed
[langedit] =>
[lang] =>
[webmailrelogin] => no
[adminID] => admin
[adminPassword] => xxxxxxxxxxxxxxxxxx
)
