Pagina 1 van 1
Foutje bij Profile Control Panel
Geplaatst: 22 mei 2005, 10:57
door 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
Geplaatst: 22 mei 2005, 11:21
door 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?
Geplaatst: 22 mei 2005, 11:55
door 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
Mist waarschijnlijk een variabelen, die dus leeg is.
Geplaatst: 22 mei 2005, 12:17
door dorque
En wat moet ik dan nu doen??
Geplaatst: 22 mei 2005, 12:18
door 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
)
Geplaatst: 22 mei 2005, 13:28
door dorque
bee schreef: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?
Geplaatst: 22 mei 2005, 14:20
door 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.
Geplaatst: 22 mei 2005, 17:49
door 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
Geplaatst: 22 mei 2005, 18:44
door 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?
Geplaatst: 29 mei 2005, 20:25
door dorque
goede versie van phpbb of van pcp?
Geplaatst: 29 mei 2005, 20:52
door Bee
dorque schreef:goede versie van phpbb of van pcp?
PCP!
Geplaatst: 03 jun 2005, 14:24
door dorque
Je had gelijk, in v2 doet ie dat niet
Weet iemand trouwens of er een nederlandse vertaling van pcp is?
Geplaatst: 03 jun 2005, 14:40
door Paul
Ja, die is er niet