I am now getting CRAG messages on RSS, so I wanted to stop
getting them by email. At the bottom of the latest email, it says:
> You are subscribed to the group ‘Fora’ at ‘CRAG’. To manage your
> subscription, visit http://www.carbonrationing.org.uk/og/manage/282
But this gave:
* user warning: 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 ‘)\
‘ at line 1 query:
SELECT COUNT FROM og og
INNER JOIN node n ON og.nid
= n.nid
INNER JOIN node_revisions r ON r.vid = n.vid
INNER JOIN users u ON
n.uid =\
u.uid
INNER JOIN og_uid ou ON ou.uid = u.uid
INNER JOIN node_access na ON
na.nid = og.nid
WHERE (na.grant_view >= 1
AND ((na.gid = 0
AND na.realm =
‘all’) \
OR (na.gid = 0
AND na.realm = ‘og_public’) OR (na.gid = 0
AND na.realm =
‘og_all’)))
AND og.nid IN () in
/home/zamama/public_html/carbonrationing/includes/d\
atabase.mysql.inc on line 121.
* user warning: 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 ‘)\
ORDER BY og.nid
DESC LIMIT 0, 50’ at line 1 query:
SELECT
DISTINCT, n.title, r.body, n.uid, u.name, og.description
FROM og
og
INNER JOIN node n ON \
og.nid = n.nid
INNER JOIN node_revisions r ON r.vid = n.vid
INNER JOIN
users u ON n.uid = u.uid
INNER JOIN og_uid ou ON ou.uid = u.uid
INNER JOIN
node_acces\
s na ON na.nid = og.nid
WHERE (na.grant_view >= 1
AND ((na.gid = 0
AND
na.realm = ‘all’) OR (na.gid = 0
AND na.realm = ‘og_public’) OR (na.gid =
0
AND na.re\
alm = ‘og_all’)))
AND og.nid IN ()
ORDER BY og.nid
DESC LIMIT 0, 50 in
/home/zamama/public_html/carbonrationing/includes/database.mysql.inc on
line 121.
Hope this is helpful as a bug report!
Thanks,
Amanda
