Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Apr 2003
Posts: 359
Enthusiast
Enthusiast
Joined: Apr 2003
Posts: 359
Version: 6.5
============

Issue I'm having is within the Control Panel when I attempted to ban a member. I went into the Member Management option and selected the member. I went into his permissions and unchecked the box indicating the member has access. From there I clicked on Update Member and this is what I got as an output:

Script: /home/smoknz28/public_html/ubbthreads/admin/showuser.php
Line#: 577
SQL Error: 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 ') AND Bo_Active='1' ORDER BY Bo_Cat,Bo_Sorter' at line 3
SQL Error #: 1064
Query: SELECT Bo_Number,Bo_Title,Bo_Keyword,Bo_Cat,Bo_CatName,Bo_Sorter FROM w3t_Boards WHERE () AND Bo_Active='1' ORDER BY Bo_Cat,Bo_Sorter


Please assist....

Sponsored Links
Joined: Nov 2004
Posts: 25
Newbie
Newbie
Offline
Joined: Nov 2004
Posts: 25
i always do it this way

Member Mangement
Search for member
Place tick to left of member (Sel)

Action Drop down box

Select "Ban Member"

Hit "Perform Selected Action"

Joined: Apr 2003
Posts: 359
Enthusiast
Enthusiast
Joined: Apr 2003
Posts: 359
Ah thanks Phoenix....yea, I think I figured out why this occured... I had unchecked all the boxes that the member was set up for in Groups. I think the software doesn't like members not being set to any particular Group.

Joined: Nov 2004
Posts: 25
Newbie
Newbie
Offline
Joined: Nov 2004
Posts: 25
[]smoknz28 said:
Ah thanks Phoenix....yea, I think I figured out why this occured... I had unchecked all the boxes that the member was set up for in Groups. I think the software doesn't like members not being set to any particular Group. [/]

yeah, no group = a mess


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,157
Joined: July 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)