Error in groupcp.php

Posted: Tue Mar 20, 2007 4:13 pm

thought i would mention this, I had noticed this awhile back in the previous release of RavenNuke, still there in the current version. In the forums of fisubice, clicked on usergroups, when you try to view info on groups you are in.

Code:

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 nuke_users u, nuke_bbuser_group ug WHERE ug.group_id = '15' AND u.user_id = ug.user_id AND ug.user_pending = '0' AND ug.user_id <> ORDER BY u.username





Line : 801


File : groupcp.php

Site Admin Joined: Jun 04, 2004 Posts: 6433

Doh....wish you had mentioned it before RN 2.1.0 was released!

Posted: Tue Mar 20, 2007 4:35 pm

wow, that was fast.... my apologies.... i figured y'all had enough on your hands Smile

and was hopefull that a fresh install of the latest ravennuke would cure what ailed me Smile

i guess it possible it's on my end, but it has responded the same on 2 different hosts now... (the latter being raven hosting)

HitsFan

but a bright spot, in the future I will make sure to report any findings asap, i really appreciate all the hard work you all have done...

Posted: Tue Mar 20, 2007 5:14 pm

Please post the exact url which you clicked so that I can reproduce this. Thanks.

Posted: Tue Mar 20, 2007 6:08 pm

im using shortlinks so it looks like so:

Code:

http://www.mysite.com/forums-groupcp.html

but in the previous distro it was:

Code:

http://www.mysite.com/modules.php?name=Forums&file=groupcp

the error occurs when you select a group from the drop down menu and click "view information"

Question

you didnt need the actual url to my site did you?

UPDATE:
Just noticed it works fine for viewing the only public group I have. The issue seems to be isolated to the private groups (of which I am a member)

ANOTHER UPDATE:
Tried this again with an group moderator and reg. user acct and although the page appears ok when viewing the previously mentioned public group, it only displays the group moderator and says "This group has no members" under "Group Members"... even though the reg. acct i tested was a member of the group....

Posted: Tue Mar 20, 2007 8:19 pm

The error you talked about in groupcp.php on line 801 doesn´t exist in the new version of RavenNuke. In older forums versions its a sign that you have e.g. a group without moderator or you deleted a member/mod.
However, I created 3 different kind of groups and I don´t see any problem.
Logged in as registered member I was able to see the information in the different usergroups.
I´m sure that Evaders can confirm that there isn´t any problem.
However, I usally use NSN Groups because thats much better.

Posted: Tue Mar 20, 2007 8:42 pm

well i thank you for your time looking into this Smile

i will say that this is a clean install but with a upgraded database from the previous version of ravennuke. maybe i have an error in my tables somewhere.... not really an often used feature so I'll put it on my list (near the bottom Smile

)

and....

I am using NSN groups... these same "usergroups" were created automatically (i think... i sure didnt create them) when I made the NSN groups.

btw, the NSN groups are great! It's one of the MANY reasons I chose RavenNuke in the 1st place! Smile

I went a little overboard with about 25 groups, all with unique privledges (which makes me dizzy at times Razz

), but has been a great feature for our site.

Posted: Fri Mar 23, 2007 8:57 pm

Quote:

In older forums versions its a sign that you have e.g. a group without moderator or you deleted a member/mod.

thats exactly what it was - thanks Smile

Posted: Fri Mar 23, 2007 9:19 pm

i did have one other question though, as i was browsing the bb_groups table noticed there are lots of entries (150+) listed as:

Personal User
group_type 1
group_moderator 0
group_single_user 1

are these legitimate? or should i delete them?

Posted: Sat Mar 24, 2007 3:48 am

You should not touch this !
"Personal User" is corret has something to do with Chatservs group patch. I found this entries in my 6.5 version also after I added his patch long time ago.

Posted: Sat Mar 24, 2007 2:32 pm

Essentially all users are tied to a personal group. This controls the user permissions for specific forums, usergroups, etc. Coding-wise, it makes no difference to an individual user or a usergroup.. they are still part of a "group"