Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Error creating multiple group permissions
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Error creating multiple group permissions

 Post Reply Post Reply
Author
Aadilya View Drop Down
Newbie
Newbie


Joined: 19 February 2003
Location: Canada
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote Aadilya Quote  Post ReplyReply Direct Link To This Post Topic: Error creating multiple group permissions
    Posted: 03 March 2003 at 3:19pm

I'm sure this isn't a problem with the app, rather a mental block on my part.  Either way, help would be appreciated.

I've set up a number of Categories in my forum, and want a specific non-ladder group (Contributor) to be the only ones with access to specific categories.

I've set those categories up with generic forum permissions of Private across the board.  I then go into Group Permissions Admin, select the first forum, and add permissions to allow Contributor access to read, write, etc.

The problem arises when I go to the next forum and attempt to add Group Permissions.  I Create New Forum Permissions for User Group, select Contributor, check the boxes and get:

Microsoft JET Database Engine error '80040e21'

The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

/forum/admin/create_group_permissions.asp, line 128

when I click the submit button.  It doesn't appear to allow me give Contributor access to more than one forum.

Thoughts?

 

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 03 March 2003 at 3:26pm
Some upgrade scripts don't work correctly, try using the original fresh database if you can, also the database may have become corrupted, starting from scratch may solve the problem as error handling should mean that this error should never happen.
Back to Top
Aadilya View Drop Down
Newbie
Newbie


Joined: 19 February 2003
Location: Canada
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote Aadilya Quote  Post ReplyReply Direct Link To This Post Posted: 03 March 2003 at 4:40pm

Is there anything manually I can look at to try to resolve it?  I used St8dog's script for the conversion, and this is the only thing that's cropped up and bit me.

I also tried the DB conversion script in your DL section, but after a successful upgrade, it won't let admin in.. it tells me that only users with appropriate access are allowed.. lol

 

Back to Top
Aadilya View Drop Down
Newbie
Newbie


Joined: 19 February 2003
Location: Canada
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote Aadilya Quote  Post ReplyReply Direct Link To This Post Posted: 07 March 2003 at 3:53pm

bump

Aad

 

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 07 March 2003 at 4:33pm
A fresh install or sticking with the old version maybe your only option.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.