Nukemods Forum  
» Log in
User Name:

Password:

Not a member yet?
Register Now!
» Online Users: 89
3 members and 86 guests
celedxebritwb9b, lowsad4erback5s, pai5drdnters6sa
Most users ever online was 611, 03-21-2008 at 10:10 PM.
» .::.
» .:.

Go Back   Nukemods Forum > PHP-Nuke 7.x > Nuke 7.x - General

Reply
 
LinkBack Thread Tools Display Modes
Usergroups / Moderators SQL Error : 1064
Old
  (#1 (permalink))
Junior Member
 
Status: Offline
Posts: 9
Join Date: Feb 2005
Usergroups / Moderators SQL Error : 1064 - 07-28-2005, 03:50 PM

Hey guys Im back again :twisted:

Anyway I have a problem when I go to the usergroups and click view information on moderators I get

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 = '3' AND u.user_id = ug.user_id AND ug.user_pending = '0' AND ug.user_id <> ORDER BY u.username

Line : 796
File : /home/obvious2/public_html/nuke/modules/Forums/groupcp.php


Any help would be greatly appreciated.
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#2 (permalink))
Junior Member
 
Status: Offline
Posts: 9
Join Date: Feb 2005
08-11-2005, 06:55 PM

Im guessing I stumpted the chumps huh?
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
phpnuke SQL Error : 1064 Sparax Nuke 7.x - General 4 12-28-2006 03:07 PM
How do I add moderators?? DavidM Open topics 1 10-08-2006 01:49 AM
Error SQL Error : 1064 theme iCGstation XelAleX Nuke 7.x - Themes 0 03-21-2005 05:17 PM
More than 3 usergroups? Locutus Nuke 6.5 to 6.9 - Modules 7 05-19-2003 05:13 AM
Trying to set Moderators for Forums... BorgX Purged Topics 6 01-28-2003 06:10 PM




vBulletin Skin developed by: vBStyles.com


LinkBacks Enabled by vBSEO 3.3.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31