Previous Thread
Next Thread
Print Thread
Hop To
#39061 01/15/2004 8:16 AM
Joined: Jan 2004
Posts: 13
D
stranger
stranger
D Offline
Joined: Jan 2004
Posts: 13
Hi, don't know if anyone can help.

I run the forums at www.nepforums.co.uk/beehive for our community websites and the guy that set up our board is of little help at the moment.

The problem I'm having is that when an unregistered user tries to post on a forum it seems to delete the forum entirely.

I've had a look and we don't seem to have the generic 'guest' group (or any other group for that moment) so that I can set the forum to lock these guys out.

I've created other groups so that people can register and use the boards, but how do I go about creating a 'guest' group, so I can lock people who haven't registered for our service ? Or how can I retrieve the initial set-up for groups?

Thanks for any help you can give.
Darren.

#39062 01/15/2004 1:39 PM
Joined: Jun 2006
Posts: 742
enthusiast
enthusiast
Joined: Jun 2006
Posts: 742
Run this query - and let me know the results:

SELECT *
FROM w3t_Groups


Joshua Pettit
Web Developer
www.ThreadsDev.net | www.JoshuaPettit.com
#39063 01/19/2004 6:45 AM
Joined: Jan 2004
Posts: 13
D
stranger
stranger
D Offline
Joined: Jan 2004
Posts: 13
Thanks here are the results...

G_Name G_Id
Members 1
Moderators 2
TEST 3
Users 4
test2 5
Mods 6
Members 7
Guests 8

Thanx.
Dazza.

#39064 01/19/2004 7:41 AM
Joined: Jan 2004
Posts: 13
D
stranger
stranger
D Offline
Joined: Jan 2004
Posts: 13
is it possible to delete all these groups and start again from scratch >?

I can't see how to do this in the admin site.

Tnx once again.

#39065 01/19/2004 12:05 PM
Joined: Jun 2006
Posts: 742
enthusiast
enthusiast
Joined: Jun 2006
Posts: 742
Guests should be group 3 -

I wouldn't delete the groups as that'll create more problems.

Also, does your user table have the placeholder user for anonymous posts?

Try this query.

SELECT U_Username
FROM w3t_Users
WHERE U_Number = 1


Joshua Pettit
Web Developer
www.ThreadsDev.net | www.JoshuaPettit.com
#39066 01/21/2004 5:48 AM
Joined: Jan 2004
Posts: 13
D
stranger
stranger
D Offline
Joined: Jan 2004
Posts: 13
Results are

U_Username

Theres nothing else in there.

Thanks.
D

Last edited by Dazza; 01/21/2004 6:03 AM.
#39067 01/21/2004 4:27 PM
Joined: Jun 2006
Posts: 742
enthusiast
enthusiast
Joined: Jun 2006
Posts: 742
OK - there's supposed to be a placeholder user there which somehow is missing or got deleted.

This query should fix you up:


INSERT INTO w3t_Users
(U_Username,U_Groups)
VALUES
('**DONOTDELETE**','-4-')


Joshua Pettit
Web Developer
www.ThreadsDev.net | www.JoshuaPettit.com
#39068 01/21/2004 6:49 PM
Joined: Jan 2004
Posts: 13
D
stranger
stranger
D Offline
Joined: Jan 2004
Posts: 13
Hi I'm afraid that didn't seem to work.

I ran the query, however I can still login as anon and post and reply to messages, and when I run the previous SQl query again its still blank.


On the plus side the forum is picking up. Though i'm crossing my fingers someone won't come along and wipe a whole forum out again!

Guess we must have not installed it correctly at the very beginning.

Thanks for your patience so far.

Daz.

Last edited by Dazza; 01/21/2004 6:54 PM.
#39069 01/21/2004 7:37 PM
Joined: Jan 2004
Posts: 13
D
stranger
stranger
D Offline
Joined: Jan 2004
Posts: 13
Hi Josh,
just an update after a bit of fiddling with my forum settings I think I've got the desired effect, though a very messy set of groups.

Thanks for your help.
Daz.

#39070 12/30/2004 8:54 AM
Joined: Dec 2004
Posts: 1
J
stranger
stranger
J Offline
Joined: Dec 2004
Posts: 1
Hi,

We've just upgraded a number of forums (v6.2.1.1) from Perl/cgi to use PHP/MySQL and have a similar problem in that there are no groups in the groups table.

What are the 'standard' groups? The imported boards table seems to refer to group ids 1,2,3 & 4 and the users table referes to grioups 1 & 3 but we don't know what these groups are to add them into the table - they don't seem to exist in the perl version.

And what is this extra user you refer to? The user with U_Number 1 on the imported databases is the administrator.

Thanks
Jon

#39071 12/30/2004 3:45 PM
Joined: Jun 2006
Posts: 742
enthusiast
enthusiast
Joined: Jun 2006
Posts: 742
This topic is a year old. <img src="https://www.ubbcentral.com/boards/images/graemlins/tongue.gif" alt="" />

User #1 in threads is a placeholder user for anonymous posts and users who were deleted.

The standard groups should be:
1- Administrator
2- Moderator
3- Users
4- Guests (users who aren't logged in)

If you follow the import instructions correct, you'll first setup your threads database (that number 1 user should be there by default, as well as the groups). Did you empty the database before importing? If so you would have emptied some stuff which needs to be there.


Joshua Pettit
Web Developer
www.ThreadsDev.net | www.JoshuaPettit.com

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM
Who's Online Now
0 members (), 868 guests, and 467 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 20230217)