Previous Thread
Next Thread
Print Thread
Hop To
Anonymous
Unregistered
Anonymous
Unregistered
there are 3 columns. What is the purpose of the 3 columns in the read/write groups?
Sherri

Anonymous
Unregistered
Anonymous
Unregistered
We've been trying to figure that one out all day too!! We've been trying assign the various boards read/write access, but haven't figured out what these 3 columns are for??
Mickalo

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
There should be several groups listed in this area with checkboxes next to them. If you want that group to have that particular privilege for that forum you would place a checkmark next to the group. If you do not want them to have that privilege then you would make sure there is no checkmark next to the group.

-------------------

Scream

<a target="_blank" href=http://www.wwwthreads.com>WWWThreads</a>

Anonymous
Unregistered
Anonymous
Unregistered
I understand this much but why are they in there 3 times?
Column one:
Administrators

Guests

Users

Moderators
Column two:
Moderators

Administrators

Guests

Users
Column three:
Users

Moderators

Administrators

Guests
Let's say if I wanted to ban any guests from posting, do I check the box next to the guests in all 3 columns or just one? Just wondering what the purpose of having these listed 3 times instead of once.
Sherri

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
It looks like you have multiple groups in your w3t_Groups table. Did you do a fresh install when you purchased or did you upgrade? Just trying to figure out how those extra groups got in there, because they shouldn't be listed 3 times.
What you can do is go to a mysql prompt mysql -u username databasename -p and execute the following query. (Note this will remove any custom groups you have added)
DELETE FROM w3t_Groups WHERE G_Id > 4;
-------------------

Scream

<a target="_blank" href=http://www.wwwthreads.com>WWWThreads</a>

Anonymous
Unregistered
Anonymous
Unregistered
We have the same problems! And we installed the lastest version(PHP)!

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Did you do a fresh install or upgrade from the demo? Need to know where to look on the redundant group problem.

-------------------
Scream
<A target="_blank" HREF=http://www.wwwthreads.com>WWWThreads</A>

Anonymous
Unregistered
Anonymous
Unregistered
We first install the previous version, 5.1.4 I believe, then installed the required updated files for the new version 5.1.5 for PHP. Nothing had been done with the board while the 5.1.4 version was installed. The forum was set up after the upgrade.
Just to add to this, I just pulled up the w3t_Groups table and there is definitely a redunance problem here. The groups where duplicated 3 times. Only one custom group was added, which is in the w3t_Groups table once. But the other default groups appear 3 times for each group. We only ran the install.php file ONCE.
Hope this may help
<P ID="edit"><FONT><EM>Edited by mickalo on 01/22/01 10:13 AM.</EM></FONT>

Anonymous
Unregistered
Anonymous
Unregistered
I did a fresh install of the beta and have upgraded since the beta.

Sherri

Anonymous
Unregistered
Anonymous
Unregistered
Scream,
Finally got around to try and delete the extra tables and got the following error:
mysql> mysql -u username databasename -p

-> DELETE FROM w3t_Groups WHERE G_Id > 4;

ERROR 1064: You have an error in your SQL syntax near 'mysql -u username databasename -p

DELETE FROM w3t_Groups WHERE G_Id > 4' at line 1
I of course changed the username and database to my username and database names.
I also have figured out how I got so many groups. Each time createtable.php is run, it creates a new set of tables. I had errors when running mine and after attempting to fix the errors, I would run createtable. Maybe there should be something added to createtable that comes up with an error message that says the tables have already been created so it won't happen again.
Sherri

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Once you are in the mysql prompt all you need to do is run the DELETE FROM line. mysql -u username databasename -p <-- This line is only needed to get to the mysql prompt itself.

-------------------

Scream

<a target="_blank" href=http://www.wwwthreads.com>WWWThreads</a>

Anonymous
Unregistered
Anonymous
Unregistered
Thanks Scream. I am a telnet newbie and guess I still have a lot to learn. Sorry. <img border="0" title="" alt="[Embarrassed]" src="images/icons/blush.gif" />

Sherri

Anonymous
Unregistered
Anonymous
Unregistered
I had the same problem, and, although I have not the faintest idea about SQL, i tried the command "DELETE FROM w3t_Groups WHERE G_Id > 4" in PHPMyAdmin and it worked. Groups-Problem gone.

I think this is a cool top also for a FAQ ?

Thanks Carl


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
3 members (rootman, Gizmo, Nightcrawler), 562 guests, and 186 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)