Register Log In

UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support Unchecking User produced this error

Print Thread

Hop To

Unchecking User produced this error #197769 09/20/2007 3:15 PM
Joined: Jul 2006 Posts: 91 T tee journeyman
tee journeyman T Joined: Jul 2006 Posts: 91	Hi all. On our forum (version 6.5) one of our admins did this: Quote "Rats... rather than ban the member, I thought I would try taking away their ability to post until our Chief Admin could decide if he should be banned outright... so I unticked 'user' in his profile... which apparently wasn't the right way to go about doing it. I got the following error message: Script: /raid/home/kickas/kickas/ubbthreads/admin/showuser.php Line#: 577 SQL Error: You have an error in your SQL syntax near ') AND Bo_Active='1' ORDER BY Bo_Cat,Bo_Sorter ' at line 4 SQL Error #: 2000 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 We cannot get in to edit the user any more. Any help would be greatly appreciated. Thanks very much, Tee http://www.kickas.org http://www.kickas.org/ubbthreads/ubbthreads.php?ubb=cfrm

Re: Unchecking User produced this error tee #197777 09/20/2007 5:16 PM
Joined: Apr 2007 Posts: 3,940 Likes: 1 SoCal, USA SD Former Developer
SD Former Developer Joined: Apr 2007 Posts: 3,940 Likes: 1 SoCal, USA	hehe, you are going to have to manually put him back in a group. being in nO group kills the where clause. hrm.. i can't remember what 6.5x db looks like, but you need to add at least one group to his user profile.. i think groups used to be a string like -x-y- or whatever.. you can do that in phpmyadmin.. someone who knows the structure could supply the actual fields, but the query is going to look like update w3t_Users set User_Groups='-3-' where user_ID=xxx xxx woould be the user's id and the -3- is a wild assed guess on what group you need to put him in.

Re: Unchecking User produced this error SD #197778 09/20/2007 5:20 PM
Joined: Apr 2007 Posts: 3,940 Likes: 1 SoCal, USA SD Former Developer
SD Former Developer Joined: Apr 2007 Posts: 3,940 Likes: 1 SoCal, USA	ok, i found an old 65x db.. the syntax is: update w3t_Users set U_Groups='-3-' where U_Number=xxx xxx is user number in DB -3- is group 3 (but you should choose one that fits your board)

Re: Unchecking User produced this error SD #197781 09/20/2007 5:43 PM
Joined: Jul 2006 Posts: 91 T tee journeyman
tee journeyman T Joined: Jul 2006 Posts: 91	Thanks Sirdude, we appreciate the help! http://www.kickas.org http://www.kickas.org/ubbthreads/ubbthreads.php?ubb=cfrm

Link Copied to Clipboard

Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.

Version 7.7.5 Images suddenly not displaying
by Stovebolt - 05/04/2024 11:19 AM

Bots
by Outdoorking - 04/13/2024 5:08 PM

Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM

Who's Online Now

1 members (Ruben), 764 guests, and 215 robots.

Key: Admin, Global Mod, Mod

Random Gallery Image

Latest Gallery Images

Los Angeles

Los Angeles
by isaac, August 6

3D Creations

3D Creations
by JAISP, December 30

Artistic structures

Artistic structures
by isaac, August 29

Stones

Stones
by isaac, August 19

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