Mitgliederliste klappt ab ca. 1700 User nicht mehr

[Maxi]

Also bis 1700 Use rhat er ja funktioniert. Bezüglich Mitgliederliste ist eigentlich zu V 1.3 nichts mehr hinzugekommen. Die Abfrage muß da schon immer so gewesen sein.

Gibts denn eventuell ein anderes Script um eine einfache Mitgliederliste anzuzeigen?

[larsneo]

memory_limit 40M 40M

damit sollte es eigentlich keine probleme geben - ausser wenn der code memory leaks aufweist (und das ist im standalone 2.0.8a definitiv nicht der fall)

Bezüglich Mitgliederliste ist eigentlich zu V 1.3 nichts mehr hinzugekommen

was meinst du mit v1.3? wie phillip schon gesagt hat, wäre ein link zum problem ebenfalls ganz hilfreich...

[Maxi]

1.3 bedeutet das es eigentlich phpbb plus 1.3 ist. Ich weiß ich weiß, das ihr das modifizierte 2.06 hier nicht gerne supportet. Ich würde jetzt auch lieber 2.06 einsetzen und selber ausbauen - aber nun ist das Forum schon soweit ausgebaut und so viele kleine Bugs korrigiert das es ein enormer Aufwand wäre zu wechseln.

Vielleicht könnt ihr mir trotzdem helfen

[Maxi]

So sieht die ganze Fehlermeldung aus:

Could not read user informations

DEBUG MODE

SQL Error : 2008 MySQL client run out of memory

SELECT DISTINCT u.*, (CASE WHEN u.user_from_flag = 'blank.gif' THEN '' ELSE TRIM(LEADING ' ' FROM SUBSTRING(LPAD(u.user_from_flag, 25, ' '), 1, 21)) END) as user_flag, (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ((CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) = 1) OR ( (u.user_allow_viewonline = 1) OR ( (u.user_allow_viewonline = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) as user_online_display, (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_email = 1) AND ( (u.user_viewemail = 1) OR ( (u.user_viewemail = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) as user_email_display, (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_pm = 1) AND ( (u.user_viewpm = 1) OR ( (u.user_viewpm = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) as user_pm_display, (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_website = 1) AND ( (u.user_viewwebsite = 1) OR ( (u.user_viewwebsite = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) as user_www_display, (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_messanger = 1) AND ( (u.user_viewmessanger = 1) OR ( (u.user_viewmessanger = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) as user_messanger_display, (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) as user_real_display, (CASE WHEN i.buddy_ignore = 0 THEN 1 ELSE 0 END) as user_my_friend, (CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) as user_my_ignore, (CASE WHEN i.buddy_visible = 1 THEN 1 ELSE 0 END) as user_my_visible, (CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) as user_friend, (CASE WHEN b.buddy_ignore = 1 THEN 1 ELSE 0 END) as user_ignore, (CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) as user_visible , (CASE WHEN i.buddy_ignore = 0 THEN 1 ELSE 0 END) as user_my_friend, (CASE WHEN (u.user_session_time >= 1082468680) AND ((CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ((CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) = 1) OR ( (u.user_allow_viewonline = 1) OR ( (u.user_allow_viewonline = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) = 1) THEN 1 ELSE 0 END) as user_online, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_pm = 1) AND ( (u.user_viewpm = 1) OR ( (u.user_viewpm = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) = 1 THEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_pm = 1) AND ( (u.user_viewpm = 1) OR ( (u.user_viewpm = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) ELSE 0 END) as user_pm, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_email = 1) AND ( (u.user_viewemail = 1) OR ( (u.user_viewemail = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_email ELSE '' END) as user_email_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_messanger = 1) AND ( (u.user_viewmessanger = 1) OR ( (u.user_viewmessanger = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_icq ELSE '' END) as user_icq_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_messanger = 1) AND ( (u.user_viewmessanger = 1) OR ( (u.user_viewmessanger = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_aim ELSE '' END) as user_aim_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_messanger = 1) AND ( (u.user_viewmessanger = 1) OR ( (u.user_viewmessanger = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_yim ELSE '' END) as user_yim_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_messanger = 1) AND ( (u.user_viewmessanger = 1) OR ( (u.user_viewmessanger = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_msnm ELSE '' END) as user_msnm_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ((CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) = 1) OR ( (u.user_allow_viewonline = 1) OR ( (u.user_allow_viewonline = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_regdate ELSE 0 END) as user_regdate_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ((CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) = 1) OR ( (u.user_allow_viewonline = 1) OR ( (u.user_allow_viewonline = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_lastvisit ELSE 0 END) as user_lastvisit_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ((CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) = 1) OR ( (u.user_allow_viewonline = 1) OR ( (u.user_allow_viewonline = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_posts ELSE 0 END) as user_posts_virt, (CASE WHEN ((CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_website = 1) AND ( (u.user_viewwebsite = 1) OR ( (u.user_viewwebsite = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) = 1) THEN ( COALESCE(sr.rank_title, SUBSTRING(MAX(CONCAT(LPAD(nr.rank_min,8,'0'), nr.rank_title)), 9)) ) ELSE '' END) as user_rank_title, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_website = 1) AND ( (u.user_viewwebsite = 1) OR ( (u.user_viewwebsite = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_timezone ELSE 0 END) as user_timezone_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_website = 1) AND ( (u.user_viewwebsite = 1) OR ( (u.user_viewwebsite = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_lang ELSE '' END) as user_lang_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_website = 1) AND ( (u.user_viewwebsite = 1) OR ( (u.user_viewwebsite = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_website ELSE '' END) as user_website_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_realname ELSE '' END) as user_realname_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_gender ELSE 0 END) as user_gender_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_birthday ELSE '' END) as user_birthday_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_from ELSE '' END) as user_from_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_occ ELSE '' END) as user_occ_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_interests ELSE '' END) as user_interests_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_home_phone ELSE '' END) as user_home_phone_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_home_fax ELSE '' END) as user_home_fax_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_work_phone ELSE '' END) as user_work_phone_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_work_fax ELSE '' END) as user_work_fax_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_cellular ELSE '' END) as user_cellular_virt, (CASE WHEN (CASE WHEN (u.user_id = 9) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_pager ELSE '' END) as user_pager_virt FROM (((((phpbb_users as u LEFT JOIN phpbb_flags as f ON f.flag_image = u.user_from_flag) LEFT JOIN phpbb_buddy as b ON b.user_id=u.user_id AND b.buddy_id=9) LEFT JOIN phpbb_buddy as i ON i.user_id=9 AND i.buddy_id=u.user_id) LEFT JOIN phpbb_ranks as sr ON u.user_rank > 0 AND sr.rank_special = 1 AND u.user_rank = sr.rank_id) LEFT JOIN phpbb_ranks as nr ON u.user_rank = 0 AND nr.rank_special = 0 AND nr.rank_min <= u.user_posts) WHERE u.user_id <> -1 GROUP BY u.user_id ORDER BY u.username ASC, u.username ASC

Line : 734
File : ... /phpBB2/profilcp/profilcp_buddy.php

[larsneo]

das statement bekommt von mir den ehrenpreis für massiven ressourcenverbrauch

ich kann dir eigentlich nur raten, kontakt mit den phpbb plus autoren aufzunehmen - nachdem die mitgliederliste im standalone auch bei *wirklich* umfangreichen boards einwandfrei funktioniert liegt die vermutung ja nun doch recht nahe, dass das statement zumindestens 'suboptimal' ist.
zugegebenermassen reicht mein bescheidenes wissen wohl schlichtweg auch nicht aus, um zu verstehen, was '('1' = '1')' etc. im o.a. statement überhaupt bewirken sollen...

[Maxi]

Ich kann auch nicht verstehen wer sich so eine SQL Abfrage ausgedacht hat. Leider hat mir bislang bei phpbb2 keiner wirklich helfen können.

Notfalls werd ich wohl komplett eigenes Script für Mitgliederanzeige basteln müssen - so schwierig kann das Script ja nu auch nicht sein.