Bueno, tengo un problema con mi web. Resulta que si usuario registrado, pero sin privilegios de administrador/moderador/webmaster intenta ver la lista de Miembros le sale el siguiente error:
Could not read user informations
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near '<> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR (2 = 1 AND ' at line 9
SELECT DISTINCT
u.*,
(CASE WHEN i.buddy_ignore = 0 THEN 1 ELSE 0 END) AS user_my_friend_virt,
i.buddy_visible AS user_my_visible_virt,
(CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) AS user_my_ignore_virt,
(CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) AS user_friend_virt,
b.buddy_visible AS user_visible_virt,
(CASE WHEN b.buddy_ignore = 1 THEN 1 ELSE 0 END) AS user_ignore_virt,
(CASE WHEN (u.user_id = 542 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( 2 <> 0 OR <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR (2 = 1 AND = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR (2 = 2 AND = 1) ) ) ) )) THEN (CASE WHEN u.user_session_time >= (1097507911-300) THEN 1 ELSE 0 END) ELSE '' END) AS user_online_virt,
u.username AS username_virt,
(CASE WHEN (u.user_id = 542 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( 2 <> 0 OR <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR (2 = 1 AND = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR (2 = 2 AND = 1) ) ) ) )) THEN u.user_regdate ELSE '' END) AS user_regdate_virt,
(CASE WHEN (u.user_id = 542 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( 2 <> 0 OR <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR (2 = 1 AND = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR (2 = 2 AND = 1) ) ) ) )) THEN u.user_lastvisit ELSE '' END) AS user_lastvisit_virt,
(CASE WHEN (u.user_id = 542 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( 2 <> 0 OR <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR (2 = 1 AND = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR (2 = 2 AND = 1) ) ) ) )) THEN u.user_posts ELSE '' END) AS user_posts_virt,
(CASE WHEN (u.user_id = 542 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( 1 <> 0 OR 1 <> 1 ) AND u.user_allow_website = 1 AND ( b.buddy_visible = 1 OR ( u.user_viewwebsite = 1 OR (1 = 1 AND 1 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_viewwebsite = 2 OR (1 = 2 AND 1 = 1) ) ) ) )) THEN r.rank_title ELSE '' END) AS user_rank_title_virt,
(CASE WHEN (u.user_id = 542 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( 1 <> 0 OR 1 <> 1 ) AND u.user_allow_real = 1 AND ( b.buddy_visible = 1 OR ( u.user_viewreal = 1 OR (1 = 1 AND 1 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_viewreal = 2 OR (1 = 2 AND 1 = 1) ) ) ) )) THEN u.user_flag ELSE '' END) AS user_flag_virt,
1 AS user_generic_display,
(CASE WHEN (u.user_id = 542 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( 1 <> 0 OR 1 <> 1 ) AND u.user_allow_real = 1 AND ( b.buddy_visible = 1 OR ( u.user_viewreal = 1 OR (1 = 1 AND 1 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_viewreal = 2 OR (1 = 2 AND 1 = 1) ) ) ) )) THEN 1 ELSE '' END) AS user_real_display,
(CASE WHEN (u.user_id = 542 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( 2 <> 0 OR <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR (2 = 1 AND = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR (2 = 2 AND = 1) ) ) ) )) THEN 1 ELSE '' END) AS user_viewonline_display,
(CASE WHEN (u.user_id = 542 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( 1 <> 0 OR 1 <> 1 ) AND u.user_allow_website = 1 AND ( b.buddy_visible = 1 OR ( u.user_viewwebsite = 1 OR (1 = 1 AND 1 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_viewwebsite = 2 OR (1 = 2 AND 1 = 1) ) ) ) )) THEN 1 ELSE '' END) AS user_webdisplay_display
FROM ((((
phpbb_users AS u)
LEFT JOIN phpbb_buddy AS i ON i.user_id=542 AND i.buddy_id=u.user_id)
LEFT JOIN phpbb_buddy AS b ON b.user_id=u.user_id AND b.buddy_id=542)
LEFT JOIN phpbb_ranks AS r ON (u.user_rank > 0 AND r.rank_special <> 0 AND r.rank_id = u.user_rank) OR (u.user_rank = 0 AND r.rank_special = 0 AND u.user_posts >= r.rank_min AND u.user_posts < r.rank_max))
WHERE u.user_id <> -1
ORDER BY username_virt ASC
Line : 906
File : /home/virtual/sitio12534/www/portal/profilcp/profilcp_buddy.php
A qué puede ser debido? falta alguna tabla en la base de datos?