Get your forum today!

Enrichary · 11-26-2007, 07:52 AM

Hi
I get this message when try to delete aserveral groups in http://blacksuneve.14.forumer.com/
Can someone help me with it.
email: mpcylo@yahoo.com

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 blacksuneve_users u, blacksuneve_user_group ug WHERE ug.group_id = 3 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

Enrichary · 11-29-2007, 05:46 AM

Email = Ympcylo@yahoo.com

Enrichary · 11-30-2007, 04:35 AM

Could not obtain user info for moderator list

DEBUG MODE

SELECT user_id, username FROM blacksuneve_users WHERE user_id = 8

Line : 119
File : admin_groups.php

**Attitude** · 11-30-2007, 09:25 AM

Ok, let me confirm this and I will fill in a report.

**SawanM** · 11-30-2007, 10:26 AM

Read this thread for lots of information on how to fix this.

Enrichary · 12-02-2007, 05:18 PM

Quote:

Originally Posted by Attitude

Ok, let me confirm this and I will fill in a report.

Still waiting for this.

**SawanM** · 12-03-2007, 12:25 PM

To be honest, it does not need a report, you can fix this yourself and the bug is a part of phpBB2 itself.

Enrichary · 12-04-2007, 02:46 PM

Quote:

Originally Posted by SawanM0112

To be honest, it does not need a report, you can fix this yourself and the bug is a part of phpBB2 itself.

I have read this and I am a nono in php.
That is why I am using blacksun :: Home
from forumer.

GoochVET · 03-19-2008, 05:44 PM

I have the same error about the moderators missing in the groups. I have learned from my mistakes but I am stuck with two groups that are inactive so to speak.

Can someone help me please

Tuitam · 03-20-2008, 05:01 PM

Quote:

Originally Posted by GoochVET

I have the same error about the moderators missing in the groups. I have learned from my mistakes but I am stuck with two groups that are inactive so to speak.

Can someone help me please

I have fixed those two groups for you.

Cheers, Tuitam

GoochVET · 03-21-2008, 09:39 PM

Thanks So Much

Greatly Appreciated

**Wild Cat** · 03-21-2008, 09:54 PM

Support Resolved!

If you have any further questions, feel free to create a new thread.

Thanks for choosing Forumer!

11-26-2007, 07:52 AM	#1 (permalink)
Enrichary Member Join Date: Sep 2007 Posts: 5 Rep Power: 0 fTrader: (0) fBuck$: 170 Bank: 0 Total fBuck$: 170 Send fBuck$ » My Forumer My Country:	[RESOLVED] bug deleting group Hi I get this message when try to delete aserveral groups in http://blacksuneve.14.forumer.com/ Can someone help me with it. email: mpcylo@yahoo.com 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 blacksuneve_users u, blacksuneve_user_group ug WHERE ug.group_id = 3 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

11-29-2007, 05:46 AM	#2 (permalink)
Enrichary Member Join Date: Sep 2007 Posts: 5 Rep Power: 0 fTrader: (0) fBuck$: 170 Bank: 0 Total fBuck$: 170 Send fBuck$ » My Forumer My Country:	Re: bug deleting group Email = Ympcylo@yahoo.com

11-30-2007, 04:35 AM	#3 (permalink)
Enrichary Member Join Date: Sep 2007 Posts: 5 Rep Power: 0 fTrader: (0) fBuck$: 170 Bank: 0 Total fBuck$: 170 Send fBuck$ » My Forumer My Country:	Re: bug deleting group Could not obtain user info for moderator list DEBUG MODE SELECT user_id, username FROM blacksuneve_users WHERE user_id = 8 Line : 119 File : admin_groups.php

11-30-2007, 09:25 AM	#4 (permalink)
Attitude VIP Team Join Date: Oct 2004 Location: Right Coast Posts: 11,765 Blog Entries: 3 Rep Power: 16 fTrader: (11) fBuck$: 4,856 Bank: 3 Total fBuck$: 4,859 Send fBuck$ » My Forumer My Country:	Re: bug deleting group Ok, let me confirm this and I will fill in a report.
	Grand Opening of Florida Host! Take 20% off of already discounted rates that includes semi-annually and annually plans! See homepage for details.

11-30-2007, 10:26 AM	#5 (permalink)
SawanM Confessed Noob Join Date: Dec 2006 Tournaments Won: 2 Posts: 8,965 Rep Power: 12 fTrader: (35) fBuck$: 70,767 Bank: 0 Total fBuck$: 70,767 Send fBuck$ » My Forumer My Country:	Re: bug deleting group Read this thread for lots of information on how to fix this.
	Sezza Web Directory Top Web Hosting Reviews\|Top 10 Web Hosting\|Web Host Rating Tu ne cede malis, sed contra audentior ito Do not give in to evil but proceed ever more boldly against it!

Get your forum today!

Explore

Support

About

12-03-2007, 12:25 PM	#7 (permalink)
SawanM Confessed Noob Join Date: Dec 2006 Tournaments Won: 2 Posts: 8,965 Rep Power: 12 fTrader: (35) fBuck$: 70,767 Bank: 0 Total fBuck$: 70,767 Send fBuck$ » My Forumer My Country:	Re: bug deleting group To be honest, it does not need a report, you can fix this yourself and the bug is a part of phpBB2 itself.
	Sezza Web Directory Top Web Hosting Reviews\|Top 10 Web Hosting\|Web Host Rating Tu ne cede malis, sed contra audentior ito Do not give in to evil but proceed ever more boldly against it!

03-19-2008, 05:44 PM	#9 (permalink)
GoochVET Member Join Date: Jan 2008 Posts: 3 Rep Power: 0 fTrader: (0) fBuck$: 56 Bank: 0 Total fBuck$: 56 Send fBuck$ » My Forumer My Country:	Re: bug deleting group I have the same error about the moderators missing in the groups. I have learned from my mistakes but I am stuck with two groups that are inactive so to speak. Can someone help me please

03-21-2008, 09:39 PM	#11 (permalink)
GoochVET Member Join Date: Jan 2008 Posts: 3 Rep Power: 0 fTrader: (0) fBuck$: 56 Bank: 0 Total fBuck$: 56 Send fBuck$ » My Forumer My Country:	Re: bug deleting group Thanks So Much Greatly Appreciated

03-21-2008, 09:54 PM	#12 (permalink)
Wild Cat Elite Forumer Join Date: May 2007 Location: UK Posts: 4,787 Rep Power: 7 fTrader: (3) fBuck$: 167 Bank: 121,300 Total fBuck$: 121,467 Send fBuck$ » My Forumer My Country:	Re: bug deleting group Support Resolved! If you have any further questions, feel free to create a new thread. Thanks for choosing Forumer!
	[No Name Forums][RCX forums][Forum Promotion][IHWC forums] USEFUL TIP: If your support request gets resolved, click on THREAD TOOLS > MARK THIS THREAD AS SOLVED. This will mark the thread RESOLVED and will close the thread. (please use this tip!)

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

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Who is deleting?	beard1973	IPB General Support	4	07-14-2007 05:35 PM
Deleting	Enia07	phpBB2 General Questions	2	12-28-2006 12:20 PM
Group Icons & Deleting Emoticons	hannee	IPB General Support	2	05-20-2006 02:42 AM
Removing the "Group:" in front of user-group	Idhren	IPB General Support	2	04-01-2005 07:38 PM
Deleting User Group	cyclops101	IPB General Support	2	01-27-2005 05:55 AM