Get your forum today!

AWritersFantasy · 09-14-2007, 12:17 PM

For the past two days I've been getting this error when I go to look at the list of members of one of my board's usergroups:

Quote:

Error getting user list for group

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 'ORDER BY u.username' 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 inspiredwriters_users u, inspiredwriters_user_group ug WHERE ug.group_id = 39 AND u.user_id = ug.user_id AND ug.user_pending = 0 AND ug.user_id <> ORDER BY u.username

Line : 796
File : groupcp.php

It only does it for one usergroup, the others are fine. Any idea what's up and how I can fix it?

Tuitam · 09-15-2007, 07:26 AM

Q: What's wrong?
A: You (or any other admin) have deleted the group moderator. This kinda bug in phpBB2.

Q: Any idea how to fix it?
A1: Send me (PM) your login details and I'll do it for you.
A2: Do a search for my posts containing "group" or "usergroup". The answer is somewhere out there too.

Tuitam

**SawanM** · 09-15-2007, 07:33 AM

1- Create a temporary user.
2- Using Opera Browser, go to ACP and open the temporary user in a new tab (so you wont have frames).
3- Display the source code.
4- Search for: <input type="hidden" name="id" value="nn" />
Replace with: <input type="hidden" name="id" value="xx" />
Where nn is the id number of the temporary user and xx the id number of the user you want to delete.
5- Click «Reload from cache».
6- In the reloaded page, try to deleted the temporary user but in fact, the unwanted user will be deleted.

From Tuitam

AWritersFantasy · 09-15-2007, 01:57 PM

Quote:

Originally Posted by Tuitam

Q: What's wrong?
A: You (or any other admin) have deleted the group moderator. This kinda bug in phpBB2.

Q: Any idea how to fix it?
A1: Send me (PM) your login details and I'll do it for you.
A2: Do a search for my posts containing "group" or "usergroup". The answer is somewhere out there too.

Tuitam

No one deleted the usergroup because 1. no one else knows how to probably besides me and I didn't do it 2. I can still see it listed in the admin panel still so it's not deleted.

I'll PM you with the login info for the second admin account I created as a back up.

Tuitam · 09-15-2007, 04:45 PM

The issue has been fixed. The user group "Inspired RPers" is accessible now.

The problem was that after deleting user with ID=31 (there is a gap between ennui - 30 and Jasmine Hart - 34), you have lost the access to that group. Such situation should be prevented by phpBB2 software but apparently there is no such check built-in into phpBB2 scripts.

You need to verify wether I have set the appropriate group moderator, change the group description and check the group permissions.

Cheers, Tuitam

AWritersFantasy · 09-15-2007, 04:52 PM

I deleted the account of the original person who had been running that usergroup, but only because they were inactive. No one else in that gap that was effected should have made a difference since only one person can be made a moderator of a usergroup.

You chose the right person as the moderator, and I'll look at the permissions. Thanks for fixing it.

09-15-2007, 07:26 AM	#2 (permalink)
Tuitam Active Forumer Join Date: Feb 2005 Posts: 555 Rep Power: 4 fTrader: (0) fBuck$: 8,261.1 Bank: 0.0 Total fBuck$: 8,261.1 Send fBuck$ » My Forumer My Country:	Re: Usergroup bug Q: What's wrong? A: You (or any other admin) have deleted the group moderator. This kinda bug in phpBB2. Q: Any idea how to fix it? A1: Send me (PM) your login details and I'll do it for you. A2: Do a search for my posts containing "group" or "usergroup". The answer is somewhere out there too. Tuitam
	tuitam.forumer.com

09-15-2007, 07:33 AM	#3 (permalink)
SawanM Hem Hem Join Date: Dec 2006 Posts: 10,936 Rep Power: 14 fTrader: (47) fBuck$: 25,697.0 Bank: 0.0 Total fBuck$: 25,697.0 Send fBuck$ » My Forumer My Country:	Re: Usergroup bug 1- Create a temporary user. 2- Using Opera Browser, go to ACP and open the temporary user in a new tab (so you wont have frames). 3- Display the source code. 4- Search for: <input type="hidden" name="id" value="nn" /> Replace with: <input type="hidden" name="id" value="xx" /> Where nn is the id number of the temporary user and xx the id number of the user you want to delete. 5- Click «Reload from cache». 6- In the reloaded page, try to deleted the temporary user but in fact, the unwanted user will be deleted. From Tuitam
	Car Hifi Top Web Hosting Reviews\|Top 10 Web Hosting\|Web Host Rating I swear to drunk, I am not God.

09-15-2007, 04:45 PM	#5 (permalink)
Tuitam Active Forumer Join Date: Feb 2005 Posts: 555 Rep Power: 4 fTrader: (0) fBuck$: 8,261.1 Bank: 0.0 Total fBuck$: 8,261.1 Send fBuck$ » My Forumer My Country:	Re: Usergroup bug The issue has been fixed. The user group "Inspired RPers" is accessible now. The problem was that after deleting user with ID=31 (there is a gap between ennui - 30 and Jasmine Hart - 34), you have lost the access to that group. Such situation should be prevented by phpBB2 software but apparently there is no such check built-in into phpBB2 scripts. You need to verify wether I have set the appropriate group moderator, change the group description and check the group permissions. Cheers, Tuitam
	tuitam.forumer.com

09-15-2007, 04:52 PM	#6 (permalink)
AWritersFantasy Junior Forumer Join Date: Jun 2007 Posts: 73 Rep Power: 2 fTrader: (0) fBuck$: 425.0 Bank: 0.0 Total fBuck$: 425.0 Send fBuck$ » My Forumer My Country:	Re: Usergroup bug I deleted the account of the original person who had been running that usergroup, but only because they were inactive. No one else in that gap that was effected should have made a difference since only one person can be made a moderator of a usergroup. You chose the right person as the moderator, and I'll look at the permissions. Thanks for fixing it.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Get your forum today!

Explore

Support

About

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Usergroup Pictures?	KMWLOL	IPB General Support	4	01-30-2007 11:18 AM
can some say how can make new usergroup	manhaunt	IPB Skinning Help	2	12-21-2006 05:59 PM
usergroup error	foc	phpBB2 Bug Reports	6	10-19-2006 03:36 PM
How can I add members to a usergroup?	BMFrabato	IPB General Support	1	09-12-2006 12:31 PM
Usergroup Help	imported_sti	IPB General Support	4	03-12-2004 04:24 PM