Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
Trying to do a mass copy of permissions from the new forum template to the majority of my forums.

It says it has completed, but when I view the permissions on a forum, they have not copied over.

Any suggestions on a fix?

Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
In fact I am also unable to copy from the new forum template to any forum manually under 'Forum Permissions'.

I can however update the new forum template fine.

Joined: Dec 2003
Posts: 6,649
Likes: 88
Joined: Dec 2003
Posts: 6,649
Likes: 88
Yep it seems to be only when using the template to copy from.
If you use both copy methods with a new forum it works.
I used the edit post time limit setting for a test.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
When running the mass copy function using another forum apart from the default template, I get the following error....

Script: /path/to/forums/admin/copy_forumperms.php
Line#: 131
SQL Error: Duplicate entry '1-157' for key 1
SQL Error #: 1062
Query: update ubbt_FORUM_PERMISSIONS set GROUP_ID = 1,FORUM_ID = 157,USE_HTML = 1,USE_MARKUP = 1,FILE_TOTAL = 5,FILE_SIZE = 200000,POLLS_IN_TOPICS = 1,POLLS_IN_REPLIES = 1,POSTS_ARE_MODERATED = '0',SEE_FORUM = 1,READ_TOPICS = 1,READ_REPLIES = '0',CREATE_TOPICS = 1,CREATE_REPLIES = 1,GALLERY_TOTAL = 5,GALLERY_SIZE = 200000,AD_ISLAND = 1,EDIT_POSTS = 360,DELETE_POSTS = 15,LOCK_ANY = 1,MOVE_ANY = 1,DELETE_ANY = 1,EDIT_ANY = 1,STICKY_ANY = 1,APPROVE_ANY = 1,CAPTCHA = '0',CAN_DOWNLOAD = 1,POST_THROTTLE = '0',DELETE_TOPICS = 1 where GROUP_ID = 1 and FORUM_ID = 157

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
I think you've got a bit of database stuff going on there. Since it's not trying to add anything, and only updating values that are indexed already, I think there might be an underlying issue.

If you want to PM me with your admin info or open a support ticket I can take a looksee.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Slow Queries - Any Ideas?
by BellaOnline - 10/16/2026 4:34 PM
Selling a Forum?
by ECNet - 10/10/2026 10:54 AM
PHP 8 bug in membermanage.tmpl
by phoenix011235 - 09/08/2026 7:47 PM
Who's Online Now
3 members (BellaOnline, Gizmo, 1 invisible), 199 guests, and 123 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Ride safe!
Ride safe!
by Morgan, December 7
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 8.1.0
(Snapshot build 20260527)