Faster group error

This mod is a fix for original phpbb2, it works when you look up a large usergroup, here on mods.db9.dk without this mod it takes +30 sek to look up the group "everyone" details. after this mod is applyed it takes approx 1 sek

Moderator: Moderators

Forum rules
The content in this forum is dated Dec. 21 2005 and can be used as Archive only. This Forum is LOCKED and READ ONLY !

Faster group error

Postby Blisk on Thu 30. Oct, 2003 10:03

I get this error!

Error getting user list for group

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near '0, 50' at line 7

SELECT u.username, u.user_id, u.user_viewemail, u.user_posts, u.user_regdate, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_msnm, ug.user_pending FROM phpbb_users u, phpbb_user_group ug WHERE ug.group_id = 4 AND u.user_id = ug.user_id AND ug.user_pending = 0 AND ug.user_id <> 3 ORDER BY u.usernameLIMIT 0, 50

Line : 844
File : /html/forum/groupcp.php
Blisk
Poster
Poster
 
Posts: 128
Joined: Wed 20. Aug, 2003 14:14

Postby test on Thu 06. Nov, 2003 00:29

you are missing a space here

u.usernameLIMIT

should be

u.username LIMIT
test
Poster
Poster
 
Posts: 20
Joined: Wed 10. Apr, 2002 03:00

Postby strauss on Thu 21. Jul, 2005 15:15

ÏÎÄÀÐÊÈ êàòàëîã Èíòåðíåò ðåñóðñîâ. www.wwwp.ru
strauss
Poster
Poster
 
Posts: 3
Joined: Wed 13. Jul, 2005 07:29


Return to Large groups fix [2.0.8/EM]

Who is online

Users browsing this forum: No registered users and 0 guests

cron