Foutje bij Profile Control Panel

[dorque]

Ik heb PCP geinstalleerd (en het is een aanrader :thumb:) maar als ik met mijn testaccount naar buddy list ga, krijg ik dit:

Code: Selecteer alles

Could not read user informations

DEBUG MODE

SQL Error : 1064 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 '<> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_vi

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 = 3 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN (CASE WHEN u.user_session_time >= (1116755609-300) THEN 1 ELSE 0 END) ELSE '' END) AS user_online_virt,
u.username AS username_virt,
(CASE WHEN (u.user_id = 3 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN u.user_regdate ELSE '' END) AS user_regdate_virt,
(CASE WHEN (u.user_id = 3 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN u.user_lastvisit ELSE '' END) AS user_lastvisit_virt,
(CASE WHEN (u.user_id = 3 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN u.user_posts ELSE '' END) AS user_posts_virt,
(CASE WHEN (u.user_id = 3 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND u.user_allow_website = 1 AND ( b.buddy_visible = 1 OR ( u.user_viewwebsite = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_viewwebsite = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN r.rank_title ELSE '' END) AS user_rank_title_virt,
				1 AS user_generic_display,
(CASE WHEN (u.user_id = 3 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN 1 ELSE '' END) AS user_viewonline_display,
(CASE WHEN (u.user_id = 3 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND u.user_allow_website = 1 AND ( b.buddy_visible = 1 OR ( u.user_viewwebsite = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_viewwebsite = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN 1 ELSE '' END) AS user_webdisplay_display
			FROM ((((
phpbb_users AS u)
LEFT JOIN phpbb_buddy AS i ON i.user_id=3 AND i.buddy_id=u.user_id)
LEFT JOIN phpbb_buddy AS b ON b.user_id=u.user_id AND b.buddy_id=3)
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 AND i.buddy_ignore = 0
			ORDER BY username_virt ASC

Ik heb dit overigens niet met mijn eigen account (waarbij ik admin ben dus)

Als iemand me kan helpen, het mag best!

Alvast bedankt

[Bee]

Okee, sorry, maar wat voor query is dit!

Maar dit is toch een door phirtiik zelfgemaakt bestand? Dan ik ik mij niet voorstellen dat deze fout voorkomt.

Kan je proberen de weergave van de buddylijst te veranderen?

[Paul]

Code: Selecteer alles

(CASE WHEN (u.user_id = 3 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN (CASE WHEN u.user_session_time >= (1116755609-300) THEN 1 ELSE 0 END) ELSE '' END) AS user_online_virt,

En dan bij

Code: Selecteer alles

(  <> 0 OR 0 <> 1 )

Mist waarschijnlijk een variabelen, die dus leeg is.

[dorque]

En wat moet ik dan nu doen??

[Paul]

ik weet nie, ik heb geen idee in welk bestand deze query zit.
Probeer is de instellingen van de buddy list aan te passen (Of een buddy toe te voegen )

[dorque]

Okee, sorry, maar wat voor query is dit!

Maar dit is toch een door phirtiik zelfgemaakt bestand? Dan ik ik mij niet voorstellen dat deze fout voorkomt.

Kan je proberen de weergave van de buddylijst te veranderen?

Hoe bedoel je?

[Bee]

Bij PCP kan je instellen welke velden weergeven moeten worden in het ACP. Volgens mij ligt dit aan online/offline, dus dan moet je even kijken of je dat kan uitzetten.

[dorque]

Ik heb een nieuw forum opgezet (helemaal opnieuw begonnen) om te kijken of het dan wel lukte... het resultaat:

Code: Selecteer alles

Could not read user informations

DEBUG MODE

SQL Error : 1064 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 '<> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_vi

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 = 3 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN (CASE WHEN u.user_session_time >= (1116780487-300) THEN 1 ELSE 0 END) ELSE '' END) AS user_online_virt,
u.username AS username_virt,
(CASE WHEN (u.user_id = 3 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN u.user_regdate ELSE '' END) AS user_regdate_virt,
(CASE WHEN (u.user_id = 3 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN u.user_lastvisit ELSE '' END) AS user_lastvisit_virt,
(CASE WHEN (u.user_id = 3 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN u.user_posts ELSE '' END) AS user_posts_virt,
(CASE WHEN (u.user_id = 3 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND u.user_allow_website = 1 AND ( b.buddy_visible = 1 OR ( u.user_viewwebsite = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_viewwebsite = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN r.rank_title ELSE '' END) AS user_rank_title_virt,
				1 AS user_generic_display,
(CASE WHEN (u.user_id = 3 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN 1 ELSE '' END) AS user_viewonline_display,
(CASE WHEN (u.user_id = 3 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND u.user_allow_website = 1 AND ( b.buddy_visible = 1 OR ( u.user_viewwebsite = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_viewwebsite = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN 1 ELSE '' END) AS user_webdisplay_display
			FROM ((((
phpbb_users AS u)
LEFT JOIN phpbb_buddy AS i ON i.user_id=3 AND i.buddy_id=u.user_id)
LEFT JOIN phpbb_buddy AS b ON b.user_id=u.user_id AND b.buddy_id=3)
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 AND i.buddy_ignore = 0
			ORDER BY username_virt ASC



Line : 906
File : profilcp_buddy.php

Dit is toch duidelijk een andere fout. Kan het niet aan profilecp_buddy.php liggen?

En ik snap ook niet waarom ik het met mijn eigen account niet heb en met een testaccountje wel :S

[Bee]

Code: Selecteer alles

SQL Error : 1064 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 '<> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_vi

en

Code: Selecteer alles

SQL Error : 1064 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 '<> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_vi

Komen bij mij hetzelfde over. Ik vraag me af of je wel de goede versie gebruikt?

[dorque]

goede versie van phpbb of van pcp?

[Bee]

goede versie van phpbb of van pcp?

PCP!

[dorque]

Je had gelijk, in v2 doet ie dat niet

Weet iemand trouwens of er een nederlandse vertaling van pcp is?

[Paul]

Ja, die is er niet