I have nodeprofile CCK at my site, so when I logged in as a dummy user as "aaa", I get this error:
* warning: implode(): Bad arguments. in /home/normann/public_html/community/sites/all/modules/private_nodes/private_nodes.module on line 203.
* 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 ')) OR n.uid=10)) AND ( n.status = 1 AND ((e.event_start >= 1185944400 AND e.eve' at line 1 query: SELECT DISTINCT(n.nid), e.event_start FROM node n INNER JOIN event e ON n.nid = e.nid INNER JOIN node_access na ON na.nid = n.nid LEFT OUTER JOIN private_nodes pn ON pn.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all'))) AND ((pn.nid is null OR (pn.level=1 AND n.uid IN ()) OR n.uid=10)) AND ( n.status = 1 AND ((e.event_start >= 1185944400 AND e.event_start <= 1188622799) OR (e.event_end >= 1185944400 AND e.event_end <= 1188622799) OR (e.event_start <= 1185944400 AND e.event_end >= 1188622799)) ) ORDER BY event_start in /home/normann/public_html/community/includes/database.mysql.inc on line 172.
* warning: implode(): Bad arguments. in /home/normann/public_html/community/sites/all/modules/private_nodes/private_nodes.module on line 203.
* 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 ')) OR n.uid=10)) AND ( n.status = 1 AND (((e.event_start != e.event_end) AND (1' at line 1 query: SELECT DISTINCT(n.nid), n.title, n.type, n.status, n.changed, e.event_start, e.event_end FROM node n INNER JOIN event e ON n.nid = e.nid INNER JOIN node_access na ON na.nid = n.nid LEFT OUTER JOIN private_nodes pn ON pn.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all'))) AND ((pn.nid is null OR (pn.level=1 AND n.uid IN ()) OR n.uid=10)) AND ( n.status = 1 AND (((e.event_start != e.event_end) AND (1186791538 >= e.event_start AND 1186791538 < e.event_end)) OR ((e.event_start = e.event_end) AND (1186791538 <= e.event_start + 7200 )) OR e.event_start >= 1186791538) ) ORDER BY event_start LIMIT 6 in /home/normann/public_html/community/includes/database.mysql.inc on line 172.
* warning: implode(): Bad arguments. in /home/normann/public_html/community/sites/all/modules/private_nodes/private_nodes.module on line 203.
* 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 ')) OR node.uid=10)) LIMIT 0, 20' at line 1 query: SELECT DISTINCT(node.nid) FROM node node INNER JOIN node_access na ON na.nid = node.nid LEFT OUTER JOIN private_nodes pn ON pn.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all'))) AND ((pn.nid is null OR (pn.level=1 AND node.uid IN ()) OR node.uid=10)) LIMIT 0, 20 in /home/normann/public_html/community/includes/database.mysql.inc on line 172.
The funny thing is that this doesn't apply to other users, only aaa.
Comments
Comment #1
finex commentedI've the same error, I was testing with an user different from the admin one, and I've got this. Have your user on a particular role/group?
Comment #2
kilimanjaro commentedNo not at all. The role is just regular "authenticated".
Comment #3
ben_scott commentedSorry about that - I think this error was being produced when of users had no buddies. I've tweaked the code to check for buddies before imploding the array which should fix the problem.
Cheers, b3n
Comment #4
finex commentedWell done, thanks!!!
Comment #5
kilimanjaro commentedThanks!! :D
Comment #6
(not verified) commented