Previous Thread
Next Thread
Print Thread
Hop To
Joined: Mar 2007
Posts: 36
Likes: 1
B
BB
Offline
Newbie
Newbie
B Offline
Joined: Mar 2007
Posts: 36
Likes: 1
Hi,

I upgraded from 7.0 to 7.4. I notice many settings are disabled by default in this update (e.g. permission to view user profile). When I went to the Control Panel and changed the setting to enable viewing of user profile, I received the following error message:

Script: dositeperms.php
Line#: 85
SQL Error: Column 'CUSTOM_TITLE' specified twice
SQL Error #: 1110
Query: replace into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,EXT_INFO,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,SIGNATURE_IMAGES,EXT_INFO,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE) values (1,'1','1','1','1','1','1','20000','100','1','500','1','1','1','1','1','1','1','0','0','1','1','1','1','1','1','20000','100','1','500','1','1','1','1','1','1','1','0','0')

I get the same message while changing other settings.

Joined: Mar 2007
Posts: 36
Likes: 1
B
BB
Offline
Newbie
Newbie
B Offline
Joined: Mar 2007
Posts: 36
Likes: 1
Haven't seen any response to this... No one else has seen this error? Any idea what might be wrong?

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
It seems like maybe you have the CUSTOM_TITLE duplicated in the ubbt_PERMISSION_LIST table. It builds the update dynamically off of what is in that table.

Probably the easiest thing would be to open up a support ticket with your admin info so I can take a look at that table.


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)